Hello. I'm a newbie with respect to Oracle and DBI/DBD, so please bear with
me...
I'm trying to use DBD::Oracle to retrieve info from a read-only database. I
am successful on an HP-UX 11.0 machine when using the Oracle 8i sqlplus
command and when using perl 5.6.1 / DBI-1.20 / DBD::Oracle-1.06 (built by
somebody else). But I wish to run my work on a Redhat 7.3 Linux system,
which already has perl 5.6.1 and DBI-1.21 installed. So I installed Oracle
9i, then built and installed DBD::Oracle-1.12.
On the Redhat 7.3 system I am successful when using the Oracle 9i sqlplus
command, but when I use the DBD::Oracle that I built I run into problems.
The connect seems to succeed, but I get ORA-03113 errors on virtually all of
the SELECT statements I try. I can successfully execute this statement:
SELECT column_name, char_col_decl_length FROM all_tab_columns WHERE
table_name = 'BLDG_BUILDINGS'
But when I try to SELECT something out of the BLDG_BUILDINGS view (or for
that matter, seemingly any SELECT that retrieves from a real table or view):
SELECT * FROM bldg_buildings WHERE short_bldg = '33-12'
my perl script pauses for 5 seconds or so and then I get this error:
ORA-03113: end-of-file on communication channel (DBD ERROR:
OCIStmtExecute)
The perl script is identical in both cases - works on the HP-UX 11 system
but not on the Redhat 7.3 system.
I spent a couple of hours searching the web and the archives of this list to
no avail. Any advice?
Thanks,
Conrad Kimball
Associate Technical Fellow
Client Server Technical Management, Shared Services Group
[EMAIL PROTECTED]
P.O.Box 24346, MS 7M-HC
Seattle, WA 98124-0346
Bellevue 33-12 bldg, cube 37C3
Phone: (425) 865-6410
Pager: (206) 797-3112
Cell: (425) 591-7802
