I assume this is the sort of thing you're talking about ... -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0x105ec244)~INNER)
I'm not sure how this helps me. I can see a statement handle is being destroyed, but how do I get more info on which one it is ? Given that {CachedKids} already returns a hash to cached statement handles, how about allowing {Kids} and/or {ActiveKids} return an array if being invoked in list-context ? Let me know if you think this is worthwhile - maybe I could have a crack at coding this myself. Steve -----Original Message----- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Friday, 3 January 2003 10:27 PM To: Steve Baldwin Cc: [EMAIL PROTECTED] Subject: Re: Detecting active statement handles <snip> Use trace and see which DBI::st objects get DESTROY'd after the disconnect. Tim.