On Wed, Nov 17, 2004 at 12:40:06PM -0500, [EMAIL PROTECTED] wrote:
> On Wed, 17 Nov 2004, Joseph Bruni wrote:
>
> > @values = ($f1,$f2,$f3);
> > $sth->execute(@values);
>
> I've had a problem with this approach which is why I abandoned it.
> execute barfs w/ no error logged when I have more than
Make sure your statement handles are being destroyed
as soon as they're not needed.
Using prepare_cached() is one possible cause of long-lived
statement handles.
print $dbh->{Kids} will tell you how many statement handles
exist for a given database handle.
Tim.
On Wed, Nov 17, 2004 at 06:16:16P
Are you closing your cursor once they are no longer needed? What do you
have set in terms of cursor sharing?
Michael
> Date: Wed, 17 Nov 2004 15:38:59 -0700
> From: "Reidy, Ron" <[EMAIL PROTECTED]>
> To: Giovanni Borri <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> Subject: RE: :Oracle question
>
> W
What is your error?
Have you (or your DBA) looked into increasing max_open_cursors?
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Giovanni Borri [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 17, 2004 10:16 AM
To: [EMAIL PROTECTED]
Subject: DBD
hi Tim,
I have a question for you about the use of DBD::Oracle library.
It's almost 3/4 years that we are using your library to connect to Oracle
database. I this days we are facing a problem and i don't know if it is a
problem of the library or what.
What seems to happen is that when we open a
Michael A Chase wrote:
Quoting Daniel Kasak <[EMAIL PROTECTED]>:
Hi all.
I'm writing some code that needs to be able to figure out what DBD
driver is working with a current database *handle* ( so I can take
advantage of more advanced features of some drivers ).
How do I do that?
From DBI.pm
Quoting Daniel Kasak <[EMAIL PROTECTED]>:
> Hi all.
>
> I'm writing some code that needs to be able to figure out what DBD
> driver is working with a current database *handle* ( so I can take
> advantage of more advanced features of some drivers ).
>
> How do I do that?
>From DBI.pm:
Driver
Hi all.
I'm writing some code that needs to be able to figure out what DBD
driver is working with a current database *handle* ( so I can take
advantage of more advanced features of some drivers ).
How do I do that?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
Nor
Quoting "Moosmann, James" <[EMAIL PROTECTED]>:
> Then use place holders and or bind
Both your examples are using placeholders. Using $sth->bind() that way is an
alternate method of providing the values to the placeholders. It could also
feed bind variables, but the syntax is slightly different.
On Wed, 17 Nov 2004, Moosmann, James wrote:
> Then use place holders and or bind
I am using place holders.
That is _why_ I'm passing args to an execute() call.
> @values = ( $f1, $f2, $f3 );
>
> $sth->prepare( " INSERT TABLE VALUES ( ?, ?, ? ) ");
>
> $sth->execute( @values );
As stated, this i
Then use place holders and or bind
@values = ( $f1, $f2, $f3 );
$sth->prepare( " INSERT TABLE VALUES ( ?, ?, ? ) ");
$sth->execute( @values );
-or using bind -
use DBI qw/ :sql_types /;
...
@values = ( $f1, $f2, $f3 );
$sth->prepare( " INSERT TABLE VALUES ( ?, ?, ? ) ");
$sth->bind( 1, $val
On Wed, 17 Nov 2004, Joseph Bruni wrote:
> @values = ($f1,$f2,$f3);
> $sth->execute(@values);
I've had a problem with this approach which is why I abandoned it.
execute barfs w/ no error logged when I have more than a few elements
in the array. For 3-5 elements, works fine...the query that is dy
Quoting [EMAIL PROTECTED]:
> can someone tell me a workaround for this:
>
> $values = qq |$f1, $f2, $f3|;
> $sth->execute($values);
>
> 'execute called with 1 bind variables, 19 needed...'
>
> I've tried single quoting too, same result.
It is working as it should. You want to send nineteen separ
If you can post a small self-contained example that demonstrates
the problem then I'll take a look.
Tim.
On Wed, Nov 17, 2004 at 09:15:52AM -0800, Susan Cassidy wrote:
>I never got any response to my question about this problem. I thought I'd
> try again.
>
>
>
>This is DBD::Orac
I think this may be a unicode/mutli-byte data issue.
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Susan Cassidy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 17, 2004 10:16 AM
To: [EMAIL PROTECTED]
Subject: FW: DBD::Oracle and strange pro
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]:
>
> Hi,
>
> can someone tell me a workaround for this:
>
> $values = qq |$f1, $f2, $f3|;
> $sth->execute($values);
>
> 'execute called with 1 bind variables, 19 needed...'
>
> I've tried single quoting too, same result.
As the error message says, y
I never got any response to my question about this
problem. I thought I’d try again.
This is DBD::Oracle 1.16, DBI 1.45, Oracle 9i (9.2), Linux, Perl
5.8.5.
Thanks,
Susan
From: Susan Cassidy [mailto:[EMAIL PROTECTED]
Sent: Friday, November 05, 2004
10:23 AM
To: '[EMAI
@values = ($f1,$f2,$f3);
$sth->execute(@values);
...or...
$sth->execute($f1,$f2,$f3);
On Nov 17, 2004, at 10:02 AM, [EMAIL PROTECTED] wrote:
Hi,
can someone tell me a workaround for this:
$values = qq |$f1, $f2, $f3|;
$sth->execute($values);
'execute called with 1 bind variables, 19 needed...'
I've
Hi,
can someone tell me a workaround for this:
$values = qq |$f1, $f2, $f3|;
$sth->execute($values);
'execute called with 1 bind variables, 19 needed...'
I've tried single quoting too, same result.
TIA
---
Thomas Good
Don't go drawing conclusions that may be premature. Dig deeper first.
(Perl can get confused about line numbers in some cases.)
Use $SIG{__WARN__} = sub { ... } and Carp::confess and Data::Dumper
to dump the stack and all the relevant data at the exact point it happens.
Reproduce the problem with
Hi Folks
I've just run a test on a Pentium III @ 800 MHz.
Transactions were not used, in order to stress SQLite.
Importing the data from various text and spreadsheet files took 3 h 24 m.
This is Perl 5.8.4.
During this, I got 4 identical messages which said:
Use of an uninitialized value in s
All,
So far I have perl executable 5.8.0. Do i have to upgrade perl.exe to 5.8.5
version to test DBD::ODBC 1.13 again?
Thanks,
Mike Chen
-Original Message-
From: Jeff Urlwin [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 13, 2004 9:47 AM
To: 'Chen, Mike'; [EMAIL PROTECTED]
Cc: [EMAI
22 matches
Mail list logo