Home » SQL & PL/SQL » SQL & PL/SQL » Update Cursors and their locks
Update Cursors and their locks [message #39459] Thu, 18 July 2002 03:19 Go to next message
Mark Grimshaw
Messages: 73
Registered: June 2002
Member
Hi,

A quick question. If you have a Cursor variable that
has been opened within a Stored Procedure for update access and sent back to a client program, does the lock on the result set from the query get unlocked if the COMMIT keyword is NOT used in the client program ? In short, what happens if you forget to close the cursor or commit ?

Thanks

Mark Grimshaw

Report message to a moderator

Re: Update Cursors and their locks [message #39470 is a reply to message #39459] Thu, 18 July 2002 08:44 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
If there is no COMMIT or ROLLBACK issued, the rows will remain locked until the session terminates.

Report message to a moderator

Previous Topic: converting a number to 2 decimal places
Next Topic: & in pl/sql ????
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 16:25:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.