> "CD" == Chris Devers <[EMAIL PROTECTED]> writes:
CD> On the other hand, the qq{} format can also be formatted for readability,
CD> and it doesn't have the quirky start & end syntax:
CD> my $sth = qq{
CD> DELETE DATA_TM
CD> WHERE EXP_ID = $exp_id
CD> };
On Wed, 7 Jan 2004, Uri Guttman wrote:
> > "W" == Wk0007 <[EMAIL PROTECTED]> writes:
>
> W> my $q_delete_old_data = qq{DELETE DATA_TM
> W>WHERE EXP_ID = $exp_id};
> W> my $sth_delete_old_data = $dbh->prepare_cached($q_delete_old_data);
>
> those var names
On Wed, 2004-01-07 at 14:29, John Tobey wrote:
> On Wed, Jan 07, 2004 at 12:53:55PM -0500, Jeremy Muhlich wrote:
> > 3) Make errors non-fatal with $dbh->{RaiseError} = 0
>
> I don't know why you suggest making errors non-fatal.
What I meant was, "IF you want to make errors non-fatal, use this
On Wed, Jan 07, 2004 at 12:53:55PM -0500, Jeremy Muhlich wrote:
> 3) Make errors non-fatal with $dbh->{RaiseError} = 0
I don't know why you suggest making errors non-fatal. (Well, okay, in
this example it didn't exactly matter, because there is no status
checking and the eval defeats
On Wed, 2004-01-07 at 12:37, [EMAIL PROTECTED] wrote:
> The following block was identified by the error message:
>
> foreach my $exp_id (values %experiments) {
>eval {
> my $q_delete_old_data = qq{DELETE DATA_TM
> WHERE EXP_ID = $exp_id};
> my
One thing I'd do is not prepare a new statement handle and then
finish it during your loop. To do this, you'll need to use
placeholders like:
my $q_delete_old_data = qq{DELETE DATA_TM
WHERE EXP_ID = ?};
my $sth_delete_old_data =
On Wed, 2004-01-07 at 11:49, [EMAIL PROTECTED] wrote:
> I've beem frustrated by the following error message when I run a script
> on an Oracle database:
>
> 'DBD::Oracle::st execute failed: ORA-01000: maximum open cursors exceeded
> (DBD ERROR: OCIStmtExecute) [for statement "DELETE DATA_TM
Hello,
I've beem frustrated by the following error message when I run a script on an Oracle
database:
'DBD::Oracle::st execute failed: ORA-01000: maximum open cursors exceeded (DBD ERROR:
OCIStmtExecute) [for statement "DELETE DATA_TM WHERE EXP_ID = 1396" with params: ]) at
./analyse_data.pl
8 matches
Mail list logo