Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Dynamic SQL and commit processing ....
A copy of this was sent to ross_mcadam_at_my-dejanews.com
(if that email address didn't require changing)
On Fri, 05 Feb 1999 08:11:37 GMT, you wrote:
>I am coding dynamic insert, update and delete sql.
>
>Is it possible to control commit processing so I can apply all changes in a
>single commit?
>
>My understanding of the documentation is that an implied commit is performed
>every time the execute procedure is called.
>
No, thats not correct. An implied SAVEPOINT is issued before a procedure is called and if it fails, a rollback to that savepoint is issued (that makes procedures atomic, just like a statement is).
No implicit commits are done for you -- you must explicity commit or rollback to end a transaction.
>TIA...Ross
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sat Feb 06 1999 - 08:25:21 CST