I have gotten the same error due to an Oracle bug in 8.0.5,
and after reproducing the error with OCI and C, was told by
Oracle to upgrade (to 8.0.6 I think).
The error occurred after fetching the first few rows (of a
large result set), then finish'ing the cursor, then the program
would die executing the NEXT sql statement.
BTW, if you think 'use strict' is a bother, you're missing the
point. You don't need package names, just the 'my' function, which
convieniently localizes variables to just the blocks you need them
in, and sometimes catching hard-to-find typos in variable names.
A must for anything over 10 or 20 lines or so.
-----Original Message-----
From: Laurie Gennari [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 2:12 PM
To: Dbi-Users (E-mail)
Subject: RE: using statement handle in a loop
Hmmm... I tried moving the prepare out of the loop AND using
getDFhandle->finish, and I still get an error. This time, the execute fails
(rather than the prepare). Very odd....
Tried use strict, but all it told me was to put package names in front of
every single solitary thing, so I turned it off.
Any other thoughts?
ltg
