Home » RDBMS Server » Server Administration » Cursors and COMMIT
Cursors and COMMIT [message #56609] Fri, 11 April 2003 09:14 Go to next message
G Raghunath
Messages: 8
Registered: November 2002
Junior Member
Does Oracle CLOSE the EXPLICIT CURSORS automatically when the COMMIT statement is issued after a transaction.

Or should i manually close the CURSORS after a transaction is done.

Thanks in Advance

Report message to a moderator

Re: Cursors and COMMIT [message #56610 is a reply to message #56609] Fri, 11 April 2003 10:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
you should manually close the cursors

Report message to a moderator

Re: Cursors and COMMIT [message #56626 is a reply to message #56609] Sat, 12 April 2003 07:23 Go to previous message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
I think they will persist till you close the session...so u should close them manually..

sai

Report message to a moderator

Previous Topic: Which Explain Plan is better?
Next Topic: Analyze table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:41:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.