DBD::Oracle 1.16 on OSX 10.3 running Oracle 10.1 (ORA 00600 error)
As described in the subject, I'm getting an ORA-00600 error. It is =
intermittent (happening about 50%) of the time and is not
dependent on having a long datatype in the table I'm selecting from. The =
actual error is:
DBD::Oracle::st execute failed: ORA-00600: internal error code,
arguments: [kpofdr-long], , , , , , , 
which I get on doing various types of select statements.
I believe this is a bug in Oracle 10.1 (Oracle bug note 3612581.8) . The =
problem here is that Oracle 10 release 2 may not be released for a few =
months. And there is no...Re: DBD::Oracle doesn't work with Oracle 10g (10.1.0.3) under Mac OS X (10.3.8) or how to make it working?
Hermez, et al,
On Apr 9, 2005, Hermez <4Hertz@gmx.de> wrote:
> After painful days and nights, trying to make DBD::Oracle working
> with Oracle 10g Release 1 (10.1.0.3) on Mac OS X, I am at my wits'
> I have started the hard trip with the Oracle instant client and even
> the above mentioned full version doesn't lead to a solution.
> Afterwards, I have followed the advice mentioned in README.macosx
> (included in DBD::Oracle), and installed Perl from scratch. Without
> progress, unfortunately.
> Let me describe the affected envir...DBD-Oracle-1.03 and DBD-Oracle-1.06 FAIL make test #3
I also forgot to mention that I'm attempting this install on HP/UX 11.0.
...DBD::Oracle 1.19 with Oracle instantclient 10.2.0.3
I wanted to contribute my experience with the compilation of DBD::Oracle 1.19 with the Oracle InstantClient 10.2.0.3 on Debian Etch.
I mainly followed the guide on http://jeanchristophe.duber.free.fr/dbd_oracle_instantclient_linux/
That documentation is based on an older Oracle InstantClient v10.1.0.3, so I had to make some modifications...
I will quickly point out my steps:
- Download DBD::Oracle (http://search.cpan.org/CPAN/authors/id/P/PY/PYTHIAN/DBD-Oracle-1.19.tar.gz)
- Download Oracle InstantClient 10.2.0.3 (http://www.oracle.com/technology/software/tech/oci/instan...Oracle Instant Client 10.1.0.3 SDK and DBD::Oracle
The latest patch set (10.1.0.3) for the Oracle Instant Client 10g includes
the long awaited SDK.
I had a quick look at it, and it seems Oracle decided to put the header =
in the traditional /usr/include and /usr/share directories. This won't =
out of the box with DBD::Oracle, as it's tuned to having the header files
available relative to $ORACLE_HOME.
These are the current locations of the library and header files for the
Instant Client 10g:
[###### oic]$ rpm -q -l -p oracle-instantclient-basic-10.1.0.3-1.i386.rpm
/usr/lib/oracle/10.1.0.3/client/lib/c...symbol lookup error for DBD-Oracle 1.19 and Oracle instantclient 10.2.0.3
I'm trying to get an Oracle client working under Linux and I'm having
problems running a test script. Here's the error:
[koczan@ator] lab $ perl oracle.pl
perl: symbol lookup error:
undefined symbol: OCINlsEnvironmentVariableGet
And here are details: I'm using Oracle's instantclient 10.2.0.3 and
stock DBD-Oracle 1.19 (except for I downloaded Makefile-instantclient.PL
and oracle-instantclient-config from
http://jeanchristophe.duber.free.fr/dbd_oracle_instantclient_l...DBD::Oracle-1.10 build problem with Oracle-8.1.7
[ I'm not on the mailing list, so I apologize if this is already a known
reported problem. Also, if this is insufficient information please
let me know and I can supply a full verbose report as directed in
the README. ]
Attempting to build DBD::Oracle-1.10 under Solaris-2.6 and
Oracle-8.1.7, I encountered the following compilation error:
oci8.c: In function `oci_hdtype_name':
oci8.c:118: `OCI_DTYPE_DATETIME' undeclared (first use in this function)
oci8.c:118: (Each undeclared identifier is reported only once
oci8.c:118: for each function it appears in.)
oci...DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3 on Debian Etch won't install
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
I am having a problem setting up DBD::Oracle version 1.19 on a Debian
Etch. I am running perl 5.8.8 and have dbi 1.53 (I believe) installed. I
have instantclient-basic, instantclient-devel, and sqlplus installed. I
can, without a problem, connect to my external DB Server via sqlplus. I
have ORACLE_HOME and LD_LIB path set everything works great, and I am
I have several times installed DBD::Oracle 1.19 on Debian Etch without
an...Oracle 9i, DBI 1.12 & DBD-Oracle 1.20 Problems
I was hoping some kind soul on here could assist me with a problem I am
having compiling the DBD-Oracle 1.12 driver. I have read the documentation
and have not found conclusive proof that DBI & the Oracle DBD drivers are
supported under Oracle 9i. Has anybody gotten DBD & DBI to work under
Oracle 9i from a new install (not an upgrade)?
Make run on DBD-Oracle 1.12 fails with error:
ld: /usr/oracle/product/9.0.1/rdbms/lib/defopt.o: Mismatched ABI. 64-bit PA
object file found in 32-bit link.
HPUX 11i Mission Critical...Oracle 9i, DBI 1.12 & DBD-Oracle 1.20 Problems #2
I am also trying make DBD::Oracle on hp-ux 11i, 64bit kernel, running Oracle
I have installed perl 5.6.1, DBD version 1.28 and running make for
get exactly the same error;
ld: /oracle/app/product/9.0.1/rdbms/lib/defopt.o: Mismatched ABI. 64-bit PA
object file found in 32-bit link.
*** Error exit code 1
/usr/bin/make -- NOT OK
I see you concluded after making changes and getting the make, make test and
install to kind of succeed, you ...DBD::Oracle 1.19 tests core against Oracle 10.2.0.1
I'm trying to get DBD::Oracle to work on Solaris 9 but I'm getting core
files during the test phase. I've tried all the hints suggested in both
the README and README.help.txt files with the same result. Any
# uname -a
SunOS carnivore 5.9 Generic_112233-07 sun4u sparc SUNW,Sun-Fire-V240
# perl Makefile.PL -v
Using DBI 1.54 (for perl 5.008008 on sun4-solaris-thread-multi-64int)
installed in /opt/VRTSperl/lib/site
Configuring DBD::Oracle for perl 5.008008 on ...DBD::ORACLE (1.12) DBI(1.30)
I am trying to do either :-
Retrieve data from an Oracle table with a nested table column
Retrieve data from an Oracle object table based on an object which contains
a nested table
Either attempt results in :-
DBD::Oracle::db selectrow_array failed: ERROR OCIDefineObject call needed
but not implemented yet
Works when attempting a select against a table with no objects in it. So I
am guessing this is not supported.
Is there a way around this issue?
...DBD::Oracle 1.12 vs HP-UX 11.11 on L-Class with Oracle 220.127.116.11
My appologies if my client threw in too many line breaks.
Perl 5.6.1 on HP-UX 11.11 with DBI 1.2, Oracle 18.104.22.168
in /opt/local/appdev/software/oracle/product/8.1.7, ANSI C compiler. When doing
a make test during install, I get this:
Running make test
PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -
I/usr/ulairi_perl/lib/5.6.1/PA-RISC2.0 -I/usr/ulairi_perl/lib/5.6.1 -e 'use
Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/base............../usr/lib/dld.sl: Can't open shared
library: /hpx/work/ee/22.214.171.124/hpx32/src_1221/li...CYGWIN 1.5.10-3, DBD_oracle-1.15, Oracle 10.1.0
Please ignore my previous message...
$ make test
/usr/bin/perl.exe "-MExtUtils::Command::MM" "-e" "test_harness(0,
t/general....ok 2/24Can't get
ecognised attribute at t/general.t line 41.
t/general....FAILED test 5
Failed 1/24 tests, 95.83% okay
Oracle 7 didn't strip trailing spaces, Oracle 8 did,...