Re: DBD error

In message , Bala GANESH writes: >ld: 0711-736 ERROR: Input file /oracle/product/19.7/lib/libclntsh.so: >XCOFF64 object files are not allowed in 32-bit mode. $ file `which perl` $ file /oracle/product/19.7/lib/libclntsh.so John groenv...@acm.org

Re: (Fwd) Perl with Oracle 12c

In message <2ceb8fe815e746e480d13c6cc8be3...@uscpmb01.photomask.com>, "Seidler, Reinhard" writes: >Thanks to all. Who could know the compiled Oracle client version? $ perl -MDBD::Oracle -le 'print DBD::Oracle::ORA_OCI' 12.2.0.1 >11.2 would be fine and certified by Oracle... Yes. John

Re: (Fwd) Perl with Oracle 12c

In message <20180410150233.7hxxrlqqhwoysp7m@timac>, "tim.bu...@pobox.com" write s: > We develop Perl applications connecting and working with Oracle database (D >BD:Oracle). So far it was > Oracle version 11. Now the database will be migrated to 12.2.0.1. How shoul >d we deal with that? Any >

Re: Hello Perl Comminity from ATL

In message <02db01d3c043$75a0ca50$60e25ef0$@gmail.com>, "Philip" writes: >Any clues on how to troubleshoot ? Crawl before you run. Create a small test script on your RT webserver and confirm you can connect to your database. John groenv...@acm.org

Re: Perl DBI libraries for connecting 12c

In message , Christopher Jones writes: >For the record, Instant Client is available in Solaris packages: https://blogs >.oracle.com/jmcp/oracle-instant-client:-now-available-in-ips Have you noticed that Oracle ships 12.2 Instant Client but only

Re: ORA-12154 - (DBD: login failed)

In message , "Mani, Arunkumar (BMS - India GDC)" writes: >Just following up to see if I can get any help on this. I saw where you confirmed that tnsping and sqlplus from your new 10g ORACLE_HOME work against your

Re: ORA-12154 - (DBD: login failed)

In message , "Mani, Arunkumar (BMS - India GDC)" writes: >I'll probably explain it with a piece of code and output, so everybody can = >explain the problem I face clearly. Assuming that you've confirmed Oracle's

Re: Bundle::DBI and DBD::Oracle failing

In message , "Tony D'Alfonso" writes: >Does it still make a difference running it as 32-bit on a 64-bit machine. I`v >e strictly been trying it on 64 bit. What does file(1) report about the architecture of your Oracle.so? # file

Re: I have a weird issue with a script running under cron

In message 20140220115644.gj10...@wsr.ac.at, Peter J. Holzer writes: You have to set LD_LIBRARY_PATH in a wrapper script. The OP should link his Oracle.so with the correct rpath so LD_LIBRARY_PATH is not required. I prefer to put ORACLE_HOME in a wrapper so I don't have to adjust every DBI

Re: I have a weird issue with a script running under cron

In message f661b815-79d0-4e56-af60-1cbe006c0...@pharmacy.arizona.edu, Bruce J ohnson writes: It appears to be that called modules via ‘use MODULE;’ do NOT share the environm ent of the calling perl script? No, it appears from this experiment as well as your experiment with modperl last fall that

Re: I have a weird issue with a script running under cron

In message 20140218110257.ga10...@wsr.ac.at, Peter J. Holzer writes: Yes, so obviously you should run John's little script via cron, too. What is the result? My guess is the OP still hasn't realized that his interactive shell environment is different then his cron and Apache's.

Re: I have a weird issue with a script running under cron

In message 2076ef99-9f11-4eda-846a-f0a946e85...@pharmacy.arizona.edu, Bruce J ohnson writes: Via cron (with the Oracle environment variables set as in the script in questi on, please read the OP!): SHELL=/bin/sh USER=root LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_SID=PHMWEB

Re: I have a weird issue with a script running under cron

In message 5302803c.4080...@triad.rr.com, Richie writes: Is LD_LIBRARY_PATH exported? It's hard to see whats going on without a full test case. The OP shouldn't need to set a LD_LIBRARY_PATH so long as he built DBD::Oracle with the correct runtime link path, but a simple shell script to see

Re: Surprising DBD::Oracle error raised

In message cafwsco-tqp5yycpptawzqkkyhz6qjs3d_g+yv5r9x9apdbm...@mail.gmail.com , David Nicol writes: the error message claimed I hadn't executed the statement. Where is your DBI_TRACE? I can't reproduce. John groenv...@acm.org use strict; use DBI; my $dbh = DBI-connect( dbi:Oracle:, scott,

Re: Surprising DBD::Oracle error raised

In message CAFwScO-0DchsbSLPSmR9JY+KmBUF3BfUREH9XdDSVgEAo=p...@mail.gmail.com , David Nicol writes: $price_sth-execute; my ($o_file_price) = $price_sth-fetchrow_array(); if ($price_sth-fetch) { $this-log_error('ERROR: scalar select returned second row at %s line %d', __FILE__,

Re: Build error - DBD::Oracle, Oracle 11.2.0.1, 32-bit client, remote DB

In message 55bc400cff41a94aae7062ab10940b3f022...@stntexmb12.cis.neustar.com, Vaughan, Mark writes: I'm trying to build DBI and DBD::Oracle to run on a Linux server (2.6.18-27= 4.7.1.el5) using the 11g (11.2.0.1) 32-bit client. The database resides on = Your perl must be 32-bit to build 32-bit

Re: Script to test connecting to Oracle DBs

In message camnmhccsuwb1cy3rumce5zrx635hms6xnjxuvv6wvjz9hep...@mail.gmail.com , newbie01 perl writes: test connection to the Oracle DB and run a simple SQL like SELECT COUNT(1) from USER_TABLES, if I get an error, that means there is an issue I would try the DBI connect and ping methods with

Re: perl problem in solaris 5.10

In message aanlkti=txedon_3xr6456qh9ryq5hf9g-uhojcjs+...@mail.gmail.com, SOMN ATH GANGULY writes: ora...@prdcmw perl TablespaceFree.pl Can't locate DBI.pm in @INC (@INC contains: Where did you install DBI and DBD::Oracle? John groenv...@acm.org

Re: DBI module most important module in Perl 2010 survey

In message 4c20b25e.3030...@pythian.com, John Scoles writes: Looks like the link to his slides is broken or at least when I try and get it I get a corrupt file error! URL:http://github.com/singingfish/Data-PerlSurvey-2010/raw/master/report/perl_survey.pdf John groenv...@acm.org

Re: DBD::Oracle and Support for Oracle 8 and 9 clients

In message [EMAIL PROTECTED], scoles @pythian.com writes: With the upcoming demise of Oracle support of 9i we will see a good number 9i (9.2.0.8) still has some support life left: URL:http://www.oracle.com/support/collateral/oracle-technical-support-policies.pdf

Re: Oracle connection issue with perl DBI

In message [EMAIL PROTECTED], Kumar Ranjan writes: I am facing a funny but troubling issue with Perl DBI Oracle. When my shell environment does not have ORACLE_HOME path set, my script works fine. I am connecting to Oracle DB like this: #!/usr/bin/perl -w use strict; use DBI; my $dbh =

Re: Issue with perl, DBD::Oracle, Solaris 10

In message [EMAIL PROTECTED], Jona than Leffler writes: Did you build this Perl? Do you have a Sun C compiler on the machine? Building shared objects with the C compiler is common practice many places and standard practice on Solaris. The most usual problems people have is that they do not have

Re: Ref:-- How to transfer DBI/DBD binary.

In message [EMAIL PROTECTED], Richard T Malafa writes: Is this assuming the hardware is identical on both machines and the Oracle Database (not the clients alone) are identical? Yes. The development and production systems must be the same architecture and OS version. The Oracle client

Re: Ref:-- How to transfer DBI/DBD binary.

In message [EMAIL PROTECTED] , MEHTA, HARESH, ATTSI writes: I have installed DBI/DBD using gcc in our development solaris server. I want to install on production server but without using gcc or cc(compiler), Is there any way to transfer binary of DBI/DBD to production server?? You

Re: DBD Oracle module

In message [EMAIL PROTECTED], Ke rr Shannon-SKERR1 writes: Is this related and if so do you have some advice or guidance I can share with our computing team that can get this resolved so our customers don't have to set LD_LIBRARY_PATH to use our tool and we don't have to develop a wrapper for it?

Re: DBD Oracle module

In message [EMAIL PROTECTED], Ke rr Shannon-SKERR1 writes: Thanks for the reply. The Oracle client libraries are installed at the same location on all of our servers (Solaris 2.6 and 2.8). I believe the problem is with the configuration and/or installation procedure and that's why the libraries

Re: Bug with Oracle 10.2.0.2 for Solaris 64bit

In message [EMAIL PROTECTED], John Scoles writ es: Seems there is a bug in Oracle (What??? never happens?? yeah right!) the bug number is 5389730. Seem that our friends at Oracle forgot to add a flie to a makefile into the 10.2.0.2 Solaris x86 patchset :-). so parts are missing when you try to

Re: Getting DBD::Oracle tests working

In message [EMAIL PROTECTED], Karl Auer writes: 9/9 skipped: Unable to connect to Oracle (ORA-12162: TNS:net service n ame is incorrectly specified (DBD ERROR: OCIServerAttach)) You did not set TWO_TASK properly. John [EMAIL PROTECTED]

Re: Using Oracle Internet Directory (OID) instead of TNS Names

In message [EMAIL PROTECTED] m, Loo, Peter # PHX writes: $ ./testCon.pl Segmentation Fault(coredump) Lets see the output of pstack(1) for that core. You may have stumbled upon an Oracle bug in the client libraries. John [EMAIL PROTECTED]

Re: Using Oracle Internet Directory (OID) instead of TNS Names

In message [EMAIL PROTECTED] m, Loo, Peter # PHX writes: $ pstack core core 'core' of 13643: /usr/bin/perl ./testCon.pl fe6fbd6c gslufpFLog (1, feda0ba0, 0, 0, 0, 0) + 48 I'd wager that if you build the OCI demo, cdemo1, you'll core in the same place, which will be what your DBA will need to

Re: Using Oracle Internet Directory (OID) instead of TNS Names

In message [EMAIL PROTECTED] m, Loo, Peter # PHX writes: If appears that Perl was built with 32-bit. I don't understand what you mean by OCI demo. Oracle ships a bunch of OCI demos for training. $ORACLE_HOME/rdbms/demo/ cdemo1 is very simple and if you can replicate the core dump with it,

Re: Using Oracle Internet Directory (OID) instead of TNS Names

In message [EMAIL PROTECTED] m, Loo, Peter # PHX writes: It appears that OID configuration is working properly. I had used tnsping command to see what method it was using to resolve the INSTANCE. $ tnsping INSTANCE_NOT_IN_TNSNAMES_FILE tnsping and sqlplus are 64-bit in 10.2 for Solaris. I

Re: Help: Oracle 10G installtion screwed up my perl

In message [EMAIL PROTECTED], joe bayer writes: On my WinXP sp2, I have perl 5.6.1 installed and a lot of scripts depend on th at. Recently I installed Oracle 10g Version 2, it added a new system variable --

Re: DBI/DBD on 9i with Solaris 9

In message [EMAIL PROTECTED], Morrison Davis writes: confusing' part I'm definetly confused. Not sure what the WAG acronym means? Wild ass guess. in my perl script I do $ENV{ORACLE_HOME}=/oracle/9.2.0.5; my_script $ env - ORACLE_HOME=/oracle/9.2.0.5 ORACLE_SID=SRM61 $ORACLE_HOME/bin/sqlplus $

Re: DBD-Oracle 1.15 make test error - symbol OCILobWriteAppend not found

In message [EMAIL PROTECTED], Beth Winsl ow writes: I'm trying to install DBD-Oracle-1.15 on Solaris 9 using perl 5.8.5 compiled with gcc. My oracle home contains version 8.0.6 (old, yes, but required for an With DBD-Oracle-1.16 and 8.0.6.3 under Solaris, the OCILobWriteAppend symbol not found

Re: DBI/DBD on 9i with Solaris 9

In message [EMAIL PROTECTED], Morrison Davis writes: available to us. The next issue I have is if I set ORACLE_HOME to 8.1.7 dbi connects fine but if I change it to 9.2.0.5 I get the following: DBI-connect failed: ERROR OCIEnvInit at My WAG is you're confusing the ORACLE_HOME's and the Perl's

Re: Oracle 10g

In message [EMAIL PROTECTED], Brose, Cory writes: I have several Perl scripts that use the DBD-Oracle(1.12) and DBI(1.37) modules to access information in Oracle9i. We've recently upgraded to Oracle10g and these scripts are failing on = the DBI Connect string. Did your DBA remove the Oracle 9

Re: ACT! (version 4) for Windows -- is there support?

You've got two options for interacting with ACT! via Perl. You can use the Win32::OLE modules to interface with ACT! methods and you can access the database files via DBD::ODBC or DBD::XBase. Have fun reading the SDK and the rest of ACT!'s technical support docs. John [EMAIL PROTECTED]

Re: MS Access

DBD::ODBC. John [EMAIL PROTECTED]

Re: dbi make failed on solaris 8

Extending Sun's shipped perl is rife with problems so just don't do it. rm /usr/bin/perl # Sun's scripts reference /usr/perl5/bin/perl, thanks Sun! install your own perl from source with your preferred compiler. extend as desired. Have fun! John [EMAIL PROTECTED]

Re: Could you tell me where Solaris-ready DBI and DBD::Oracle modules available?

If you want completely hands off Solaris Perl packages, then I think you have just one option, http://www.activestate.com/, which is probably where you got your Perl for Win32 distribution. I would definitely confirm that that AS ships DBD::Oracle with its Solaris port. Perl, DBI, DBD::Oracle

Re: DBI error on Solaris x86

Using a non-GNU ld does not seem to fix the problem. Still getting the same errors. Any ideas? (/usr/ucb/ld). That should be /usr/ccs/bin/ld. Reading specs from /opt/gnu/lib/gcc-lib/i386-pc-solaris2.7/2.95.3/specs $ gcc -v gcc version 2.95.3 20010315 (release) $ ldd

Re: SQL Implementation Specifics

Many moons ago you could approach Len Gallagher @ NIST.GOV who is/was on the ANSI SQL committee. I'm sure someone from NIST still is active and he could point you to the right people. John [EMAIL PROTECTED]

Re: Got a queston about OTHERLDFLAGS

Seems like you should be able to do... env LDFLAGS=-L/path/to/lib -R/path/to/lib -lfoo perl Makefile.PL and have it set OTHERLDFLAGS in Makefile to yours. But of course I always get sea sick when I look at Makefile.PL. John [EMAIL PROTECTED]

runtime link path

Tim, I really appreciate all the work you put into automating the setting of runtime link path. You're very close, at least on my platform, Solaris/Oracle8.0.6/gcc Per ld(1) LD_RUN_PATH An alternative mechanism for specifying a runpath to the link-editor

Re: Hello? Anybody there?

anyone know a good webdoctor? Does [EMAIL PROTECTED] bounce? John [EMAIL PROTECTED]

Re: Unix GUI tool for Oracle (and others like mysql in future)

Though perhaps I am straying off-topic too, so I'll stop there. I'll bring it full circle: Where in the world did Orac run off too? Kevin Kitt's website is down. John [EMAIL PROTECTED]

Re: DBI-1.20 installation problem

To whom it may concern or John Groenveld: I am installing DBI-1.20 and received the error from running make. Apparently, the file it is looking for is not in the CORE directory. = Perl 5 was installed first, then DBI on a AIX platform running 4.3.3. I am a newbie unix system admin and

Re: Drivers to connect Oracle database(on Solaris) from Perl script on Unix(Solaris)

Under Win32, ActiveState bundles a script called PPM to automate the installation of Perl modules. My guess is they have a corresponding tool for Solaris. John [EMAIL PROTECTED]

Re: DBI/Solaris User

Yes, DBI and likely all of the database specific DBD's work fine under Solaris. You'll need your own build of Perl or at least one built with a compiler that you have installed (gcc). John [EMAIL PROTECTED]

Re: Installing DBI-1.20 on Solaris 8

I don't want to install Perl itself, I just want to install DBI. Sun's build is for its pwn uses ( to support applications that they ship) if you want modules not shipped with Sun's Perl build, then install your own Perl per the FAQ and README. John [EMAIL PROTECTED]

Re: Installing DBI-1.20 on Solaris 8

http://www.science.uva.nl/pub/solaris/solaris2/Q3.74.html and the README.solaris in perl5.6.1 Starting with Solaris 8, perl5.00503 (or higher) is supplied with the operating system, so you might not even need to build a newer version of perl at all. The Sun-supplied version is installed in

Re: ANNOUNCE: DBD::Oracle 1.10

LD_RUN_PATH still doesn't seem to get set... John [EMAIL PROTECTED] *** Makefile.PL 2001/08/30 20:58:16 1.1 --- Makefile.PL 2001/08/30 21:15:57 *** *** 1139,1145 # if it's empty then set it manually $ldrp ||= $OH/lib:$OH/rdbms/lib; # stitch it back in

Re: installing personal copies of DBI and DBD::Oracle

The perlfaq's don't apply? How do I keep my own module/library directory? How do I add a directory to my include path at runtime? Building DBI with $ perl Makefile.PL PREFIX=/tmp/perl and then DBD::Oracle with $ env PERL5LIB=/tmp/perl/lib/site_perl/5.005/sun4-solaris \ perl Makefile.PL

Re: PERL DBI with Oracle 8.1.7?

LD_LIBRARY_PATH is an evil hack, don't set it. http://www.xray.mpe.mpg.de/mailing-lists/dbi/2000-10/msg00010.html John [EMAIL PROTECTED]

Re: DESCRIBE $TableName

Oracle SQLPlus describe? Read the fine archive. http://www.xray.mpe.mpg.de/mailing-lists/dbi/2000-01/msg00797.html John [EMAIL PROTECTED]