Re: Disabling Apache::DBI

2005-10-26 Thread Philip M. Gollucci
Ted Behling wrote: Could somebody verify that this is a sane and future-proof approach? I can't speak about the future of DBI, but your reading of the current source code is correct. -- END What doesn't kill us can only make us

Re: SQL::Statement parsing

2005-10-26 Thread Jeff Zucker
John Cougar wrote: IMHO, the API would be neater is it contained "parse_ok()" method - or something similar - to provide an explicit test for successful parsing, without having to enquire against errstr() as a (almost) side-effect. I think the best thing is for me to follow DBI and have an er

RE: SQL::Statement parsing

2005-10-26 Thread John Cougar
Hiya Jeff Thanks for the reply. Yep and whoops, that should have read SQL::Statement. -- I was Dumper-ing the returned $stmt from the SQL::Statement instantiation, so got mislead by the fact that the errstr hash element appeared to remain populated across invocations, but I did as you said, and

RE: Newline inserted?

2005-10-26 Thread Jared Still
Though I very much like Perl, sqlplus sometimes is the correct tool to use, even from cron. If you are on at least version 9 of Oracle, it becomes an even better tool, as external tables, bulk binds and the 'FORALL' statement can load data extremely quickly and efficiently. see: http://www.free

Re: DBI::Statement parsing

2005-10-26 Thread Jeff Zucker
John Cougar wrote: Heya DBI-Users Can anyone help a DBI::Statement newbie with the following problems: Not that it matters, but the module is called SQL::Statement, not DBI::Statement. 1. When parsing a SQL string, is there a preferred way for initially testing whether the statement did

Re: DBD::Oracle and $sth->{PRECISION}

2005-10-26 Thread Tim Bunce
On Wed, Oct 26, 2005 at 10:06:32AM -0400, Eric Lenio wrote: > On Mon, Oct 17, 2005 at 05:41:20PM +0100, Tim Bunce wrote: > > > > > > Sure thing... do you want tests around $sth->{PRECISION} in general, or > > > tests > > > specific to this patch? > > > > Feel free to add tests for anything and

RE: Installation DBD

2005-10-26 Thread Reidy, Ron
Pascal, If you are using a newer version of AS Perl (greater than 5.6.x), AS will not have a good working version of DBI or DBD::Oracle. You should install as follows: ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.3/DBI.ppd ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.3/DBD-Orac

Installation DBD

2005-10-26 Thread Pascal VILTARD
Hello, I have an Oracle 9iR2 , ActivePerl 5.8.7. I downloaded DBI First, and DBD::Oracle 1.16 on the site Active PPM. I have an error : There is no oracle client libraries currently available for your platform (MSWin 32-x86-multi-thread) in http://ppm.activestate.com/libs/oracle-instant-clien

Re: DBD::Oracle and $sth->{PRECISION}

2005-10-26 Thread Eric Lenio
On Mon, Oct 17, 2005 at 05:41:20PM +0100, Tim Bunce wrote: > On Mon, Oct 17, 2005 at 08:24:17AM -0400, Eric Lenio wrote: > > On Mon, Oct 17, 2005 at 11:50:22AM +0100, Tim Bunce wrote: > > > On Sat, Oct 15, 2005 at 11:02:42PM -0400, Eric Lenio wrote: > > > > On Fri, Oct 14, 2005 at 10:09:17PM +0100,

Install with ppm of DBD::Oracle

2005-10-26 Thread Pascal VILTARD
Hello I try to install DBD::Oracle with ppm. I use ActivePerl on Window$. C:\>perl -v This is perl, v5.8.7 built for MSWin32-x86-multi-thread (with 7 registered patches, see perl -V for more detail) Copyright 1987-2005, Larry Wall Binary build 813 [148120] provided by ActiveState http://www.A

DBI::Statement parsing

2005-10-26 Thread John Cougar
Heya DBI-Users Can anyone help a DBI::Statement newbie with the following problems: 1. When parsing a SQL string, is there a preferred way for initially testing whether the statement did or did not parse successfully? I am currently testing the $stmt->{original_string} element in the return hash