Hi all,
Don't know if anyone else has encountered this....
I'm using DBI and Access, I insert a number of rows into a table, and then
at the end call prepare and execute an Insert that calls a query for it's
values. If I run the two with seperate processes, this is no problem. If I
try to perform the second insert directly after, the query executes ok, but
on the return from the function the script hangs as if something is going
out of scope. I can trace into OLE.pm, and in the FETCH method it hangs.
Can help with this, I'm kinda at a loss.
Regards,
Jeff Butler
> -----Original Message-----
> From: Prasanna Gopalakrishna [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 18, 2001 1:47 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: RE: Error in DBD::Oracle Installation
> Sensitivity: Confidential
>
> Yes. I do have following links in $ORACLE_HOME/lib
> any suggestion?
>
> -rwxr-xr-x 1 oracle 800 6721160 Apr 20 2000 libclntsh.so
> -rwxr-xr-x 1 oracle 800 6796000 Mar 29 09:24 libclntsh.so.1.0
> -rwxr-xr-x 1 root other 6721160 Mar 29 09:21 libclntsh.so.1.0.tmp
> -rw-r--r-- 1 oracle staff 9255260 Jun 22 2000 libclntsh.so.8.0
>
>
>
> >
> > From: Mohanjit Singh <[EMAIL PROTECTED]>
> > Date: 2001/04/17 Tue PM 01:42:49 EDT
> > To: Prasanna Gopalakrishna <[EMAIL PROTECTED]>
> > Subject: RE: RE: Error in DBD::Oracle Installation
> >
> > Do u have following symbolic links under $ORACLE_HOME/lib
> >
> > lrwxrwxrwx 1 root monitor 16 Jul 12 2000 libclntsh.so ->
> > libclntsh.so.8.0
> > -rwxr-xr-x 1 root monitor 9828696 Jul 12 2000 libclntsh.so.8.0
> >
> >
> >
> > -----Original Message-----
> > From: Prasanna Gopalakrishna [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, April 17, 2001 1:32 PM
> > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > Subject: Re: RE: Error in DBD::Oracle Installation
> > Sensitivity: Confidential
> >
> >
> > Still running around with the same problem. I wonder this could be the
> > problem! not sure...
> >
> > i) Do I need to set ORACLE_USER along with ORACLE_HOME, ORACLE_SID,
> > LD_LIBRARY_PATH environment before install DBD::Oracle
> > If yes who? admin or any db-user?
> >
> >
> > ii) also, do need to install any other Oracle client libraries. (Sqlplus
> > works though!)
> >
> >
> >
> >
> > >
> > > From: "Sterin, Ilya" <[EMAIL PROTECTED]>
> > > Date: 2001/04/17 Tue AM 10:50:11 EDT
> > > To: 'Prasanna Gopalakrishna ' <[EMAIL PROTECTED]>,
> "'[EMAIL PROTECTED] '"
> > > <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED] '" <[EMAIL PROTECTED]>
> > > Subject: RE: Error in DBD::Oracle Installation
> > >
> > > Make sure your LD_LIBRARY_PATH is set correctly for the username which
> is
> > > installing DBD::Oracle
> > >
> > > Ilya Sterin
> > >
> > > -----Original Message-----
> > > From: Prasanna Gopalakrishna
> > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Sterin, Ilya
> > > Sent: 04/17/2001 10:29 AM
> > > Subject: Error in DBD::Oracle Installation
> > > Sensitivity: Confidential
> > >
> > > Hi DBI-USERS, Tim, Ilya, ...
> > >
> > >
> > > I'm trying install DBD::Oracle on Solaris machine and tried all
> options
> > > as mentioned in the README.xxx files. Still having same problem when
> > > running make test.
> > > SQLPLUS works good on this machine. Any suggestions appreciated.
> > >
> > > Thanks
> > >
> > > Find an log for 'make' and 'make test' follows...
> > >
> > >
> > > Sun OS 5.7
> > > Perl 5.005_03 (provided by Interwoven Teamsite)
> > > Oracle 8.0.3
> > > DBI-1.15
> > > DBD-Oracle-1.06
> > >
> > >
> > >
> > >
> > > # make
> > > mkdir blib
> > > mkdir blib/lib
> > > mkdir blib/lib/DBD
> > > mkdir blib/arch
> > > mkdir blib/arch/auto
> > > mkdir blib/arch/auto/DBD
> > > mkdir blib/arch/auto/DBD/Oracle
> > > mkdir blib/lib/auto
> > > mkdir blib/lib/auto/DBD
> > > mkdir blib/lib/auto/DBD/Oracle
> > > mkdir blib/man1
> > > mkdir blib/man3
> > > cp Oraperl.pm blib/lib/Oraperl.pm
> > > cp Oracle.pm blib/lib/DBD/Oracle.pm
> > > cp oraperl.ph blib/lib/oraperl.ph
> > > /home/iw-home/iw-perl/bin/perl -p -e "s/~DRIVER~/Oracle/g" <
> > >
> /home/iw-home/iw-perl/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI/Dr
> > > iver.xst > Oracle.xsi
> > > /home/iw-home/iw-perl/bin/perl
> > > -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris
> > > -I/home/iw-home/iw-perl/lib/perl5/5.00503
> > > /home/iw-home/iw-perl/lib/perl5/5.00503/ExtUtils/xsubpp -typemap
> > > /home/iw-home/iw-perl/lib/perl5/5.00503/ExtUtils/typemap Oracle.xs
> > > >xstmp.c && mv xstmp.c Oracle.c
> > > gcc -c -I. -I/home/oracle/precomp/public -I/home/oracle/rdbms/public
> > > -I/home/oracle/rdbms/demo -I/home/oracle/plsql/public
> > > -I/home/oracle/network/public -I/home/oracle/rdbms/demo
> > > -I/home/oracle/rdbms/demo
> > >
> -I/home/iw-home/iw-perl/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI
> > > -I/usr/local/include -O -DVERSION=\"1.06\" -DXS_VERSION=\"1.06\"
> > > -fPIC -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE
> -Wall
> > > -Wno-comment Oracle.c
> > >
> /home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE/patchlevel.h:4
> > > 1: warning: `local_patches' defined but not used
> > > gcc -c -I. -I/home/oracle/precomp/public -I/home/oracle/rdbms/public
> > > -I/home/oracle/rdbms/demo -I/home/oracle/plsql/public
> > > -I/home/oracle/network/public -I/home/oracle/rdbms/demo
> > > -I/home/oracle/rdbms/demo
> > >
> -I/home/iw-home/iw-perl/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI
> > > -I/usr/local/include -O -DVERSION=\"1.06\" -DXS_VERSION=\"1.06\"
> > > -fPIC -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE
> -Wall
> > > -Wno-comment dbdimp.c
> > > dbdimp.c: In function `ora_db_login6':
> > > dbdimp.c:250: warning: unsigned int format, long unsigned int arg (arg
> > > 5)
> > > dbdimp.c: In function `ora_st_destroy':
> > > dbdimp.c:1624: warning: unused variable `imp_dbh'
> > > dbdimp.c: At top level:
> > >
> /home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE/patchlevel.h:4
> > > 1: warning: `local_patches' defined but not used
> > > gcc -c -I. -I/home/oracle/precomp/public -I/home/oracle/rdbms/public
> > > -I/home/oracle/rdbms/demo -I/home/oracle/plsql/public
> > > -I/home/oracle/network/public -I/home/oracle/rdbms/demo
> > > -I/home/oracle/rdbms/demo
> > >
> -I/home/iw-home/iw-perl/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI
> > > -I/usr/local/include -O -DVERSION=\"1.06\" -DXS_VERSION=\"1.06\"
> > > -fPIC -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE
> -Wall
> > > -Wno-comment oci7.c
> > >
> /home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE/patchlevel.h:4
> > > 1: warning: `local_patches' defined but not used
> > > gcc -c -I. -I/home/oracle/precomp/public -I/home/oracle/rdbms/public
> > > -I/home/oracle/rdbms/demo -I/home/oracle/plsql/public
> > > -I/home/oracle/network/public -I/home/oracle/rdbms/demo
> > > -I/home/oracle/rdbms/demo
> > >
> -I/home/iw-home/iw-perl/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI
> > > -I/usr/local/include -O -DVERSION=\"1.06\" -DXS_VERSION=\"1.06\"
> > > -fPIC -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE
> -Wall
> > > -Wno-comment oci8.c
> > > oci8.c: In function `dbd_rebind_ph_rset':
> > > oci8.c:414: warning: implicit declaration of function
> > > `pp_rebind_ph_rset_in'
> > > oci8.c: In function `dbd_rebind_ph_lob':
> > > oci8.c:435: warning: unsigned int format, ub4 arg (arg 5)
> > > oci8.c: In function `init_lob_refetch':
> > > oci8.c:1214: warning: value computed is not used
> > > oci8.c: At top level:
> > >
> /home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE/patchlevel.h:4
> > > 1: warning: `local_patches' defined but not used
> > > Running Mkbootstrap for DBD::Oracle ()
> > > chmod 644 Oracle.bs
> > > LD_RUN_PATH="/home/oracle/lib" gcc -o
> > > blib/arch/auto/DBD/Oracle/Oracle.so -R/home/oracle/lib -G
> > > -L/usr/local/lib Oracle.o dbdimp.o oci7.o oci8.o
> > > -L/home/oracle/lib/ -lagent -lextp -licx -lndw1 -lnlsrtl3 -lplsf
> > > -lserver -lsqlplus -lepc -lnetv2 -lnttcp -lpsa -lslax -lepcpt -licd
> > > -lncr -lnetwork -lplsb -lpsd -lsql -lclntsh -lcore4 -lclient -lcommon
> > > -lgeneric -lmm -lc -laio -lm -lc
> > > chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so
> > > cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
> > > chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
> > > /home/iw-home/iw-perl/bin/perl -Iblib/arch -Iblib/lib
> > > -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris
> > > -I/home/iw-home/iw-perl/lib/perl5/5.00503 ora_explain.PL ora_explain
> > > Extracted ora_explain from ora_explain.PL with variable substitutions.
> > > mkdir blib/script
> > > cp ora_explain blib/script/ora_explain
> > > /home/iw-home/iw-perl/bin/perl
> > > -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris
> > > -I/home/iw-home/iw-perl/lib/perl5/5.00503 -MExtUtils::MakeMaker -e
> > > "MY->fixin(shift)" blib/script/ora_explain
> > > Manifying blib/man3/DBD::Oraperl.3
> > > Manifying blib/man3/DBD::Oracle.3
> > > Manifying blib/man1/ora_explain.1
> > >
> > >
> > >
> > >
> > > # make test
> > > PERL_DL_NONLAZY=1 /home/iw-home/iw-perl/bin/perl -Iblib/arch
> -Iblib/lib
> > > -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris
> > > -I/home/iw-home/iw-perl/lib/perl5/5.00503 -e 'use Test::Harness
> > > qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
> > > t/base..............FAILED tests 4-5
> > > Failed 2/5 tests, 60.00% okay
> > > t/general...........install_driver(Oracle) failed: Can't load
> > > 'blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1:
> > > /home/iw-home/iw-perl/bin/perl: fatal: relocation error: file
> > > blib/arch/auto/DBD/Oracle/Oracle.so: symbol lsfmai: referenced symbol
> > > not found at
> > > /home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/DynaLoader.pm
> line
> > > 169.
> > >
> > > at (eval 1) line 3
> > > Perhaps a required shared library or dll isn't installed where
> expected
> > > at t/general.t line 20
> > > dubious
> > > Test returned status 255 (wstat 65280, 0xff00)
> > > t/long..............Can't load 'blib/arch/auto/DBD/Oracle/Oracle.so'
> for
> > > module DBD::Oracle: ld.so.1: /home/iw-home/iw-perl/bin/perl: fatal:
> > > relocation error: file blib/arch/auto/DBD/Oracle/Oracle.so: symbol
> > > lsfmai: referenced symbol not found at
> > > /home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/DynaLoader.pm
> line
> > > 169.
> > >
> > > at t/long.t line 4
> > > BEGIN failed--compilation aborted at t/long.t line 4.
> > > dubious
> > > Test returned status 255 (wstat 65280, 0xff00)
> > > t/plsql.............Can't load 'blib/arch/auto/DBD/Oracle/Oracle.so'
> for
> > > module DBD::Oracle: ld.so.1: /home/iw-home/iw-perl/bin/perl: fatal:
> > > relocation error: file blib/arch/auto/DBD/Oracle/Oracle.so: symbol
> > > lsfmai: referenced symbol not found at
> > > /home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/DynaLoader.pm
> line
> > > 169.
> > >
> > > at t/plsql.t line 17
> > > BEGIN failed--compilation aborted at t/plsql.t line 17.
> > > dubious
> > > Test returned status 255 (wstat 65280, 0xff00)
> > > t/reauth............skipping test on this platform
> > > Failed Test Status Wstat Total Fail Failed List of failed
> > >
> ------------------------------------------------------------------------
> > > -------
> > > t/base.t 5 2 40.00% 4-5
> > > t/general.t 255 65280 ?? ?? % ??
> > > t/long.t 255 65280 ?? ?? % ??
> > > t/plsql.t 255 65280 ?? ?? % ??
> > > 1 test skipped.
> > > Failed 4/5 test scripts, 20.00% okay. 2/5 subtests failed, 60.00%
> okay.
> > > *** Error code 29
> > > make: Fatal error: Command failed for target `test_dynamic'
> > >
> > >
> > >
> > >
> > >
> > > # make test TEST_VERBOSE=1
> > > PERL_DL_NONLAZY=1 /home/iw-home/iw-perl/bin/perl -Iblib/arch
> -Iblib/lib
> > > -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris
> > > -I/home/iw-home/iw-perl/lib/perl5/5.00503 -e 'use Test::Harness
> > > qw(&runtests $verbose); $verbose=1; runtests @ARGV;' t/*.t
> > > t/base..............1..5
> > > ok 1
> > > ok 2
> > > ok 3
> > > FAILED tests 4-5
> > > Failed 2/5 tests, 60.00% okay
> > > t/general...........install_driver(Oracle) failed: Can't load
> > > 'blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1:
> > > /home/iw-home/iw-perl/bin/perl: fatal: relocation error: file
> > > blib/arch/auto/DBD/Oracle/Oracle.so: symbol lsfmai: referenced symbol
> > > not found at
> > > /home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/DynaLoader.pm
> line
> > > 169.
> > >
> > > at (eval 1) line 3
> > > Perhaps a required shared library or dll isn't installed where
> expected
> > > at t/general.t line 20
> > > dubious
> > > Test returned status 255 (wstat 65280, 0xff00)
> > > t/long..............Can't load 'blib/arch/auto/DBD/Oracle/Oracle.so'
> for
> > > module DBD::Oracle: ld.so.1: /home/iw-home/iw-perl/bin/perl: fatal:
> > > relocation error: file blib/arch/auto/DBD/Oracle/Oracle.so: symbol
> > > lsfmai: referenced symbol not found at
> > > /home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/DynaLoader.pm
> line
> > > 169.
> > >
> > > at t/long.t line 4
> > > BEGIN failed--compilation aborted at t/long.t line 4.
> > > dubious
> > > Test returned status 255 (wstat 65280, 0xff00)
> > > t/plsql.............Can't load 'blib/arch/auto/DBD/Oracle/Oracle.so'
> for
> > > module DBD::Oracle: ld.so.1: /home/iw-home/iw-perl/bin/perl: fatal:
> > > relocation error: file blib/arch/auto/DBD/Oracle/Oracle.so: symbol
> > > lsfmai: referenced symbol not found at
> > > /home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/DynaLoader.pm
> line
> > > 169.
> > >
> > > at t/plsql.t line 17
> > > BEGIN failed--compilation aborted at t/plsql.t line 17.
> > > dubious
> > > Test returned status 255 (wstat 65280, 0xff00)
> > > t/reauth............ORACLE_USERID_2 not defined.
> > > Tests skiped.
> > > 1..0
> > > skipping test on this platform
> > > Failed Test Status Wstat Total Fail Failed List of failed
> > >
> ------------------------------------------------------------------------
> > > -------
> > > t/base.t 5 2 40.00% 4-5
> > > t/general.t 255 65280 ?? ?? % ??
> > > t/long.t 255 65280 ?? ?? % ??
> > > t/plsql.t 255 65280 ?? ?? % ??
> > > 1 test skipped.
> > > Failed 4/5 test scripts, 20.00% okay. 2/5 subtests failed, 60.00%
> okay.
> > > *** Error code 29
> > > make: Fatal error: Command failed for target `test_dynamic'
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > My environment variables looks like follows....
> > >
> > > # env
> > > AVPAUDIT=/home/taxware/audit
> > > AVPIN=/home/taxware/indata
> > > AVPOUT=/home/taxware/outdata
> > > AVPTEMP=/home/taxware/temp
> > > DISPLAY=inetfwgui5.na.pg.com:0.0
> > > DYNAMO_HOME=/usr/atg/presiva/Dynamo4.5.0:.
> > > ERRMSGPATH=/home/taxware/lang/eng
> > > HOME=/home/tr5271
> > > HZ=100
> > > LD_LIBRARY_PATH=/home/oracle/lib:/usr/lib:/usr/ucblib
> > > LD_RUN_PATH=/home/oracle/lib
> > > LOGNAME=tr5271
> > > MAIL=/var/mail/tr5271
> > > ORACLE_BASE=/home/oracle
> > > ORACLE_HOME=/home/oracle
> > > ORACLE_SID=dev
> > >
> PATH=/home/iw-home/iw-perl/bin:/opt/NSCPcom:/home/oracle:/usr/openwin:/u
> > >
> sr/bin:/usr/ucb:/etc:.:/home/oracle/bin:/usr/sbin:/usr/lib:/usr/xpgr/bin
> > > :/usr/xpg4/bin
> > > PS1=#
> > > SHELL=/bin/sh
> > > STEPIN=/home/taxware/indata
> > > STEPOUT=/home/taxware/outdata
> > > TAXHOME=/home
> > > TERM=dtterm
> > > TNS_ADMIN=/home/oracle/network/admin
> > > TOOLKITEXE=/home/taxware/toolkit
> > > TOOLKITOUT=/home/taxware/tkout
> > > TXHOME=/home/taxware
> > > TZ=US/Eastern
> > > WTAUDIT=/home/taxware/audit
> > > WTCOUNTRY=US
> > > WTDB=/home/taxware/outdata
> > > WTHOME=/home/taxware
> > > WTIN=/home/taxware/indata
> > > WTLANG=ENG
> > > WTOUT=/home/taxware/outdata
> > > WTSYSTEM=/home/taxware/indata
> > > WTTEMP=/home/taxware/temp
> > > XUSERFILESEARCHPATH=/home/taxware/lang/eng/%N
> > > ZIPIN=/home/taxware/indata
> > > ZIPOUT=/home/taxware/outdata
> > > ZIPTEMP=/home/taxware/temp
> > > _INIT_PREV_LEVEL=S
> > > _INIT_RUN_LEVEL=3
> > > _INIT_RUN_NPREV=0
> > > _INIT_UTS_ISA=sparc
> > > _INIT_UTS_MACHINE=sun4u
> > > _INIT_UTS_NODENAME=go-ilaunch001
> > > _INIT_UTS_PLATFORM=SUNW,Ultra-4
> > > _INIT_UTS_RELEASE=5.7
> > > _INIT_UTS_SYSNAME=SunOS
> > > _INIT_UTS_VERSION=Generic_106541-11
> > > #
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>
