Re: DBD::Oracle: NUMBER type ambiguous in dbd_describe

2001-03-26 Thread Steffen Goeldner

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

2001-03-26 Thread EricReyes

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

2001-03-26 Thread yi susan

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

2001-03-26 Thread Bowman, Brent A

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

2001-03-26 Thread Andreas-Schmitz

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

2001-03-26 Thread Curt Russell Crandall

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

2001-03-26 Thread Tim Bunce

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

2001-03-26 Thread Roper, Tracy D.

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

2001-03-26 Thread Sterin, Ilya

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

2001-03-26 Thread Tim Harsch

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

2001-03-26 Thread Roper, Tracy D.

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?

2001-03-26 Thread Ondercin, Boris


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

2001-03-26 Thread cmartin

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

2001-03-26 Thread cmartin

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

2001-03-26 Thread Sterin, Ilya

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)

2001-03-26 Thread Neil Lunn

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.