Re: question for DBD-Oracle driver
On 2008-04-10 10:26:50 -0500, James H. McCullars wrote: > At 09:08 AM 4/10/2008, Peter J. Holzer wrote: > >Why shouldn't it work with a CGI script? I can think of reasons why it > >wouldn't work with mod_perl, but none for a CGI script. > > Setting the environment variable worked for me from the command line but > never from a CGI script. By "worked for me from the command line" do mean: 1) Set the environment variable within the script as in the example I gave and invoked the script from the command line, or 2) set the environment variable in the shell and then invoke the script? These are completely different. > The best explanation I could find for this was here: > > http://www.perlmonks.org/?node_id=126575 This talks about the second case. Yes, that's entirely possible (doesn't seem to be the case on linux, though), but it doesn't have anything to do with CGI scripts. I don't believe that that the first case is possible on any unixoid OS. hp -- _ | Peter J. Holzer| If I wanted to be "academically correct", |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm not. __/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users pgpkNp51MjdpU.pgp Description: PGP signature
Re: question for DBD-Oracle driver
At 09:08 AM 4/10/2008, Peter J. Holzer wrote: Why shouldn't it work with a CGI script? I can think of reasons why it wouldn't work with mod_perl, but none for a CGI script. Setting the environment variable worked for me from the command line but never from a CGI script. The best explanation I could find for this was here: http://www.perlmonks.org/?node_id=126575 Since I didn't really want to fork a child process with every script execution, I just symlinked the library into /usr/lib. Problem solved. Jim McCullars University of Alabama in Huntsville
Re: question for DBD-Oracle driver
On Thu, 2008-04-10 at 16:08 +0200, Peter J. Holzer wrote: > On 2008-04-10 08:27:06 -0500, James H. McCullars wrote: > > At 02:17 AM 4/10/2008, Peter J. Holzer wrote: > > >>I've just been through an install of DBD::Oracle on a Solaris 10 > > >>machine and this was my experience as well. My needs were > > >>complicated by the fact that I was running it as a CGI script and > > >>thus did not have a way to easily set an environment variable. > > > > > >$ENV{LD_LIBRARY_PATH} = ...; > > > >That doesn't work from a CGI script. > > Yes, it does. I have quite a few CGI scripts which use this technique. > > Why shouldn't it work with a CGI script? I can think of reasons why it > wouldn't work with mod_perl, but none for a CGI script. > > hp I believe that LD_LIBRARY_PATH must already be set when the driver gets loaded, so if it is not working, try setting it before using DBI->connect(). Ulisses
Re: question for DBD-Oracle driver
On 2008-04-10 08:27:06 -0500, James H. McCullars wrote: > At 02:17 AM 4/10/2008, Peter J. Holzer wrote: > >>I've just been through an install of DBD::Oracle on a Solaris 10 > >>machine and this was my experience as well. My needs were > >>complicated by the fact that I was running it as a CGI script and > >>thus did not have a way to easily set an environment variable. > > > >$ENV{LD_LIBRARY_PATH} = ...; > >That doesn't work from a CGI script. Yes, it does. I have quite a few CGI scripts which use this technique. Why shouldn't it work with a CGI script? I can think of reasons why it wouldn't work with mod_perl, but none for a CGI script. hp -- _ | Peter J. Holzer| If I wanted to be "academically correct", |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm not. __/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users pgp0etRPl9f3Z.pgp Description: PGP signature
Re: question for DBD-Oracle driver
At 02:17 AM 4/10/2008, Peter J. Holzer wrote: >I've just been through an install of DBD::Oracle on a Solaris 10 machine and > this was my experience as well. My needs were complicated by the fact that I > was running it as a CGI script and thus did not have a way to easily set an > environment variable. $ENV{LD_LIBRARY_PATH} = ...; That doesn't work from a CGI script. Jim McCullars University of Alabama in Huntsville
Re: question for DBD-Oracle driver
On Apr 9, 1:07 pm, [EMAIL PROTECTED] (James H. McCullars) wrote: > At 10:47 AM 4/9/2008, pgodfrin wrote: > > >This will obviate the need to use LD_LIBRARY_PATH, which has some > >controversy surrounding it's use. I also found a strangeness for the > >install of DBD. If I remember correctly, the install document states > >that LD_LIBRARY_PATH should be set during the module install, which > >will link the value of the LD_LIBRARY_PATH . Indeed the value ends up > >in the make file (in the EXTRA_LIBS, LD_RUN_PATH and OTHERLDFLAGS > >entries), and the library seems to be available as per the ldd > >command, yet, without either an LD_LIBRARY_PATH environment variable > >or the ld.so.conf.d method, DBD does not run. > > >Any thoughts? > >pg > > I've just been through an install of DBD::Oracle on a Solaris 10 > machine and this was my experience as well. My needs were > complicated by the fact that I was running it as a CGI script and > thus did not have a way to easily set an environment variable. > > If you set LD_LIBRARY_PATH (or maybe LD_RUN_PATH) while doing the > module build, then Oracle.so will be compiled with the paths to the > modules it needs. But at runtime, it will load (on my system) > libclntsh.so.10.1 which it finds in the oracle instant client > directory. But then libclntsh.so.10.1 will want to load libnnz10.so > and will not be able to because libclntsh.so.10.1 was compiled with a > run path of whatever machine the Oracle client was compiled on. So > what I wound up doing was just symlinking libnnz10.so to /usr/lib and > I could then get my script to run without any runtime load paths. > > Hope this helps... > > Jim McCullars > University of Alabama in Huntsville hmmm - running ldd on libclntsh.so gives me this: linux-gate.so.1 => (0x0011) libnnz10.so => /oracle/product/10.2.0.3/lib/libnnz10.so (0x00111000) libdl.so.2 => /lib/libdl.so.2 (0x00317000) libm.so.6 => /lib/libm.so.6 (0x0031c000) libpthread.so.0 => /lib/libpthread.so.0 (0x00345000) libnsl.so.1 => /lib/libnsl.so.1 (0x0035e000) libc.so.6 => /lib/libc.so.6 (0x00377000) /lib/ld-linux.so.2 (0x00687000) I'm running a Fedora 8 box - 10.2.0.3 Oracle install... pg
Re: question for DBD-Oracle driver
On 2008-04-09 13:07:55 -0500, James H. McCullars wrote: > At 10:47 AM 4/9/2008, pgodfrin wrote: > > >This will obviate the need to use LD_LIBRARY_PATH, which has some > >controversy surrounding it's use. I also found a strangeness for the > >install of DBD. If I remember correctly, the install document states > >that LD_LIBRARY_PATH should be set during the module install, which > >will link the value of the LD_LIBRARY_PATH . Indeed the value ends up > >in the make file (in the EXTRA_LIBS, LD_RUN_PATH and OTHERLDFLAGS > >entries), and the library seems to be available as per the ldd > >command, yet, without either an LD_LIBRARY_PATH environment variable > >or the ld.so.conf.d method, DBD does not run. > >I've just been through an install of DBD::Oracle on a Solaris 10 machine > and > this was my experience as well. My needs were complicated by the fact that I > was running it as a CGI script and thus did not have a way to easily set an > environment variable. $ENV{LD_LIBRARY_PATH} = ...; or somewhat more generic: if (open(E, "$offl_root/dbi/env")) { while () { chomp; my ($k, $v) = split(/=/); $ENV{$k} = $v; } close(E); } hp -- _ | Peter J. Holzer| If I wanted to be "academically correct", |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm not. __/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users pgpMmnG10yfux.pgp Description: PGP signature
Re: question for DBD-Oracle driver
At 10:47 AM 4/9/2008, pgodfrin wrote: This will obviate the need to use LD_LIBRARY_PATH, which has some controversy surrounding it's use. I also found a strangeness for the install of DBD. If I remember correctly, the install document states that LD_LIBRARY_PATH should be set during the module install, which will link the value of the LD_LIBRARY_PATH . Indeed the value ends up in the make file (in the EXTRA_LIBS, LD_RUN_PATH and OTHERLDFLAGS entries), and the library seems to be available as per the ldd command, yet, without either an LD_LIBRARY_PATH environment variable or the ld.so.conf.d method, DBD does not run. Any thoughts? pg I've just been through an install of DBD::Oracle on a Solaris 10 machine and this was my experience as well. My needs were complicated by the fact that I was running it as a CGI script and thus did not have a way to easily set an environment variable. If you set LD_LIBRARY_PATH (or maybe LD_RUN_PATH) while doing the module build, then Oracle.so will be compiled with the paths to the modules it needs. But at runtime, it will load (on my system) libclntsh.so.10.1 which it finds in the oracle instant client directory. But then libclntsh.so.10.1 will want to load libnnz10.so and will not be able to because libclntsh.so.10.1 was compiled with a run path of whatever machine the Oracle client was compiled on. So what I wound up doing was just symlinking libnnz10.so to /usr/lib and I could then get my script to run without any runtime load paths. Hope this helps... Jim McCullars University of Alabama in Huntsville
Re: question for DBD-Oracle driver
On Apr 9, 10:04 am, [EMAIL PROTECTED] (Paula J Capacio) wrote: > >>On March 28, Fred Vachon said: > >>I have DBI and DBD::Oracle installed on a Solaris 10 machine. > >>When I run either of the 2 commands that were posted I error out with: > >>perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' > >>Can't load > > '/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBD/Oracle/Oracle.so > ' > > >>for module DBD::Oracle: ld.so.1: perl: fatal: . > >> at -e line 0 > >>I'm thinking it might be an issue with PATH or LD_LIBRARY_PATH but I > >>haven't been able to find it. > > I believe you are correct, and that this is another dynamic install. > Solaris doesn't have the chatr command but you can use ldd to get > similar information. > Specifically, issue: > ldd > /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBD/Oracle/Oracle.so > > Although this doesn't show the libraries it shows what parts are > missing. > Do a 'find' for these parts and once you locate them, add the location > to > your LD_LIBRARY_PATH. > Example for the following output: > $ ldd > /opt/Perl5/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBD/Oracle/Oracle > .so > libclntsh.so.8.0 => (file not found) > libwtc8.so => (file not found) > libnsl.so.1 => /usr/lib/libnsl.so.1 > libsocket.so.1 => /usr/lib/libsocket.so.1 > libdl.so.1 => /usr/lib/libdl.so.1 > libsched.so.1 => /usr/lib/libsched.so.1 > libaio.so.1 => /usr/lib/libaio.so.1 > libposix4.so.1 => /usr/lib/libposix4.so.1 > libkstat.so.1 => /usr/lib/libkstat.so.1 > libm.so.1 => /usr/lib/libm.so.1 > libthread.so.1 => /usr/lib/libthread.so.1 > libc.so.1 => /usr/lib/libc.so.1 > libmp.so.2 => /usr/lib/libmp.so.2 > /usr/platform/SUNW,Ultra-80/lib/libc_psr.so.1 > > I did a find for the files not found then added the locations to my > environ vars: > > export ORACLE_HOME=/usr/oracle/product/8.1.7 > export TNS_ADMIN=??? (location of your tnsnames.ora) > export PATH=/usr/oracle/product/8.1.7/bin:$PATH > export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib > > I hope this helps. > Paula Another approach is to use the ld configuration 'structure' (I'm a DBA not an SA so I'm not sure of the terminology). In /etc/ld.so.conf: include ld.so.conf.d/*.conf This will search the ld.so.conf.d direcotry for files like *.conf, and load their contents at startup, or when the ldconfig command is issued. In ld.si.conf.d/ (for my Fedora 8 system): -rw-r--r-- 1 root root 15 2007-12-14 02:03 mysql-i386.conf -rw-r--r-- 1 root root 73 2007-08-22 04:12 opensync-32.conf -rw-r--r-- 1 root root 29 2008-03-03 13:34 oracle-10203.conf -rw-r--r-- 1 root root 20 2008-01-24 09:38 qt-i386.conf -rw-r--r-- 1 root root 15 2006-01-02 03:04 wine-32.conf (btw - some errors occur complaining about '...empty, not checked' - don't know what that means...) In oracle-10203.conf: /oracle/product/10.2.0.3/lib This will obviate the need to use LD_LIBRARY_PATH, which has some controversy surrounding it's use. I also found a strangeness for the install of DBD. If I remember correctly, the install document states that LD_LIBRARY_PATH should be set during the module install, which will link the value of the LD_LIBRARY_PATH . Indeed the value ends up in the make file (in the EXTRA_LIBS, LD_RUN_PATH and OTHERLDFLAGS entries), and the library seems to be available as per the ldd command, yet, without either an LD_LIBRARY_PATH environment variable or the ld.so.conf.d method, DBD does not run. Any thoughts? pg
RE: question for DBD-Oracle driver
>>On March 28, Fred Vachon said: >>I have DBI and DBD::Oracle installed on a Solaris 10 machine. >>When I run either of the 2 commands that were posted I error out with: >>perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' >>Can't load '/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBD/Oracle/Oracle.so ' >>for module DBD::Oracle: ld.so.1: perl: fatal: . >> at -e line 0 >>I'm thinking it might be an issue with PATH or LD_LIBRARY_PATH but I >>haven't been able to find it. I believe you are correct, and that this is another dynamic install. Solaris doesn't have the chatr command but you can use ldd to get similar information. Specifically, issue: ldd /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBD/Oracle/Oracle.so Although this doesn't show the libraries it shows what parts are missing. Do a 'find' for these parts and once you locate them, add the location to your LD_LIBRARY_PATH. Example for the following output: $ ldd /opt/Perl5/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBD/Oracle/Oracle .so libclntsh.so.8.0 => (file not found) libwtc8.so => (file not found) libnsl.so.1 => /usr/lib/libnsl.so.1 libsocket.so.1 => /usr/lib/libsocket.so.1 libdl.so.1 => /usr/lib/libdl.so.1 libsched.so.1 => /usr/lib/libsched.so.1 libaio.so.1 => /usr/lib/libaio.so.1 libposix4.so.1 => /usr/lib/libposix4.so.1 libkstat.so.1 => /usr/lib/libkstat.so.1 libm.so.1 => /usr/lib/libm.so.1 libthread.so.1 => /usr/lib/libthread.so.1 libc.so.1 => /usr/lib/libc.so.1 libmp.so.2 => /usr/lib/libmp.so.2 /usr/platform/SUNW,Ultra-80/lib/libc_psr.so.1 I did a find for the files not found then added the locations to my environ vars: export ORACLE_HOME=/usr/oracle/product/8.1.7 export TNS_ADMIN=??? (location of your tnsnames.ora) export PATH=/usr/oracle/product/8.1.7/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib I hope this helps. Paula
RE: question for DBD-Oracle driver
>On March 28, Icheng said: >After I try the command you provide, I got the following error >Can't load '/opt/perl5/lib/site_perl/5.8.0/PARISC2.0/auto/DBD/Oracle/Oracle.sl' >for module DBD::Oracle: No such file or directory at >/opt/perl5/lib/5.8.0/PA-RISC2.0/DynaLoader.pm line 229. > at test_dbd_ver.pl line 5 This looks like the DBD-Oracle module is installed dynamically. Use the HP chatr command to find out what libs it needs and make them available via your environment variables. Specifically, issue chatr /opt/perl5/lib/site_perl/5.8.0/PARISC2.0/auto/DBD/Oracle/Oracle.sl This will show you what libraries need to be available to satisfy the dynamic requirements of this module. Example for the following output: sl: shared library shared library dynamic path search: SHLIB_PATH disabled second embedded path enabled first /usr/oracle/client/10.2/lib32: /usr/oracle/client/10.2/rdbms/lib32 shared library list: dynamic /usr/oracle/client/10.2/lib32//libclntsh.sl.10.1 dynamic /usr/lib/libm.2 shared vtable support disabled explicit unloading enabled static branch prediction disabled executable from stack: D (default) kernel assisted branch prediction enabled lazy swap allocation disabled text segment locking disabled data segment locking disabled third quadrant private data space disabled fourth quadrant private data space disabled third quadrant global data space disabled data page size: D (default) instruction page size: D (default) nulptr references disabled shared library private mapping disabled You would need to export the following environment variables: export ORACLE_HOME=/usr/oracle/client/10.2 export TNS_ADMIN=??? (where your tnsnames.ora file is) export PATH=/usr/oracle/client/10.2/bin:$PATH I hope this helps. Paula
Re: question for DBD-Oracle driver
On Mar 28, 2:05 pm, [EMAIL PROTECTED] (Frederick P A5IT Vachon) wrote: > Hi - I have an issue related to this. I have DBI and DBD::Oracle > installed on a Solaris 10 machine. When I run either of the 2 commands > that were posted I error out with the messages listed below. > > perl -e 'use DBD::Oracle 42' > perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' > > I'm thinking it might be an issue with PATH or LD_LIBRARY_PATH but I > haven't been able to find it. I've tried using the sparcv9 libraries > thinking it might be a 32 vs 64 bit issue but nothing works. Does > anyone have any suggestions? Thanks for any help. > > perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' > Can't load > '/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBD/Oracle/Oracle.so > ' for module DBD::Oracle: ld.so.1: perl: fatal: . > at -e line 0 > Compilation failed in require. > BEGIN failed--compilation aborted. > > perl -e 'use DBD::Oracle 42' > Can't load > '/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBD/Oracle/Oracle.so > ' for module DBD::Oracle: ld.so.1: perl: fatal: . > at -e line 1 > Compilation failed in require at -e line 1. > BEGIN failed--compilation aborted at -e line 1. > > [EMAIL PROTECTED] wrote: > > -> Dear sir/madam, > > > > > How can we tell that we have already install DBD-Oracle drive for > > DBI ? > > perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' > > which will error with "Can't locate DBD::Oracle"... if you haven't got > it. > > > If we have already install DBD-Oracle, how can we check what version > > it is ? > > perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' > > will show DBD::Oracle version. > > -Original Message- > From: Ian Harisay [mailto:[EMAIL PROTECTED] > Sent: Friday, March 28, 2008 12:36 PM > To: [EMAIL PROTECTED] > Subject: RE: question for DBD-Oracle driver > > perl -e 'use DBD::Oracle 42' > > This will tell you what version is currently installed. Generally, I > always refer to the man page first. But, I didn't see versioning info > available in the DBD::Oracle man page. Probably an oversite on my part. > > -- > CONFIDENTIALITY NOTICE: If you have received this email in error, please > immediately notify the sender by e-mail at the address shown. This email > transmission may contain confidential information. This information is > intended only for the use of the individual(s) or entity to whom it is > intended even if addressed incorrectly. Please delete it from your files if > you are not the intended recipient. Thank you for your compliance. > Copyright 2008 CIGNA > == what about perl -MDBI -e 'DBI->installed_versions' ? phil
Re: question for DBD-Oracle driver
On Mar 28, 2:05 pm, [EMAIL PROTECTED] (Frederick P A5IT Vachon) wrote: > Hi - I have an issue related to this. I have DBI and DBD::Oracle > installed on a Solaris 10 machine. When I run either of the 2 commands > that were posted I error out with the messages listed below. > > perl -e 'use DBD::Oracle 42' > perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' > > I'm thinking it might be an issue with PATH or LD_LIBRARY_PATH but I > haven't been able to find it. I've tried using the sparcv9 libraries > thinking it might be a 32 vs 64 bit issue but nothing works. Does > anyone have any suggestions? Thanks for any help. > > perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' > Can't load > '/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBD/Oracle/Oracle.so > ' for module DBD::Oracle: ld.so.1: perl: fatal: . > at -e line 0 > Compilation failed in require. > BEGIN failed--compilation aborted. > > perl -e 'use DBD::Oracle 42' > Can't load > '/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBD/Oracle/Oracle.so > ' for module DBD::Oracle: ld.so.1: perl: fatal: . > at -e line 1 > Compilation failed in require at -e line 1. > BEGIN failed--compilation aborted at -e line 1. > > [EMAIL PROTECTED] wrote: > > -> Dear sir/madam, > > > > > How can we tell that we have already install DBD-Oracle drive for > > DBI ? > > perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' > > which will error with "Can't locate DBD::Oracle"... if you haven't got > it. > > > If we have already install DBD-Oracle, how can we check what version > > it is ? > > perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' > > will show DBD::Oracle version. > > -Original Message- > From: Ian Harisay [mailto:[EMAIL PROTECTED] > Sent: Friday, March 28, 2008 12:36 PM > To: [EMAIL PROTECTED] > Subject: RE: question for DBD-Oracle driver > > perl -e 'use DBD::Oracle 42' > > This will tell you what version is currently installed. Generally, I > always refer to the man page first. But, I didn't see versioning info > available in the DBD::Oracle man page. Probably an oversite on my part. > > -- > CONFIDENTIALITY NOTICE: If you have received this email in error, please > immediately notify the sender by e-mail at the address shown. This email > transmission may contain confidential information. This information is > intended only for the use of the individual(s) or entity to whom it is > intended even if addressed incorrectly. Please delete it from your files if > you are not the intended recipient. Thank you for your compliance. > Copyright 2008 CIGNA > == what about perl MDBI -e 'DBI->installed_versions' phil
RE: question for DBD-Oracle driver
Hi - I have an issue related to this. I have DBI and DBD::Oracle installed on a Solaris 10 machine. When I run either of the 2 commands that were posted I error out with the messages listed below. perl -e 'use DBD::Oracle 42' perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' I'm thinking it might be an issue with PATH or LD_LIBRARY_PATH but I haven't been able to find it. I've tried using the sparcv9 libraries thinking it might be a 32 vs 64 bit issue but nothing works. Does anyone have any suggestions? Thanks for any help. perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' Can't load '/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBD/Oracle/Oracle.so ' for module DBD::Oracle: ld.so.1: perl: fatal: . at -e line 0 Compilation failed in require. BEGIN failed--compilation aborted. perl -e 'use DBD::Oracle 42' Can't load '/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBD/Oracle/Oracle.so ' for module DBD::Oracle: ld.so.1: perl: fatal: . at -e line 1 Compilation failed in require at -e line 1. BEGIN failed--compilation aborted at -e line 1. [EMAIL PROTECTED] wrote: -> Dear sir/madam, > > > How can we tell that we have already install DBD-Oracle drive for > DBI ? perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' which will error with "Can't locate DBD::Oracle"... if you haven't got it. > If we have already install DBD-Oracle, how can we check what version > it is ? perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' will show DBD::Oracle version. -Original Message----- From: Ian Harisay [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2008 12:36 PM To: dbi-users@perl.org Subject: RE: question for DBD-Oracle driver perl -e 'use DBD::Oracle 42' This will tell you what version is currently installed. Generally, I always refer to the man page first. But, I didn't see versioning info available in the DBD::Oracle man page. Probably an oversite on my part. -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright 2008 CIGNA ==
RE: question for DBD-Oracle driver
perl -e 'use DBD::Oracle 42' This will tell you what version is currently installed. Generally, I always refer to the man page first. But, I didn't see versioning info available in the DBD::Oracle man page. Probably an oversite on my part. -Original Message- From: John Scoles [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2008 9:52 AM To: [EMAIL PROTECTED] Cc: dbi-users@perl.org Subject: Re: question for DBD-Oracle driver give this a try #!perl -w use DBI; use DBD::Oracle qw(:ora_types); print DBD::Oracle::ORA_OCI()."\n"; if you dbi is 1.47 you can use up to DBD::Oracle 1.19 cheers John Scoles [EMAIL PROTECTED] wrote: > Dear sir/madam, > > > How can we tell that we have already install DBD-Oracle drive for DBI ? > > If we have already install DBD-Oracle, how can we check what version it is ? > > We have the unix (HP-UX houux14 B.11.11 U 9000/800 196921507 > unlimited-user license) installed, and > perl version ( v5.8.0 built for PA-RISC2.0) install and DBI (DBI version > is => 1.47), what version > DBD-Oracle driver we need to install ? > > > Thank you very much for answering my questions. > > Icheng > > > > >
Re: question for DBD-Oracle driver
[EMAIL PROTECTED] wrote: Dear sir/madam, How can we tell that we have already install DBD-Oracle drive for DBI ? perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' which will error with "Can't locate DBD::Oracle"... if you haven't got it. If we have already install DBD-Oracle, how can we check what version it is ? perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' will show DBD::Oracle version. We have the unix (HP-UX houux14 B.11.11 U 9000/800 196921507 unlimited-user license) installed, and perl version ( v5.8.0 built for PA-RISC2.0) install and DBI (DBI version is => 1.47), what version DBD-Oracle driver we need to install ? I would get the most recent stable version which I believe is 1.20. Thank you very much for answering my questions. Icheng Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com
Re: question for DBD-Oracle driver
[EMAIL PROTECTED] wrote: Thank you so much for providing me this information. After I try the command you provide, I got the following error message. Can't load '/opt/perl5/lib/site_perl/5.8.0/PARISC2.0/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle: No such file or directory at /opt/perl5/lib/5.8.0/PA-RISC2.0/DynaLoader.pm line 229. at test_dbd_ver.pl line 5 Compilation failed in require at test_dbd_ver.pl line 5. BEGIN failed--compilation aborted at test_dbd_ver.pl line 5. Any suggestions for this error. Thanks Icheng The means you do not have DBD::Oracle installed you will have to install it with CPAN or alike Cheers John Scoles give this a try #!perl -w use DBI; use DBD::Oracle qw(:ora_types); print DBD::Oracle::ORA_OCI()."\n"; if you dbi is 1.47 you can use up to DBD::Oracle 1.19 cheers John Scoles [EMAIL PROTECTED] wrote: Dear sir/madam, How can we tell that we have already install DBD-Oracle drive for DBI ? If we have already install DBD-Oracle, how can we check what version it is ? We have the unix (HP-UX houux14 B.11.11 U 9000/800 196921507 unlimited-user license) installed, and perl version ( v5.8.0 built for PA-RISC2.0) install and DBI (DBI version is => 1.47), what version DBD-Oracle driver we need to install ? Thank you very much for answering my questions. Icheng
Re: question for DBD-Oracle driver
give this a try #!perl -w use DBI; use DBD::Oracle qw(:ora_types); print DBD::Oracle::ORA_OCI()."\n"; if you dbi is 1.47 you can use up to DBD::Oracle 1.19 cheers John Scoles [EMAIL PROTECTED] wrote: Dear sir/madam, How can we tell that we have already install DBD-Oracle drive for DBI ? If we have already install DBD-Oracle, how can we check what version it is ? We have the unix (HP-UX houux14 B.11.11 U 9000/800 196921507 unlimited-user license) installed, and perl version ( v5.8.0 built for PA-RISC2.0) install and DBI (DBI version is => 1.47), what version DBD-Oracle driver we need to install ? Thank you very much for answering my questions. Icheng
question for DBD-Oracle driver
Dear sir/madam, How can we tell that we have already install DBD-Oracle drive for DBI ? If we have already install DBD-Oracle, how can we check what version it is ? We have the unix (HP-UX houux14 B.11.11 U 9000/800 196921507 unlimited-user license) installed, and perl version ( v5.8.0 built for PA-RISC2.0) install and DBI (DBI version is => 1.47), what version DBD-Oracle driver we need to install ? Thank you very much for answering my questions. Icheng