Re: DBD::Oracle: NUMBER type ambiguous in dbd_describe
Tim Bunce wrote: Thanks for the info. Do you have any strong objections to DBD::Oracle replicating the Oracle ODBC results? I just tested with an older driver. The Oracle 7.3 ODBC driver returns (via DBD::ODBC!): TYPE PREC SCALE NAME - - 2 38 0 CINTEGER 6 15 0 CNUMBER 2 38 0 CNUMBER_38_0 2 11 2 CNUMBER_11_2 2 38 2 CNUMBER_XX_2 6 15 0 CFLOAT 6 15 0 CFLOAT_11 6 15 0 CREAL 6 15 0 CDOUBLE_PRECISION 11 19 0 CDATE Compare it with 8.1.7 (BTW: I added a DATE column)! Type 2 is not the problem. Strictly speaking, it's better than type 3. But the prec. for FLOAT's is garbage! Now then: which Oracle ODBC results should be replicated? This one in oci7.c and the other one in oci8.c? Or always the results from the current version? If so, the best way is to number the DBI driver like this: DBD::Oracle733, DBD::Oracle817, DBD::Oracle9xx, ... Excuse me if I sound a bit sarcastic. But I hope DBI will continue to mean 'DataBase Independent'. FYI, here the results from a Visigenic driver: TYPE PREC SCALE NAME - - 3 38 0 CINTEGER 3 0 0 CNUMBER 3 38 0 CNUMBER_38_0 3 11 2 CNUMBER_11_2 3 38 2 CNUMBER_XX_2 8 15 0 CFLOAT 8 15 0 CFLOAT_11 8 15 0 CREAL 8 15 0 CDOUBLE_PRECISION Steffen
dbd::oracle 1.0.6 solaris 2.1.6
I've been having problem installing this perl module but got it working by following the README.JAVA. We were able to install and been using it thereafter to migrate ms-access to oracle. This is just for info. thanks. Eric
DBD::Oracle Installation problem
HP Unix 11.00; Oracle 8.1.7; gcc compiler; perl 5.6.0; When I run "make test" for DBD::Oracle,Following error message appeared : Test returned status 255 (wstat 65280, 0xff00) t/plsql./usr/lib/dld.sl: Can't shl_load() a library containing Threa d Local Storage: /usr/lib/libpthread.1 /usr/lib/dld.sl: Exec format error Can't load 'blib/arch/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle: Exec fo rmat error at /opt/perl5/lib/5.6.0/PA-RISC2.0/DynaLoader.pm line 200. at t/plsql.t line 17 Compilation failed in require at t/plsql.t line 17. BEGIN failed--compilation aborted at t/plsql.t line 17. t/plsql.dubious Test returned status 255 (wstat 65280, 0xff00) t/reauthskipped test on this platform Failed Test Status Wstat Total Fail Failed List of failed --- t/base.t 52 40.00% 4-5 t/general.t 255 65280?? ?? % ?? t/long.t255 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 exit code 2 My perl excutable is compiled by gcc.Most configures is using default value.Dose i need to change some configure value when compiling perl exutalbe? susan __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/
RE: :Oracle Installation problem
I had this very same problem with the same system (except we used the HP ANSI-C compiler). I struggled with this problem for two months and had no luck (getting this same error). I finally dropped back to 8.1.6 and it worked beautifully. Check the archives, I posted various messages about this issue - and even pushed the idea that there is a compatibility issue with Oracle 8.1.7 on HPUX with the DBD:Oracle module. I never recieved any responses on that notion, though. Brent Bowman -Original Message- From: yi susan [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 09:07 To: [EMAIL PROTECTED] Subject: DBD::Oracle Installation problem HP Unix 11.00; Oracle 8.1.7; gcc compiler; perl 5.6.0; When I run "make test" for DBD::Oracle,Following error message appeared : Test returned status 255 (wstat 65280, 0xff00) t/plsql./usr/lib/dld.sl: Can't shl_load() a library containing Threa d Local Storage: /usr/lib/libpthread.1 /usr/lib/dld.sl: Exec format error Can't load 'blib/arch/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle: Exec fo rmat error at /opt/perl5/lib/5.6.0/PA-RISC2.0/DynaLoader.pm line 200. at t/plsql.t line 17 Compilation failed in require at t/plsql.t line 17. BEGIN failed--compilation aborted at t/plsql.t line 17. t/plsql.dubious Test returned status 255 (wstat 65280, 0xff00) t/reauthskipped test on this platform Failed Test Status Wstat Total Fail Failed List of failed -- - t/base.t 52 40.00% 4-5 t/general.t 255 65280?? ?? % ?? t/long.t255 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 exit code 2 My perl excutable is compiled by gcc.Most configures is using default value.Dose i need to change some configure value when compiling perl exutalbe? susan __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/
simple question
Whats the difference between DBI 1.13 and 1.14? -- #!C:\perl\bin\perl.exe -wT print map {chr(ord($_)-3)} split //, "Dqguhdv0Vfkplw}Cw0rqolqh1gh"; # spammer dieser erde, ab in den gulli...
db disconnect
This may be more of a general Perl question than a DBI one, but since DBI is involved, I thought I'd ask anyway. I create a database handle called $dbh_sale. I want to ensure that this handle is destroyed at the end of the program... so, I wrote up this chunk of code END { $dbh_sale-disconnect(); ###this is line 155 } When doing a perl -c using Perl 5.00404, I get: test.pl syntax OK Can't call method "disconnect" without a package or object reference at test.pl line 155. END failed--cleanup aborted. However, I get no such error/warning when running under Perl 5.6.0. Since I am forced to use Perl 5.00404, I am concerned that this error could cause a problem down the line. Does anyone know why Perl 5.00404 is reporting this? Since I've only used Perl 5.00503 and Perl 5.6.0, I've never run into this problem before and I have no idea if this a really a bug or if it's just sloppy error reporting by the old interpreter. Thanks, Curt Crandall
Re: DBD::Oracle: NUMBER type ambiguous in dbd_describe
If you tell me which you'd like to see and why, and I like what you say, then your word will be my command (eventually:) ! Better still (and faster still), send me a patch! Tim. On Mon, Mar 26, 2001 at 01:06:40PM +0200, Steffen Goeldner wrote: Tim Bunce wrote: Thanks for the info. Do you have any strong objections to DBD::Oracle replicating the Oracle ODBC results? I just tested with an older driver. The Oracle 7.3 ODBC driver returns (via DBD::ODBC!): TYPE PREC SCALE NAME - - 2 38 0 CINTEGER 6 15 0 CNUMBER 2 38 0 CNUMBER_38_0 2 11 2 CNUMBER_11_2 2 38 2 CNUMBER_XX_2 6 15 0 CFLOAT 6 15 0 CFLOAT_11 6 15 0 CREAL 6 15 0 CDOUBLE_PRECISION 11 19 0 CDATE Compare it with 8.1.7 (BTW: I added a DATE column)! Type 2 is not the problem. Strictly speaking, it's better than type 3. But the prec. for FLOAT's is garbage! Now then: which Oracle ODBC results should be replicated? This one in oci7.c and the other one in oci8.c? Or always the results from the current version? If so, the best way is to number the DBI driver like this: DBD::Oracle733, DBD::Oracle817, DBD::Oracle9xx, ... Excuse me if I sound a bit sarcastic. But I hope DBI will continue to mean 'DataBase Independent'. FYI, here the results from a Visigenic driver: TYPE PREC SCALE NAME - - 3 38 0 CINTEGER 3 0 0 CNUMBER 3 38 0 CNUMBER_38_0 3 11 2 CNUMBER_11_2 3 38 2 CNUMBER_XX_2 8 15 0 CFLOAT 8 15 0 CFLOAT_11 8 15 0 CREAL 8 15 0 CDOUBLE_PRECISION Steffen
DBD: Oracle Problems
I am running Oracle 8i Enterprise (8.1.7.0.0) on a DEC Alpha Tru64 Unix platform. perl, v5.6.0 built for alpha-dec_osf DBI 1.14 All of that tested and installed fine. I have been fighting this install for a couple of weeks now. I have tried every option mentioned in the README files for the DBD install and have surfed extensively for answers. No luck so far though. Tracy perl Makefile.PL -V stderr output Warning: Oracle build rule discovery failed (256) Potential libraries are '-L/u01/oracle/OraHome1/lib/ -lclntsh -lc': '-lclntsh' found at /u01/oracle/OraHome1/lib//libclntsh.so.8.0 c not found in /u01/oracle/OraHome1/lib/ c not found in /usr/local/lib '-lc' found at /usr/shlib/libc.so makefile.log Using DBI 1.14 installed in /usr/local/lib/perl5/site_perl/5.6.0/alpha-dec_osf/auto/DBI Configuring DBD::Oracle ... Remember to actually *READ* the README file! Especially if you have any problems. Using Oracle in /u01/oracle/OraHome1 Found /u01/oracle/OraHome1/rdbms/demo/demo_rdbms.mk Found /u01/oracle/OraHome1/otrace/demo/atmoci.mk Using /u01/oracle/OraHome1/rdbms/demo/demo_rdbms.mk Reading /u01/oracle/OraHome1/rdbms/demo/demo_rdbms.mk. Reading /u01/oracle/OraHome1/rdbms/lib/env_rdbms.mk. Read a total of 2186 lines from /u01/oracle/OraHome1/rdbms/lib/env_rdbms.mk (including inclusions) Read a total of 2391 lines from /u01/oracle/OraHome1/rdbms/demo/demo_rdbms.mk (including inclusions) Deleted SHELL definition: SHELL=/bin/sh Deleted LIB_EXT definition: LIB_EXT=a Deleted OBJ_EXT definition: OBJ_EXT=o Deleted AR definition: AR=ar Deleted AS definition: AS=as Deleted CC definition: CC=cc Deleted CHMOD definition: CHMOD=chmod Deleted CPP definition: CPP=cpp Deleted ECHO definition: ECHO=echo Deleted LD definition: LD=ld Deleted PERL definition: PERL=perl Deleted CFLAGS definition: CFLAGS=$(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS) $(PFLAGS)\ $(SHARED_CFLAG) $(USRFLAGS) Deleted LDFLAGS definition: LDFLAGS=-o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME) STATIC_ORACLETTLIBS macro redefined by Oracle from $(KPUADEF) $(NTZEOBJ) $(NETLIBS) $(LIBRDBMS_CLT) \ $(LIBMM) $(CORELIBS) $(NETLIBS) $(LIBRDBMS_CLT) $(LIBPLS_CLT) \ $(LIBEPC) $(CORELIBS) $(LIBRDBMS_CLT) $(CORELIBS) to $(LLIBCLNTST) $(LDFLAGSLIST) LMAKE macro redefined by Oracle from make to /bin/make MAKE macro redefined by Oracle from $(LMAKE) to /bin/make FIND macro redefined by Oracle from find to /bin/find Deleted CCFLAGS definition: CCFLAGS=$(GEMC_FLAGS) $(ANSI_C) -DOSF1 -DA_OSF -readonly_strings -ieee -noansi_alias -D_INTRINSICS $(DTKFLAGS) $(OM_FLAGS) CPP macro redefined by Oracle from cpp to $(CC) -E $(CCFLAGS) Deleted CPP definition: CPP=$(CC) -E $(CCFLAGS) Deleted OPTIMIZE definition: OPTIMIZE=$(CDEBUG?:-O3 -fast -fp_reorder -U_FASTMATH) DOAR macro redefined by Oracle from $(ARCREATE) $@ $? $(RANLIB) to $(AR) cr$(ARLOCAL) $(LIB) $(OBJS) Deleted PERL definition: PERL = perl LINK macro redefined by Oracle from $(LDCCOM) to $(CC) $(GFLAG) $(CDEBUG) $(CCFLAGS) $(LDFLAGS) -rpath $(ORACLE_HOME)/lib Deleted ASFLAGS definition: ASFLAGS=$(CDEBUG) AS macro redefined by Oracle from as to as Deleted AS definition: AS=as Deleted LD definition: LD=ld LDFLAGS macro redefined by Oracle from -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME) to $(LDOPTIMIZE) $(SHARED_FLAG) -o $@ $(PRODUCT_LIBHOME) -L$(LIBHOME) $(NO_STRIP_EXE?:-s) Deleted LDFLAGS definition: LDFLAGS = $(LDOPTIMIZE) $(SHARED_FLAG) -o $@ $(PRODUCT_LIBHOME) -L$(LIBHOME) $(NO_STRIP_EXE?:-s) LDCCOM macro redefined by Oracle from $(PURECMDS) $(CC) $(GFLAG) $(CCFLAGS) $(EXOSFLAGS) $(LDFLAGS) to $(CC) $(GFLAG) $(CDEBUG) $(CCFLAGS) $(LDFLAGS) -rpath $(ORACLE_HOME)/lib STATICTTLIBS macro redefined by Oracle from $(ORACLETTLIBS) $(LDLIBS) to $(SLTSSTUB) $(KPUADEF) \ $(NETLIBS) $(LLIBRDBMS_CLT) $(LLIBMM) $(CORELIBS)\ $(LLIBRDBMS_CLT) $(LIBPLS_CLT) $(NETLIBS) $(NETLIBS) \ $(LLIBEPC) $(CORELIBS) $(LLIBRDBMS_CLT) $(CORELIBS) $(LDLIBS) TTLIBS macro redefined by Oracle from $(LLIBCLNTSH) $(STATICTTLIBS) to $(NAETTOBJS) $(STATICTTLIBS) LINKTTLIBS macro redefined by Oracle from $(LLIBCLNTSH) $(ORACLETTLIBS) $(LINKLDLIBS) to $(TTLIBS) CCC macro redefined by Oracle from CC to /bin/cxx -x cxx -DA_OSF Deleting ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data/ because it is not already set in the environment and it can cause ORA-01019 errors. Deleted ORA_NLS definition: ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data/ Deleting ORA_NLS33 = $(ORACLE_HOME)/ocommon/nls/admin/data/ because it is not already set in the environment and it can cause ORA-01019 errors. Deleted ORA_NLS33 definition: ORA_NLS33 = $(ORACLE_HOME)/ocommon/nls/admin/data/ Deleted SHELL definition: SHELL=/bin/sh Deleted LIB_EXT definition: LIB_EXT=a Deleted OBJ_EXT definition: OBJ_EXT=o Deleted AR definition: AR=ar AS macro redefined by Oracle from as to as Deleted AS definition: AS=as Deleted CC
RE: Oracle Problems
Looks like it can't find some lib files. Is your LD_LIBRARY_PATH set? Ilya Sterin -Original Message- From: Roper, Tracy D. To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Sent: 03/26/2001 11:31 AM Subject: DBD: Oracle Problems I am running Oracle 8i Enterprise (8.1.7.0.0) on a DEC Alpha Tru64 Unix platform. perl, v5.6.0 built for alpha-dec_osf DBI 1.14 All of that tested and installed fine. I have been fighting this install for a couple of weeks now. I have tried every option mentioned in the README files for the DBD install and have surfed extensively for answers. No luck so far though. Tracy perl Makefile.PL -V stderr output Warning: Oracle build rule discovery failed (256) Potential libraries are '-L/u01/oracle/OraHome1/lib/ -lclntsh -lc': '-lclntsh' found at /u01/oracle/OraHome1/lib//libclntsh.so.8.0 c not found in /u01/oracle/OraHome1/lib/ c not found in /usr/local/lib '-lc' found at /usr/shlib/libc.so makefile.log Using DBI 1.14 installed in /usr/local/lib/perl5/site_perl/5.6.0/alpha-dec_osf/auto/DBI Configuring DBD::Oracle ... Remember to actually *READ* the README file! Especially if you have any problems. Using Oracle in /u01/oracle/OraHome1 Found /u01/oracle/OraHome1/rdbms/demo/demo_rdbms.mk Found /u01/oracle/OraHome1/otrace/demo/atmoci.mk Using /u01/oracle/OraHome1/rdbms/demo/demo_rdbms.mk Reading /u01/oracle/OraHome1/rdbms/demo/demo_rdbms.mk. Reading /u01/oracle/OraHome1/rdbms/lib/env_rdbms.mk. Read a total of 2186 lines from /u01/oracle/OraHome1/rdbms/lib/env_rdbms.mk (including inclusions) Read a total of 2391 lines from /u01/oracle/OraHome1/rdbms/demo/demo_rdbms.mk (including inclusions) Deleted SHELL definition: SHELL=/bin/sh Deleted LIB_EXT definition: LIB_EXT=a Deleted OBJ_EXT definition: OBJ_EXT=o Deleted AR definition: AR=ar Deleted AS definition: AS=as Deleted CC definition: CC=cc Deleted CHMOD definition: CHMOD=chmod Deleted CPP definition: CPP=cpp Deleted ECHO definition: ECHO=echo Deleted LD definition: LD=ld Deleted PERL definition: PERL=perl Deleted CFLAGS definition: CFLAGS=$(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS) $(PFLAGS)\ $(SHARED_CFLAG) $(USRFLAGS) Deleted LDFLAGS definition: LDFLAGS=-o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME) STATIC_ORACLETTLIBS macro redefined by Oracle from $(KPUADEF) $(NTZEOBJ) $(NETLIBS) $(LIBRDBMS_CLT) \ $(LIBMM) $(CORELIBS) $(NETLIBS) $(LIBRDBMS_CLT) $(LIBPLS_CLT) \ $(LIBEPC) $(CORELIBS) $(LIBRDBMS_CLT) $(CORELIBS) to $(LLIBCLNTST) $(LDFLAGSLIST) LMAKE macro redefined by Oracle from make to /bin/make MAKE macro redefined by Oracle from $(LMAKE) to /bin/make FIND macro redefined by Oracle from find to /bin/find Deleted CCFLAGS definition: CCFLAGS=$(GEMC_FLAGS) $(ANSI_C) -DOSF1 -DA_OSF -readonly_strings -ieee -noansi_alias -D_INTRINSICS $(DTKFLAGS) $(OM_FLAGS) CPP macro redefined by Oracle from cpp to $(CC) -E $(CCFLAGS) Deleted CPP definition: CPP=$(CC) -E $(CCFLAGS) Deleted OPTIMIZE definition: OPTIMIZE=$(CDEBUG?:-O3 -fast -fp_reorder -U_FASTMATH) DOAR macro redefined by Oracle from $(ARCREATE) $@ $? $(RANLIB) to $(AR) cr$(ARLOCAL) $(LIB) $(OBJS) Deleted PERL definition: PERL = perl LINK macro redefined by Oracle from $(LDCCOM) to $(CC) $(GFLAG) $(CDEBUG) $(CCFLAGS) $(LDFLAGS) -rpath $(ORACLE_HOME)/lib Deleted ASFLAGS definition: ASFLAGS=$(CDEBUG) AS macro redefined by Oracle from as to as Deleted AS definition: AS=as Deleted LD definition: LD=ld LDFLAGS macro redefined by Oracle from -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME) to $(LDOPTIMIZE) $(SHARED_FLAG) -o $@ $(PRODUCT_LIBHOME) -L$(LIBHOME) $(NO_STRIP_EXE?:-s) Deleted LDFLAGS definition: LDFLAGS = $(LDOPTIMIZE) $(SHARED_FLAG) -o $@ $(PRODUCT_LIBHOME) -L$(LIBHOME) $(NO_STRIP_EXE?:-s) LDCCOM macro redefined by Oracle from $(PURECMDS) $(CC) $(GFLAG) $(CCFLAGS) $(EXOSFLAGS) $(LDFLAGS) to $(CC) $(GFLAG) $(CDEBUG) $(CCFLAGS) $(LDFLAGS) -rpath $(ORACLE_HOME)/lib STATICTTLIBS macro redefined by Oracle from $(ORACLETTLIBS) $(LDLIBS) to $(SLTSSTUB) $(KPUADEF) \ $(NETLIBS) $(LLIBRDBMS_CLT) $(LLIBMM) $(CORELIBS)\ $(LLIBRDBMS_CLT) $(LIBPLS_CLT) $(NETLIBS) $(NETLIBS) \ $(LLIBEPC) $(CORELIBS) $(LLIBRDBMS_CLT) $(CORELIBS) $(LDLIBS) TTLIBS macro redefined by Oracle from $(LLIBCLNTSH) $(STATICTTLIBS) to $(NAETTOBJS) $(STATICTTLIBS) LINKTTLIBS macro redefined by Oracle from $(LLIBCLNTSH) $(ORACLETTLIBS) $(LINKLDLIBS) to $(TTLIBS) CCC macro redefined by Oracle from CC to /bin/cxx -x cxx -DA_OSF Deleting ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data/ because it is not already set in the environment and it can cause ORA-01019 errors. Deleted ORA_NLS definition: ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data/ Deleting ORA_NLS33 = $(ORACLE_HOME)/ocommon/nls/admin/data/ because it is not already set in the environment and it can cause ORA-01019 errors. Deleted ORA_NLS33 definition: ORA_NLS33 = $(ORACLE_HOME)/ocommon/nls/admin/data/
db independant method of determining PKs
Hi all, Is there any database independant method, namely thru DBI, of determing which column of a table is the primary key? If not, has there been any discussion amongst the developers to include it in the DBI spec? Thanks, Tim Harsch
RE: Oracle Problems
Ilya, Thanks for the quick response. The truth is that it is not set. Where have I overlooked instructions on this environment setting? Tracy -Original Message- From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 12:23 PM To: Roper, Tracy D.; ''[EMAIL PROTECTED]' ' Subject: RE: Oracle Problems Looks like it can't find some lib files. Is your LD_LIBRARY_PATH set? Ilya Sterin -Original Message- From: Roper, Tracy D. To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Sent: 03/26/2001 11:31 AM Subject: DBD: Oracle Problems I am running Oracle 8i Enterprise (8.1.7.0.0) on a DEC Alpha Tru64 Unix platform. perl, v5.6.0 built for alpha-dec_osf DBI 1.14 All of that tested and installed fine. I have been fighting this install for a couple of weeks now. I have tried every option mentioned in the README files for the DBD install and have surfed extensively for answers. No luck so far though. Tracy perl Makefile.PL -V stderr output Warning: Oracle build rule discovery failed (256) Potential libraries are '-L/u01/oracle/OraHome1/lib/ -lclntsh -lc': '-lclntsh' found at /u01/oracle/OraHome1/lib//libclntsh.so.8.0 c not found in /u01/oracle/OraHome1/lib/ c not found in /usr/local/lib '-lc' found at /usr/shlib/libc.so makefile.log Using DBI 1.14 installed in /usr/local/lib/perl5/site_perl/5.6.0/alpha-dec_osf/auto/DBI Configuring DBD::Oracle ... Remember to actually *READ* the README file! Especially if you have any problems. Using Oracle in /u01/oracle/OraHome1 Found /u01/oracle/OraHome1/rdbms/demo/demo_rdbms.mk Found /u01/oracle/OraHome1/otrace/demo/atmoci.mk Using /u01/oracle/OraHome1/rdbms/demo/demo_rdbms.mk Reading /u01/oracle/OraHome1/rdbms/demo/demo_rdbms.mk. Reading /u01/oracle/OraHome1/rdbms/lib/env_rdbms.mk. Read a total of 2186 lines from /u01/oracle/OraHome1/rdbms/lib/env_rdbms.mk (including inclusions) Read a total of 2391 lines from /u01/oracle/OraHome1/rdbms/demo/demo_rdbms.mk (including inclusions) Deleted SHELL definition: SHELL=/bin/sh Deleted LIB_EXT definition: LIB_EXT=a Deleted OBJ_EXT definition: OBJ_EXT=o Deleted AR definition: AR=ar Deleted AS definition: AS=as Deleted CC definition: CC=cc Deleted CHMOD definition: CHMOD=chmod Deleted CPP definition: CPP=cpp Deleted ECHO definition: ECHO=echo Deleted LD definition: LD=ld Deleted PERL definition: PERL=perl Deleted CFLAGS definition: CFLAGS=$(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS) $(PFLAGS)\ $(SHARED_CFLAG) $(USRFLAGS) Deleted LDFLAGS definition: LDFLAGS=-o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME) STATIC_ORACLETTLIBS macro redefined by Oracle from $(KPUADEF) $(NTZEOBJ) $(NETLIBS) $(LIBRDBMS_CLT) \ $(LIBMM) $(CORELIBS) $(NETLIBS) $(LIBRDBMS_CLT) $(LIBPLS_CLT) \ $(LIBEPC) $(CORELIBS) $(LIBRDBMS_CLT) $(CORELIBS) to $(LLIBCLNTST) $(LDFLAGSLIST) LMAKE macro redefined by Oracle from make to /bin/make MAKE macro redefined by Oracle from $(LMAKE) to /bin/make FIND macro redefined by Oracle from find to /bin/find Deleted CCFLAGS definition: CCFLAGS=$(GEMC_FLAGS) $(ANSI_C) -DOSF1 -DA_OSF -readonly_strings -ieee -noansi_alias -D_INTRINSICS $(DTKFLAGS) $(OM_FLAGS) CPP macro redefined by Oracle from cpp to $(CC) -E $(CCFLAGS) Deleted CPP definition: CPP=$(CC) -E $(CCFLAGS) Deleted OPTIMIZE definition: OPTIMIZE=$(CDEBUG?:-O3 -fast -fp_reorder -U_FASTMATH) DOAR macro redefined by Oracle from $(ARCREATE) $@ $? $(RANLIB) to $(AR) cr$(ARLOCAL) $(LIB) $(OBJS) Deleted PERL definition: PERL = perl LINK macro redefined by Oracle from $(LDCCOM) to $(CC) $(GFLAG) $(CDEBUG) $(CCFLAGS) $(LDFLAGS) -rpath $(ORACLE_HOME)/lib Deleted ASFLAGS definition: ASFLAGS=$(CDEBUG) AS macro redefined by Oracle from as to as Deleted AS definition: AS=as Deleted LD definition: LD=ld LDFLAGS macro redefined by Oracle from -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME) to $(LDOPTIMIZE) $(SHARED_FLAG) -o $@ $(PRODUCT_LIBHOME) -L$(LIBHOME) $(NO_STRIP_EXE?:-s) Deleted LDFLAGS definition: LDFLAGS = $(LDOPTIMIZE) $(SHARED_FLAG) -o $@ $(PRODUCT_LIBHOME) -L$(LIBHOME) $(NO_STRIP_EXE?:-s) LDCCOM macro redefined by Oracle from $(PURECMDS) $(CC) $(GFLAG) $(CCFLAGS) $(EXOSFLAGS) $(LDFLAGS) to $(CC) $(GFLAG) $(CDEBUG) $(CCFLAGS) $(LDFLAGS) -rpath $(ORACLE_HOME)/lib STATICTTLIBS macro redefined by Oracle from $(ORACLETTLIBS) $(LDLIBS) to $(SLTSSTUB) $(KPUADEF) \ $(NETLIBS) $(LLIBRDBMS_CLT) $(LLIBMM) $(CORELIBS)\ $(LLIBRDBMS_CLT) $(LIBPLS_CLT) $(NETLIBS) $(NETLIBS) \ $(LLIBEPC) $(CORELIBS) $(LLIBRDBMS_CLT) $(CORELIBS) $(LDLIBS) TTLIBS macro redefined by Oracle from $(LLIBCLNTSH) $(STATICTTLIBS) to $(NAETTOBJS) $(STATICTTLIBS) LINKTTLIBS macro redefined by Oracle from $(LLIBCLNTSH) $(ORACLETTLIBS) $(LINKLDLIBS) to $(TTLIBS) CCC macro redefined by Oracle from CC to /bin/cxx -x cxx -DA_OSF Deleting ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data/ because it is not already set in the environment and it
DBI / DBD Oracle memory leak?
I have a daemon that connects to multiple databases with predefined time interval to retrieve information. The connections are opened and closed. I have noticed that after a while the process takes over 500MB of space eventually filling up the swap area. I was able to distill down the problem to the following example: #!/apps/perl/bin/perl use DBI; while ( 1 ) { $dbh = DBI-connect("ORCL", "scott", "tiger", "Oracle" ) || die $DBI::errstr; $dbh-disconnect(); } I was monitoring the process using the pmap and I've noticed that the heap allocated memory kept growing at a rate of 35K per connection. Is this a known issue? I could work around this by keeping persistent connections, but I'd like to know whether this is a bug (memory leak). Thanks. # /usr/proc/bin/pmap -x 3418 3418: /apps/perl/bin/perl test.pl Address Kbytes Resident Shared Private Permissions Mapped File 0001 696 680 336 344 read/exec perl 000CC000 56 56 8 48 read/write/exec perl 000DA00075686000 -6000 read/write/exec[ heap ] EEC0592030002936 64 read/exec libclntsh.so.8.0 EF1D6000 200 200 - 200 read/write/exec libclntsh.so.8.0 EF208000 72 32 - 32 read/write/exec[ anon ] EF4D 88 80 80 - read/exec libm.so.1 EF4F4000 8 8 - 8 read/write/exec libm.so.1 EF50 8 8 8 - read/exec libkstat.so.1 EF51 8 8 - 8 read/write/exec libkstat.so.1 EF52 24 24 24 - read/exec libposix4.so.1 EF534000 8 8 - 8 read/write/exec libposix4.so.1 EF54 24 16 16 - read/exec libaio.so.1 EF554000 8 8 - 8 read/write/exec libaio.so.1 EF556000 8 - - - read/write/exec[ anon ] EF56 8 8 8 - read/exec libskgxp8.so EF57 8 8 - 8 read/write/exec libskgxp8.so EF58 136 136 48 88 read/exec Oracle.so EF5B 16 16 - 16 read/write/exec Oracle.so EF5C 64 64 48 16 read/exec DBI.so EF5DE000 16 16 - 16 read/write/exec DBI.so EF5F 8 8 - 8 read/write/exec[ anon ] EF60 592 552 536 16 read/exec libc.so.1 EF6A2000 32 32 - 32 read/write/exec libc.so.1 EF6AA000 8 8 - 8 read/write/exec[ anon ] EF6C 16 16 16 - read/exec libc_psr.so.1 EF6D 16 16 16 - read/exec libmp.so.2 EF6E2000 8 8 - 8 read/write/exec libmp.so.2 EF70 448 408 408 - read/exec libnsl.so.1 EF77E000 32 32 - 32 read/write/exec libnsl.so.1 EF786000 24 16 - 16 read/write/exec[ anon ] EF79 32 32 32 - read/exec libsocket.so.1 EF7A6000 8 8 - 8 read/write/exec libsocket.so.1 EF7A8000 8 - - - read/write/exec[ anon ] EF7B 8 8 8 - read/exec/shared libdl.so.1 EF7C 112 112 112 - read/exec ld.so.1 EF7EA000 16 16 - 16 read/write/exec ld.so.1 EFFF6000 40 40 - 40 read/write/exec[ stack ] -- -- -- -- total Kb 16352 1168846407048 installation: # perl -v This is perl, version 5.005_03 built for sun4-solaris Solaris 2.6 Thu Jan 13 17:22:49 2000: Module the DBI manpage o installed into: /apps/perl/lib/site_perl/5.005 o LINKTYPE: dynamic o VERSION: 1.13 o EXE_FILES: dbish dbiproxy Thu Jan 13 17:36:26 2000: Module the DBD::Oracle manpage o installed into: /apps/perl/lib/site_perl/5.005
Connection to Oracle v8.1.5
I have successfully installed/tested connection with the following config: PERL 5.005_03 DBI 1.14 DBD 1.06 Oracle v7.3.4 (used for the build and connect tests) Has anyone successfully build/tested and can provide information for the following: ActivePERL v5.6.0 DBI ?? (source?) DBD ?? (source?) Oracle v8.1.5 Would appreciate any assistance and thanks in advance. Chuck Martin [EMAIL PROTECTED]
RE: Connection to Oracle v8.1.5
I forgot to add: both for Solaris 2.6. Thanks. /cm -Original Message- From: Martin, Chuck Sent: Monday, March 26, 2001 05:05 PM To: [EMAIL PROTECTED] Subject:Connection to Oracle v8.1.5 I have successfully installed/tested connection with the following config: PERL 5.005_03 DBI 1.14 DBD 1.06 Oracle v7.3.4 (used for the build and connect tests) Has anyone successfully build/tested and can provide information for the following: ActivePERL v5.6.0 DBI ?? (source?) DBD ?? (source?) Oracle v8.1.5 Would appreciate any assistance and thanks in advance. Chuck Martin [EMAIL PROTECTED]
RE: Connection to Oracle v8.1.5
Install ActivePerl and then see ppm docs to install DBI and DBD::Oracle8 Here is an example in command prompt... ppm install DBI and then ppm install DBD::Oracle8 Above assumes you have an internet connection present with no firewall, if you have a firewall read the ppm docs on how to configure. Ilya Sterin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 5:08 PM To: [EMAIL PROTECTED] Subject: RE: Connection to Oracle v8.1.5 I forgot to add: both for Solaris 2.6. Thanks. /cm -Original Message- From: Martin, Chuck Sent: Monday, March 26, 2001 05:05 PM To: [EMAIL PROTECTED] Subject:Connection to Oracle v8.1.5 I have successfully installed/tested connection with the following config: PERL 5.005_03 DBI 1.14 DBD 1.06 Oracle v7.3.4 (used for the build and connect tests) Has anyone successfully build/tested and can provide information for the following: ActivePERL v5.6.0 DBI ?? (source?) DBD ?? (source?) Oracle v8.1.5 Would appreciate any assistance and thanks in advance. Chuck Martin [EMAIL PROTECTED]
RE: ODBC Error - Invalid Cursor State (SQL-24000)
Phil, Because I and others use DBD::ODBC with other drivers. I have no such problem. That is why I ask the question. -Original Message- From: Phil R Lawrence [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 5:53 PM To: Neil Lunn; [EMAIL PROTECTED] Subject: Re: ODBC Error - Invalid Cursor State (SQL-24000) "Neil Lunn" [EMAIL PROTECTED] wrote: As the archive suggests, this is not a Perl-DBI problem but one with the Access product itself. Is it? I read the quoted messages a bit differently... and the blame seemed to remain unassigned between the DBD::ODBC implementation and MS-Access. If it's MS-Access, fine, but then why doesn't Jeff note this bug (inability to loop with a pre-prepared statement handle) in the perldoc? He is the one who originally reported the problem and it strikes me as a biggee. So What version of Access are you using? Sorry, this was buried down a few lines (MS-Access 2000). Perhaps Neil could comment if he remembers the circumstances of the issue from 1998. :-) Regards, Phil R Lawrence __ Please Note : Only the intended recipient is authorised to access or use this e-mail. If you are not the intended recipient, please delete this e-mail and notify the sender immediately. The contents of this e-mail are the writer's opinion and are not necessarily endorsed by the Gunz Companies unless expressly stated. We use virus scanning software but exclude all liability for viruses or similar in any attachment.