| COMMIT RELEASE; vs COMMIT; [message #272897] |
Mon, 08 October 2007 02:28  |
dhristov
Messages: 2
Registered: October 2007
|
Junior Member |
|
|
I'm trying to understand when should I use COMMIT WORK RELEASE and when COMMIT. I've seen both statements in production code, but still cannot tell any difference.
the Pro*C/C++ Precompiler Programmer's Guide says that "The RELEASE option frees all Oracle resources (locks and cursors) held by your program and logs off the database."
Then I assume that the "COMMIT;" option does not relase the cursors and locks. Why would I need that? And if I use a simple "COMMIT;" statement isn't Oracle going to release the lock anyway?
Or am I wrong?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
