Denesa,
(cc to dbi-users, hope you don't mind)
glad it worked.
Now I'm trying to close the
cursor, Would I close the cursor similar to the code below (does not work
by the way)?
I don't really understand that code below...
According to the DBD::Oracle docs, you have to close a ref cursor like so:
my $sql = $conn->prepare('BEGIN close :curref; END;');
$sql->bind_param(":curref", $sth, {ora_type => DBD::Oracle::ORA_RSET()});
$sql->execute;
( $sth is the ref cursor )
There was recently a discussion on this mailing list, whether this is really necessary.
Someone, who seemed to know what they were talking about, claimed that once you release the parent statement handle (the one that produced the cursor), the ref cursor will also be freed.
That would be nice.
Has a final verdict on this been reached ?
Thilo
