Re: DBD::Oracle Installation problem

2005-04-26 Thread Christian Merz
Hello Sangeeth, the problem is a 32/64 bit mismatch of your perl (32bit) and your oracle (64bit) libs: 'wrong ELF class'. our system group fixed this problem by: * before running perl Makefile.PL * edit your file $ORACLE_HOME/rdbms/lib/env_rdbms.mk * by changing LIBDIR=lib to LIBDIR=lib32 * after

RE: Can't locate DBI.pm

2005-04-26 Thread Reidy, Ron
Google is your friend ... http://www.google.com/search?q=install+perl+modules&sourceid=mozilla-search&start=0&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls=org.mozilla:en-US:official - Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Chekuri, Lalitha [m

Re: Efficient select/insert

2005-04-26 Thread Jonathan Mangin
Do these selects first and push the results into an array of arrays. Then prepare your insert and loop through your array on the execute portion only. Short of multiline inserts that should be your fastest way to do things. Doesn't this (below) affect my ability to do that? I don't really know.

RE: Can't locate DBI.pm

2005-04-26 Thread Chekuri, Lalitha
How do I compile? -Original Message- From: Michael Nhan [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 26, 2005 5:28 PM To: Chekuri, Lalitha Cc: dbi-users@perl.org Subject: Re: Can't locate DBI.pm Are you sure this is the perl where DBI is installed. If you reinstall solaris 9, the pre

Re: Efficient select/insert

2005-04-26 Thread Eric
At 02:13 PM 4/26/2005, Jonathan Mangin wrote: - Original Message - From: "Eric" <[EMAIL PROTECTED]> To: "Jonathan Mangin" <[EMAIL PROTECTED]>; Sent: Tuesday, April 26, 2005 3:43 PM Subject: Re: Efficient select/insert At 01:13 PM 4/26/2005, Jonathan Mangin wrote: I would like to select se

Re: Can't locate DBI.pm

2005-04-26 Thread Michael Nhan
Are you sure this is the perl where DBI is installed. If you reinstall solaris 9, the prebuilt perl on the box from the install will not have the DBI and DBD-Oracle installed. You will need to compile these yourself. Date: Tue, 26 Apr 2005 12:10:21 -0400 From: "Chekuri, Lalitha" <[EMAIL PROT

RE: Can't locate DBI.pm

2005-04-26 Thread Reidy, Ron
Is DBI installed? Is it your "@INC" path? - Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Chekuri, Lalitha [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 26, 2005 10:10 AM To: dbi-users@perl.org Subject: Can't locate DBI.pm Hi, I have fresh install

Can't locate DBI.pm

2005-04-26 Thread Chekuri, Lalitha
Hi, I have fresh install Solaris 9. We have some perl scripts to run. I am getting "Can't locate DBI.pm" error to execute the file. We access oracle 9 from this perl script. Can some one help me to fix this problem? My Perl version is: This is perl, v5.6.1 built for sun4-solaris-64int (with 48 re

load_dbnames() function - DBD::Oracle

2005-04-26 Thread Mark S. Davis
The load_dbnames() function does not handle tnsnames.ora files properly. It scans _the_ file looking for leading edge database connection names, but it doesn't honor the ifile directive. The ifile directive basically does an include of the specified file(s) which may contain other ifile directi

Re: Efficient select/insert

2005-04-26 Thread Jonathan Mangin
- Original Message - From: "Eric" <[EMAIL PROTECTED]> To: "Jonathan Mangin" <[EMAIL PROTECTED]>; Sent: Tuesday, April 26, 2005 3:43 PM Subject: Re: Efficient select/insert At 01:13 PM 4/26/2005, Jonathan Mangin wrote: I would like to select several rows from one table and insert them in

Re: Efficient select/insert

2005-04-26 Thread Eric
At 01:13 PM 4/26/2005, Jonathan Mangin wrote: I would like to select several rows from one table and insert them into another nearly identical table using Perl/DBI: my @array = $q->param(); # HTML checkboxes foreach my $element (@array) { my $sql = "select col2, col3, col4 from table1

Re: Efficient select/insert

2005-04-26 Thread Jonathan Mangin
- Original Message - From: "Philip M. Gollucci" <[EMAIL PROTECTED]> To: "Jonathan Mangin" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, April 26, 2005 3:19 PM Subject: Re: Efficient select/insert Jonathan Mangin wrote: I would like to select several rows from one table and insert them into ano

Re: Efficient select/insert

2005-04-26 Thread JupiterHost.Net
$dbh->do("INSERT INTO t (col1, ...) SELECT col1, ... FROM t2 WHERE x = '$element'"); Oi SQL injection warning! Red lights and sirens - don't do that!! '$element' is supper dangerouse, evil evil evil either $dbh->quote it or use ? in your prepare/execute dance: $dbh->do( 'INSERT INTO t (col

RE: Efficient select/insert

2005-04-26 Thread Reidy, Ron
This is very inefficient ... 1. You are prepare()ing your SQL statements in a loop. 2. You are performing row-at-a-time processing Move your SQL statements out the loop. This will be a big performance gain (in a high transaction app). However (in Oracle), this would best be accomplished by .

Re: Efficient select/insert

2005-04-26 Thread Philip M. Gollucci
Jonathan Mangin wrote: I would like to select several rows from one table and insert them into another nearly identical table using Perl/DBI: my @array = $q->param(); # HTML checkboxes foreach my $element (@array) { $dbh->do("INSERT INTO t (col1, ...) SELECT col1, ... FROM t2 WHERE x = '$eleme

Efficient select/insert

2005-04-26 Thread Jonathan Mangin
I would like to select several rows from one table and insert them into another nearly identical table using Perl/DBI: my @array = $q->param(); # HTML checkboxes foreach my $element (@array) { my $sql = "select col2, col3, col4 from table1 where col1 = ?"; my $sth = $dbh->prepare(

Re: Suggested Patch for DBD::mysql

2005-04-26 Thread Paul DuBois
On 4/26/05 9:03, "Rudy Lippan" <[EMAIL PROTECTED]> wrote: > On Mon, 25 Apr 2005, James D. White wrote: > >> I have a couple of suggested patches for DBD::mysql. These patches were >> based upon >> DBD-mysql-2.9006. >> >> The first patch is to correct a typo in "t/lib.pl". >> 47c47 >> < $::t

Re: Suggested Patch for DBD::mysql

2005-04-26 Thread Rudy Lippan
On Mon, 25 Apr 2005, James D. White wrote: > I have a couple of suggested patches for DBD::mysql. These patches were > based upon > DBD-mysql-2.9006. > > The first patch is to correct a typo in "t/lib.pl". > 47c47 > < $::test_password = $::test_passowrd || $ENV{'DBI_PASS'} || ''; > --- >

Re: DBD::Oracle Installation problem

2005-04-26 Thread Michael A Chase
On 04/26/2005 03:54 AM, PerlDiscuss - Perl Newsgroups and mailing lists said: When I install DBD::Oracle module, I get the following error. = ld: fatal: file /oracle/product/10/lib//libclntsh.so: wrong ELF class: ELFCLASS64 ... Summary of m

DBD::Oracle Installation problem

2005-04-26 Thread PerlDiscuss - Perl Newsgroups and mailing lists
Hi, When I install DBD::Oracle module, I get the following error. = ld: fatal: file /oracle/product/10/lib//libclntsh.so: wrong ELF class: ELFCLASS64 ld: fatal: File processing errors. No output written to blib/arch/auto/DBD/Oracle/Oracle.so collect2: ld returned 1 exi

ANNOUNCE: SQL-Routine 0.60

2005-04-26 Thread Darren Duncan
2005-04-25 Darren Duncan <[EMAIL PROTECTED]> -- Version 0.60 of SQL::Routine (SRT), a fully atomic and portable abstract syntax tree to define any database tasks, has been uploaded to CPAN; it should appear on your favorite mirror within the next

Re: Help: error not clearing from one call to the next?

2005-04-26 Thread Tim
On Mon, Apr 25, 2005 at 04:38:28PM -0700, Joel Stevenson wrote: > > > >Can you post the next few lines from the trace, upto just after > >fetchrow_hashref returns? > > Sure, > > > !! ERROR: 1146 CLEARED by call to fetchrow_hashref method > -> fetchrow_hashref for DBD::mysql::st > (DBI::

ANN: PDF::ReportWriter

2005-04-26 Thread Dan
Hi all. I'm pleased to announce the 1st release of my 2nd open-source project: PDF::ReportWriter. It's designed to assist in making high-quality business reports for archiving or printing, and uses PDF::API2 to render directly to PDF. Supported features: - html-table-like layout engine - text al