Home » SQL & PL/SQL » SQL & PL/SQL » Ref cursors in Oracle 9i
Ref cursors in Oracle 9i [message #7248] Fri, 30 May 2003 04:50 Go to next message
Paramjeet Singh
Messages: 2
Registered: May 2003
Junior Member
How the Oracle 9i take care of the ref cursors ? Is it not required to explicitly close the ref cursors in Oracle 9i ?
Like we use ref cursor as a pointer to a memory to return no of records to the frontend. Once frontend used that record then they have to call a method to close the ref cursor at Oracle level.
So my purpose to ask is that is it not required in case of Oracle 9i.

Report message to a moderator

Re: Ref cursors in Oracle 9i [message #7255 is a reply to message #7248] Fri, 30 May 2003 13:04 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
It is still a requirement in 9i that the host program close the cursor.

Report message to a moderator

Previous Topic: PL/SQL package
Next Topic: Java returns same timestamp
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 07 05:25:21 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.