Implicit Commit Question 1

[ctyankeeinok]

Simple question - shaking the rust off my brain...

There is a java program that calls an Oracle 9i function, which in turn calls multiple Oracle procedures and functions. Unfortunately, no commits are in the code. Is the commit done when control is returned to the java code, or is it possibly done at the end of the procedure called by the function?

 

[SantaMufasa]

Oracle purposely does not perform any implicit commits as a result of leaving/returning from a function or a procedure, nor by virtue of returning control to Java Code. If you want a COMMIT to occur within a procedure, then you should explicitly issue the COMMIT.

Implicit COMMITs occur under these circumstances:[ul][li]Execution of Data-Definition Language (DDL) commands:[/li][ul][li]CREATE[/li][li]ALTER[/li][li]DROP[/LI][li]TRUNCATE[/LI][/ul][li]Data-Control Language (DCL) commands:[/li][ul][li]GRANT[/li][li]REVOKE[/li][/ul][li]Graceful termination of an Oracle connection (e.g. explicit "exit" or "quit" from Oracle-connection application).[/LI][/ul]Let us know if this is helpful.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm. The cost will be your freedoms and your liberty.”

 

[ctyankeeinok]

Perfect. That is what I suspected, but I wanted to be certain. I could not find it in the docs (I know it must be there somewhere). Thanks for the help!