I'm a little late picking up on this thread, but I do have a question. Why are you closing the cursor?
When you disconnect, all your cursors will be closed. If you aren't disconnecting, the only good reason for closing a cursor is that you will no longer be using it during the session, which may be true in your case. Kind of hard to tell from a code fragment. Prepare your cursor with place holders, leave it open, execute as needed with bind variables. This makes for *much* less work for the database. Jared On Tue, 2003-12-09 at 12:08, Tim Bunce wrote: > ----- Forwarded message from Patrick Kuijvenhoven <[EMAIL PROTECTED]> ----- > > Delivered-To: [EMAIL PROTECTED] > Subject: RE: DBD::Oracle: closing bound cursors > Date: Tue, 9 Dec 2003 14:18:21 +0100 > From: "Patrick Kuijvenhoven" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > > Hi Tim, > > sorry for bothering you by e-mail. I have a problem similar to > http://www.bitmechanic.com/mail-archives/dbi-users/Jul1999/0802.html. This thread > ended with your reply: no solution. :( > > Unfortunatly hours of searching Google didn't help me. The documentations says > something about closing cursors, but that doesn't work for me. > > I am using > > my $func = $dbh->prepare(q{ > BEGIN > :rv := caizen$change.pf_ref_abonnement(pi_abokab_abonnee_nr => > :pi_abokab_abonnee_nr); > END; > }); > > $func->bind_param(":pi_abokab_abonnee_nr", $nr); > $func->bind_param_inout(":rv", \$rv, 0, { ora_type => ORA_RSET }); > $func->execute; > > to bind my cursor. Now i want to close it. Can you help me? > > Kind regards, > > Patrick Kuijvenhoven, > Research and Development Team > Kabelfoon > > > ----- End forwarded message -----
