Error on large select statement

2004-09-24 Thread Rob Benton
Got DBI version 1.3.5 (not sure which version DBD::Oracle. Is there a way to tell?) on RedHat AS 2.1. I need some advice. I'm doing an oracle query on a table that has over 23 million records and I keep running into this error near the end. I'm not doing any updates, only a select.

Re: whats wrong? select to array and read array...

2003-03-16 Thread Rob Benton
On Sun, 2003-03-16 at 04:01, alex wrote: hi i've got problems understanding - how to put a select result to array and get the items back... someone able to explain me what is wrong with this code? sub testsub1 { my $sth8 = $dbh-prepare(SELECT Var1,Var2,Var3 FROM $dbtable1 with

RE: need some advice

2003-03-10 Thread Rob Benton
PROTECTED] Sent: Saturday, March 08, 2003 9:02 PM To: [EMAIL PROTECTED]; Rob Benton Subject: Re: need some advice Placeholders. There are examples of using them in the fine DBI and DBD::Oracle manuals and in DBD-Oracle-xxx/Oracle.ex/ . http://xmlproj.com/fom-serve/cache/49

Re: Installing DBI in your local directory

2003-03-07 Thread Rob Benton
http://www.cpan.org/modules/INSTALL.html On Fri, 2003-03-07 at 14:58, Poon, Kelvin (Infomart) wrote: Hi, I am sorry if this question was asked before. i tried searching through the archieve but couldn't find the exact answer I was looking for. I need to use the DBI module for Perl to

apache config problems

2003-03-06 Thread Rob Benton
INSTALLED: apache 1.3.27 perl 5.6.1 redhat 7.3 For some reason perl is mangling the environment variables set in the httpd.conf file: -httpd.conf- SetEnv LD_LIBRARY_PATH=/usr/local/lib:/usr/local/atf/lib:/usr/local/hydra/lib:/opt/oracle/lib SetEnv