in reply to Re^6: Closing Oracle cursors
in thread Closing Oracle cursors

To be honest, I'm not entirely sure. I haven't used cursors/refs wrt DBD::Oracle. What versions of each do you have?

The only other suggestions I can offer is to find a DBD::Oracle forum and/or try the following I found in the Changes:
Added ability to pass existing DBD::Oracle select statement handle (cursor) back _into_ Oracle as a ref cursor type thanks to Mike Moretti. Note that this enables a workaround for closing ref cursors: $dbh->do("BEGIN CLOSE :cursor; END;", undef, $sth_ref_csr_to_close);

Replies are listed 'Best First'.
Re^8: Closing Oracle cursors
by mickey (Acolyte) on Apr 19, 2005 at 20:15 UTC

    DBD::Oracle 1.16
    DBI 1.43
    Perl 5.6

    I tried that workaround as well and I get a different error: 

    panic: dbd_rebind_ph alen 23 > maxlen 0 (incnul 0) at C:/Perl/site/lib
+/DBI.pm line 1428.

    [download]

    So I'm not sure where to go myself.

    Thanks very much for looking into it, anyway!

[reply]
[d/l]

In Section Seekers of Perl Wisdom