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 groenv...@acm.org
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 > answer would be appreciated. Relinking DBD::Oracle against InstantClient 12.2 is probably not required but something I would do. John groenv...@acm.org
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. https://metacpan.org/pod/DBI> 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 serves 12.1 IPS packages for Solaris 11? http://pkg.oracle.com/solaris/release/manifest/0/database%2Foracle%2Finstantclient@12.1.0.2.0%2C5.11-3%3A20150720T213959Z> >(This may not help Michael, who is using an older version of Solaris) Nope. John groenv...@acm.org
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 listeners
and instances.
But did you confirm that you rebuilt your DBD::Oracle against
your new ORACLE_HOME?
$ find /u01/home/oracle/admin/site/lib/perl -name Oracle.so \
-exec ldd {} \;
John
groenv...@acm.org
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 tools in your new ORACLE_HOME can connect to your instances, I doubt you rebuilt DBD::Oracle when you changed ORACLE_HOME. John groenv...@acm.org
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 /root/perl5/lib/perl5/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so What does ldd(1) report about missing dependencies? # ldd /root/perl5/lib/perl5/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so Are the dependencies installed? Can you find(1) them? John groenv...@acm.org
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 script when it changes. John groenv...@acm.org
Re: I have a weird issue with a script running under cron
In message , 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 that "use MODULE" imports MODULE before you set the environment. John groenv...@acm.org
Re: I have a weird issue with a script running under cron
In message , Bruce J ohnson writes: >This is functioning, since no errors came up. If "env -i /path/to/shell/script" works from the command-line, then /path/to/shell/script will work from cron. >One quick perl-related question, though what environment do perl modules import >ed via use module; commands have? I would think it was the environment of >the >importing program. Correct, though as you learned back in October when trying to configure your environment for Apache and modperl, you must take care to set the environment before the module is imported. >One of the use statements has an exported function that checks something in th >e database, and there is a db connection made if the function is called. The e >rror line number doesnt make sense, since the error refers to the line making >my db connection in the main script, and doesnt correspond to an existing line > in the perl module, but Ive run into oddball misdirections in perl error stat >ements in the past. A short reproducable example with SCOTT's demo schema would help me understand what you mean. John groenv...@acm.org
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
>PATH=/usr/bin:/bin
>PWD=/root
>HOME=/root
>SHLVL=2
>LOGNAME=root
>ORACLE_HOME=/usr/lib/oracle/11.2/client64
>
>
> linux-vdso.so.1 => (0x7fff33dff000)
> libocci.so.11.1 => /usr/lib/oracle/11.2/client64/lib/libocci.so.11.1 (0
>x
>7ff92b1e)
> libclntsh.so.11.1 => /usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.
>1
> (0x7ff92894e000)
/tmp/test.sh
#!/bin/ksh
export ORACLE_HOME
ORACLE_HOME=/usr/lib/oracle/11.2/client64
/tmp/dbi.pl
/tmp/dbi.pl
#!/usr/local/bin/perl -w
use DBI;
my $dbh = DBI->connect( "dbi:Oracle:PHMWEB", "scott", "tiger",
{ RaiseError => 1 } );
$dbh->disconnect;
$ /bin/env -i /tmp/test.sh
John
groenv...@acm.org
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. http://news.gmane.org/find-root.php?message_id=201310221200.r9MC0w2D010081%40elvis.arl.psu.edu> John groenv...@acm.org
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 which libraries aren't resolving would be a useful test: #!/bin/ksh /bin/env - /usr/bin/ldd /usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so John groenv...@acm.org
Re: Surprising DBD::Oracle error raised
In message
, 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", "tiger",
{ RaiseError => 1 } );
my $sth = $dbh->prepare( qq{
SELECT 'FOO','BAR' FROM dual
} );
$sth->execute;
my ( $foo ) = $sth->fetchrow_array;
if ($sth->fetch) {
warn "should not enter";
}
$sth->finish;
$dbh->disconnect;
Re: Surprising DBD::Oracle error raised
In message
, 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__, __LINE__);
>}
>
>
>I expected the fetch to return undef, but it throws an Oracle error.
What does your DBI_TRACE reveal?
John
groenv...@acm.org
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 DBD::Oracle. >/usr/bin/perl -p -e "s/~DRIVER~/Oracle/g" /u/mvaughan/perl.lib/lib64/perl5/= >site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI/Driver.xst > Oracle.xsi /usr/bin/perl is 64-bit. >/usr/bin/ld: skipping incompatible /u01/app/oracle/product/11.2.0/client32/= >lib//libclntsh.so when searching for -lclntsh >/usr/bin/ld: cannot find -lclntsh Install the 64-bit Oracle InstantClient and set your ORACLE_HOME to it or install a 32-bit Perl and use it to build 32-bit DBD::Oracle. John groenv...@acm.org
Re: Script to test connecting to Oracle DBs
In message , 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 DBD::Oracle linked against a modern Oracle Instant Client. Happy hacking, John groenv...@acm.org
Re: perl problem in solaris 5.10
In message , 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! 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: http://www.oracle.com/support/collateral/oracle-technical-support-policies.pdf> http://www.oracle.com/support/collateral/lifetime-support-coverage-chart.pdf> That's not a cry for DBD::Oracle support moving forward as I'm mostly dealing with more recent Instance Client. John [EMAIL PROTECTED]
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 = DBI->connect("dbi:Oracle:host=xx.gold.com;port=1522;sid=sid",
>$eusr, $epas,{RaiseError => 1, AutoCommit => 1})
> die "Can not connect : $DBI->errstr ";
>
>Now,
>set the ORACLE_PATH to /opt/bin/oracle/9.2.0.8
>and I do try to connect but it complains that it can not connect.
Is /opt/bin/oracle/9.2.0.8 the same ORACLE_HOME you used to build
DBD::Oracle?
It must be.
Do these commands work from the shell?
$ env ORACLE_HOME=/opt/bin/oracle/9.2.0.8 /opt/bin/oracle/9.2.0.8/bin/tnsping
'(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xx.gold.com)(PORT=1522))(CONNECT_DATA=(SID=sid)))'
$ env ORACLE_HOME=/opt/bin/oracle/9.2.0.8 /opt/bin/oracle/9.2.0.8/bin/sqlplus
euser/epas@'(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xx.gold.com)(PORT=1522))(CONNECT_DATA=(SID=sid)))'
If not, contact your DBA.
John
[EMAIL PROTECTED]
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 a Sun C >compiler on the machine at all, or they only have /usr/ucb/cc (which is >found but doesn't compile anything). The fix is to get the Sun C compiler >-- or rebuild Perl with GCC (and have GCC on the machine), or obtain a Perl >build with GCC. The Sun compilers can be downloaded here: http://developers.sun.com/sunstudio/index.jsp> I recommend that the OP build his own Perl from source for his application regardless which compiler he uses. John [EMAIL PROTECTED]
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 libraries need to be the same version on both. > What about the Perl??? Is that also have to be identicial in every > respect??? I assumed the OP is planning on copying the entire Perl installation to the production machine. > Has this actually been tried Yes. John [EMAIL PROTECTED]
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 should be able to package up or tar your Perl build and extract it on your production server. Don't alter your Perl basedir and make certain your Oracle client libraries are in the same ORACLE_HOME on both systems. John [EMAIL PROTECTED]
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 are not found on Solaris 2.6 (and so we set >LD_LIBRARY_PATH) but are found on Solaris 2.8 as they should be (without >setting LD_LIBRARY_PATH). The computing team believes they have the >proper installation, but I don't understand why we have this issue only >on Solaris 2.6 if the installation is correct. Its easy enough to confirm. On your working Solaris 8 host, $ env - /usr/bin/ldd /opt/MOTapp/perl-5.8.8/lib/site_perl/5.8.8/sun4-solaris/auto/DBD/Oracle/Oracle.so | grep libclntsh.so libclntsh.so.10.1 => /opt/oracle/product/10.1.0/lib/libclntsh.so.10.1 On your broken Solaris 2.6 host, $ env - /usr/bin/ldd /opt/MOTapp/perl-5.8.8/lib/site_perl/5.8.8/sun4-solaris/auto/DBD/Oracle/Oracle.so | grep libclntsh.so libclntsh.so.10.1 => (file not found) $ ls -l /opt/oracle/product/10.1.0/lib/libclntsh.so.10.1 I think you'll find that the Oracle libraries are not where they should be on your 2.6 host. John [EMAIL PROTECTED]
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? If you don't control where the customer is going to install Oracle's client libraries, then its impossible to a priori set the runtime link path for DBD::Oracle's Oracle.so. With Oracle Instant Client and Solaris 7 and newer, you might be able to use $ORIGIN. See Dave Barr's "Why LD_LIBRARY_PATH is bad" http://xahlee.org/UnixResource_dir/_/ldpath.html> John [EMAIL PROTECTED]
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 connect with 32bit perl. There's nothing to smile about in that Bug No. Oracle has a patch for 10.2.0.1, but has refused to create the official patch for 10.2.0.2 since August. The interim patch for 10.2.0.2 that my support engineer provided does work and DBD::Oracle runs fine, but the experience definitely left me wondering why I renew our support contract with Oracle every year. John [EMAIL PROTECTED]
Re: Getting DBD::Oracle tests working
In message <[EMAIL PROTECTED]>, Karl Auer writes: > export TWO_TASK=T:my_db_host_name:some_id $ TWO_TASK="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=my_db_host_name)(PORT=1521)))(CONNECT_DATA=(SID=some_sid)))" $ export TWO_TASK $ make test John [EMAIL PROTECTED]
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: >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 suspect you've stumbled upon a bug in Oracle's 32-bit libraries. John [EMAIL PROTECTED]
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, Oracle Support will be able to as well. 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 file a TAR. By default, the demo's build 64-bit, if you're using the 32-bit client libraries with a 32-bit Perl, then you'll need to adjust the Makefile. 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: 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 > >-- >- > >PERL5LIB=d:\oracle\ora102\perl\5.8.3\lib\MSWin32-x86;d:\oracle\ora102\perl\5.8 >.3\lib;d:\oracle\ora102\perl\5.8.3\lib\MSWin32-x86;d:\oracle\ora102\perl\site\ >5.8.3;d:\oracle\ora102\perl\site\5.8.3\lib;d:\oracle\ora102\sysman\admin\scrip >ts; > >-- >- > >Now my poor DBI perl script stopped working. For example, (this is not a DBI >script, but just an example how Oracle 10G screwed things up) We encountered this problem with an application we deliver for Windows. The solution was to unset PERL5LIB in the bat file which invokes our Perl script. I'm not a DOS expert, but I think the syntax is @set PERL5LIB= Happy hacking, John [EMAIL PROTECTED]
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
$ head -1 my_script
$ myperl my_script
John
[EMAIL PROTECTED]
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 with the specific DBD::Oracle. $ /bin/env - ORACLE_HOME=/path/to/oracle/product/9.2.0 \ /path/to/bin/perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION' $ /bin/env - ORACLE_HOME=/path/to/oracle/product/9.2.0 \ /path/to/bin/perl your_simple_test_script John [EMAIL PROTECTED]
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 symbol error is resolved, but introduces a new missing symbol, ociepgoe. $ /opt/perl-5.8.5/bin/perl Makefile.PL -s ociepgoe [snipped] searching oracle lib/libextp.a ... [5] | 390| 103|FUNC |GLOB |0|1 |ociepgoe [snipped] Adding -lextp to the link command for blib/arch/auto/DBD/Oracle/Oracle.so resolves that missing symbol. Happy Perl hacking, John [EMAIL PROTECTED]
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 client libraries from ORACLE_HOME or have you changed your ORACLE_HOME? If yes, you'll need to rebuild DBD::Oracle or correct your ORACLE_HOME. If no, my guess is that your Oracle 9 SQLNet configuration doesn't include your new 10g instance. John [EMAIL PROTECTED]
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: Apache::DBI and $dbh attributes
> Have fun! If you're going to do some heavy overhauling of Apache::DBI please consider whether it will allow us to more easily plugin DBD specific reauthenticate functions. http://mathforum.org/epigone/modperl/khimfoplax/001101c004f0$937a1e90$c2cf180c@azathoth Thanks, 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 all build under Solaris with gcc which ships with Solaris 8 media kits and available online from sunfreeware.com among other places. John [EMAIL PROTECTED]
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 /opt/perl/lib/site_perl/5.005/i86pc-solaris/auto/DBI/DBI.so libc.so.1 => /usr/lib/libc.so.1 libdl.so.1 =>/usr/lib/libdl.so.1 Can your gcc build hello world? Did you build your perl from source? John [EMAIL PROTECTED]
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: bulk processing a text file
The vendor supplied bulk loaders are generally consider faster than anything you can script in Perl. However, at least in the case of Oracle, I find their error reporting wanting. If you've got crappy datafiles and you need to pinpoint exact problems, then Oracle SQL*Loader just doesn't cut it. For CSV's I use DBD::CSV to load the data into memory, validate, and then insert into Oracle via DBD::Oracle. In the future, I hope to use SQL::Parser and the new DBI methods for returning column definitions to do the validation more structured and cleanly. Thank you Tim Bunce and Jeff Zucker! 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]
bulk data validation
I have several large CSV files which I need to import into Oracle tables.
I've written code using DBD::CSV and DBD::Oracle to do the actual data
transfer, but I'd like to do some of the validation of the data (does
a particular data item conform to the Oracle data dictionary? does it
follow the basic business rules) inside Perl. Before I grow my code much
more, has this problem already been generalized?
%columns = (
last_name => {
nullable=>"NO",
size=>32,
regex=>'...',
}
);
Thanks,
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 (see -R option). If both LD_RUN_PATH and the -R option are specified, -R supersedes. My perl is built to automatically add -L/opt/gnu/lib -R/opt/gnu/lib to link options, would it be possible to change from setting the environment to setting -R options? Thanks, John [EMAIL PROTECTED]
Re: installations DBD-Oracle-1.12 on HP-UX11.0
> cc: "oci8.c", line 100: error 1588: "OCI_HTYPE_SUBSCRIPTION" undefined. > cc: "oci8.c", line 109: error 1588: "OCI_DTYPE_LOCATOR" undefined. You can safely remove these from oci8.c John [EMAIL PROTECTED]
Re: Hello? Anybody there?
> anyone know a good webdoctor? Does [EMAIL PROTECTED] bounce? John [EMAIL PROTECTED]
Re: Unable to install
This is a FAQ: http://www.xray.mpe.mpg.de/mailing-lists/dbi/2001-09/msg00056.html Install your own build or Perl and leave Sun's for Sun own uses. 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: Newbie:oracle:transaction
Wrap your statements in an eval block per the TRANSACTIONS section of DBI(3) I believe Cathy Riemer and Belinda Giardine own a copy of CJ Date's Database book if you want a good introduction to database. 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: 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-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 looking for any advice/help I can get. > > Can you tell me what the problem might be? > > /usr/bin/perl -I/usr/opt/perl5/lib/5.00503/aix > -I/usr/opt/perl5/lib/5.00 > 503 /usr/opt/perl5/lib/5.00503/ExtUtils/xsubpp -typemap > /usr/opt/perl5/lib/5.00 > 503/ExtUtils/typemap Perl.xs >xstmp.c && mv xstmp.c Perl.c > cc -c -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE = > -qmaxmem=3D16384 > -O=20 > -DVERSION=3D\"1.20\" -DXS_VERSION=3D\"1.20\" > -I/usr/opt/perl5/lib/5.00503/aix/ > CORE -DDBI_NO_THREADS Perl.c/bin/sh: cc: not found. > make: 1254-004 The error code from the last command is 127. > > Thank you very much, > > Ren=E9e Mitchell > Contact : 949-672-7879 > [EMAIL PROTECTED] I'm not an AIX expert, but I do have an account on an AIX cluster $ uname -srv AIX 3 4 My guess is that your Perl is packaged and built with an unbundled compiler that you don't have installed. Install GNU gcc, build your perl with it from source, and then install your favorite modules. If I ever wanted to become an AIX admin, I'd do the following: *Read the comp.unix.aix FAQ, archived @ http://www.faqs.org/ *Start reading the comp.unix.aix newsgroup, archived @ http://groups.google.com *Subscribe to any AIX mailing lists I can find. *Make friends with all the veteran AIX admins in my local community. Buy them beer and get them to divulge their favorite AIX specific books, magazines, conferences, and finally get their personal email addresses and cell phone numbers. 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 /usr/perl5 with /usr/bin/perl pointing to /usr/perl5/bin/perl. Do not disturb that installation unless you really know what you are doing. If you remove the perl supplied with the OS, there is a good chance you will render some bits of your system inoperable. If you wish to install a newer version of perl, install it under a different prefix from /usr/perl5. Common prefixes to use are /usr/local and /opt/perl. The preferred solution is to install your own build of perl. John [EMAIL PROTECTED]
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
! s/^LD_RUN_PATH=(.*)/LD_RUN_PATH=$ldrp/m;
my $env = $ENV{LD_RUN_PATH};
print "Ignoring LD_RUN_PATH='$env' in environment\n" if $env;
print "LD_RUN_PATH=$ldrp\n";
--- 1139,1145
# if it's empty then set it manually
$ldrp ||= "$OH/lib:$OH/rdbms/lib";
# stitch it back in
! s/^LD_RUN_PATH\s*=\s*(.*)/LD_RUN_PATH=$ldrp/m;
my $env = $ENV{LD_RUN_PATH};
print "Ignoring LD_RUN_PATH='$env' in environment\n" if $env;
print "LD_RUN_PATH=$ldrp\n";
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 PREFIX=/tmp/perl" John [EMAIL PROTECTED]
Re: problem compiling DBI in Solaris 8
My guess, you are trying to add modules to Sun perl distribution. Do not add modules to Sun's perl distribution. 1. Build your own perl from source and install it in /opt/perl or your favorite location. 2. Sun supplied scripts which depend on SUNWpl5u reference /usr/perl5/bin/perl. Break the link in /usr/bin/perl. # rm /usr/bin/perl # ln -s /opt/perl/bin/perl /usr/bin/perl John [EMAIL PROTECTED]
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]
