RE: Oraperl

2005-10-07 Thread Reidy, Ron
You should read the Oracle SQL*Plus docs for the meaning of "/" as a username. -Original Message- From: Gupta, Razat [mailto:[EMAIL PROTECTED] Sent: Thursday, October 06, 2005 11:35 PM To: dbi-users@perl.org Subject: Oraperl Hi EveryOne, I have a query related to Oraperl. Actually

Re: Trouble with SQL::Statement 1.14 and bind values

2005-10-07 Thread Jeff Zucker
Steffen G. wrote: Hi, I have some trouble with the new SQL::Statement 1.14 when using a DBI:CSV database and bind values. Yes, I just recently discovered some problems. Please try this fix and let me know if it solves your problem: http://svn.perl.org/modules/SQL-Statement/trunk/SQL-Stateme

Trouble with SQL::Statement 1.14 and bind values

2005-10-07 Thread Steffen G.
Hi, I have some trouble with the new SQL::Statement 1.14 when using a DBI:CSV database and bind values. Please have a look at these few lines: ~~~ #!/usr/bin/perl -w use strict; use DBI; my $dbh=DBI->connect("DBI:CSV:f_dir=./db",'','', { RaiseError => 1, AutoCommit => 1 }) or di

Re: Perl DBI and threads.pm

2005-10-07 Thread Tim Bunce
On Fri, Oct 07, 2005 at 10:24:28AM -0400, Rutherdale, Will wrote: > Thanks, Tim and Jonathan. > > The motivator for the question is that I'm looking to recommend upgrades to > management in a month or two, e.g. for library versions (DBI, DBD, etc.), > Perl versions, and extra libraries to install.

Re: Execute failed: ORA-01026: multiple buffers of size > 4000 in the bind list (DBD: oexec error)

2005-10-07 Thread Tim Bunce
On Fri, Oct 07, 2005 at 07:02:43AM -0700, Jared Still wrote: > On Wed, 2005-10-05 at 10:46, Moon, John wrote: > > The following code produces this error - ORA-01026 - after 2,000 inserts... > > Any help or suggestions will be greatly appreciated. > > You should troubleshoot this with the help of O

Re: Help with DBD-DB2 and Windows...

2005-10-07 Thread Trent Ohannessian
Hey Dan. Thanks for the reply. Unfortunately, upgrading isn't an option, yet. We're waiting for the new software stack and that will come early next year. Until then, we're using this version of Perl. On 10/7/05, Dan Scott <[EMAIL PROTECTED]> wrote: > If you're willing to upgrade to Perl 5.8.

Re: Help with DBD-DB2 and Windows...

2005-10-07 Thread Dan Scott
If you're willing to upgrade to Perl 5.8.x, then you can use the latest available version of DBD-DB2 from http://ftp.esoftmatic.com/DBI/ (it's okay to install the 5.8.4 version of DBD-DB2 on Perl 5.8.7). Dan On 10/7/05, Trent Ohannessian <[EMAIL PROTECTED]> wrote: > Hello, > > I currently have Pe

Help with DBD-DB2 and Windows...

2005-10-07 Thread Trent Ohannessian
Hello, I currently have Perl 5.6.1 and DBD-DB2 .76 installed on my Windows NT machine and everything works wonderfully. I would like to upgrade the DBD-DB2 to .78, but am having some difficulties. I can't find a PPM repository to upgrade it, and I using the make/nmake isn't an option on our mach

Re: Perl DBI and threads.pm

2005-10-07 Thread Tim Bunce
On Thu, Oct 06, 2005 at 07:42:14PM -0700, Jonathan Leffler wrote: > On 10/6/05, Rutherdale, Will <[EMAIL PROTECTED]> wrote: > > > We have some Perl DBI scripts and have been running them on a Perl > > compiled > > with threading disabled. (I.e. perl -V gives ...usethreads=undef...). I > > also hav

RE: Perl DBI and threads.pm

2005-10-07 Thread Rutherdale, Will
Thanks, Tim and Jonathan. The motivator for the question is that I'm looking to recommend upgrades to management in a month or two, e.g. for library versions (DBI, DBD, etc.), Perl versions, and extra libraries to install. These upgrades would be applied to a number of machines so they have to be

Re: Perl DBI and threads.pm

2005-10-07 Thread Jared Still
On Thu, 2005-10-06 at 19:42, Jonathan Leffler wrote: > My understanding is that a Perl with multi-threading where you do not use > the multithreading should be as stable as a Perl without the multithreading. > However, there's a chance that some modules may not be so happy. OTOH, DBI > shouldn't b

Re: Execute failed: ORA-01026: multiple buffers of size > 4000 in the bind list (DBD: oexec error)

2005-10-07 Thread Jared Still
On Wed, 2005-10-05 at 10:46, Moon, John wrote: > The following code produces this error - ORA-01026 - after 2,000 inserts... > Any help or suggestions will be greatly appreciated. > You should troubleshoot this with the help of Oracle Support if you have it. There are a number of possible cause