Re: Oracle cursors and purge

[prev] [thread] [next] [Date index for 2004/11/12]

On Tue, Nov 09, 2004 at 05:42:03PM -0500, Perrin Harkins wrote:
> 
> > I'm leaning toward 'finish' not being called somewhere or some sort of 
> > scoping issue where CDBI objects are staying in scope too long. Is this 
> > possible, or just crazy talk?
> 
> Very possible, although you shouldn't need to call finish().

And even if you do that doesn't destroy the cursor, just makes it
inactive/idle/whatever. It still exists in Oracle ready to be executed again.

To find out how many statement handles exist for a $dbh use:

  print "There are $dbh->{Kids} statement handles, of which $dbh->{ActiveKids} are active.\n";

Tim.