|
[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]
|
Re: close open cursors with DBI
|
--- "William G. Zappasodi" <bz@crestecdigital.com> wrote:
> Is there a way to close open cursors in Oracle (9i) using DBI.
> Or, does finish() take care of that?
Depends what you mean.
The implicit cursor off a statement handle is normally handled by finish(),
yes.
A cursor in a PL/SQL block run through DBI would need to be closed in the
PL/SQL block.
A curor returned via the RSET ability of DBD::Oracle can be closed; there's a
method to do this in the DBD::Oracle pod (similar to the other example
posted).
If it's something else, I think we'lll need more detail...
-Craig.
craig@blackfog.net cpearlma@yahoo.com
http://craig.blackfog.net http://www.openroleplaying.org
----------------------------------------------------------------------
Y! : cpearlma AIM: craigpearlman
MSN: cpearlma@yahoo.com ICQ: 211121815
----------------------------------------------------------------------
"Fantasy is hardly an escape from reality. It's a way of understanding
it." -- Lloyd Alexander
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
-
**Majordomo list services provided by PANIX <URL:http://www.panix.com>**
**To Unsubscribe, send "unsubscribe phl" to majordomo@lists.pm.org**
|
|