Home » SQL & PL/SQL » SQL & PL/SQL » cursor (Oracle9i)
cursor [message #437421] Mon, 04 January 2010 06:18 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
Hi all
In CURSOR where should we use COMMIT before CLOSE cursor statement (or) after CLOSE Cursor statement.Please Help me.
Re: cursor [message #437430 is a reply to message #437421] Mon, 04 January 2010 06:52 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
Why do you think you need a commit at all?
Re: cursor [message #437435 is a reply to message #437421] Mon, 04 January 2010 07:15 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
This will help you.

serach before post.

sriram Smile
Re: cursor [message #437451 is a reply to message #437421] Mon, 04 January 2010 08:10 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ANSI norm says that if you terminate a transaction, all cursors are closed.
This is not what Oracle does and let you choose but if you terminate the transaction before closing you do not master the rollback and read consistency information.

Regards
Michel
Previous Topic: PLS-00201
Next Topic: How to get all the running process in oracle
Goto Forum:
  


Current Time: Fri Dec 09 08:10:39 CST 2016

Total time taken to generate the page: 0.15709 seconds