| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: stored procedure commit
A copy of this was sent to tobrien_at_reveregroup.com
(if that email address didn't require changing)
On Wed, 28 Oct 1998 14:29:36 GMT, you wrote:
>Does Oracle do an automatic commit at the end of a stored procedure, or is
>this controlled some other way?
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
You must commit yourself when you are ready. Certain tools/api's do it as well.
For example, when you EXIT from sqlplus, it commits for you.
Certain ODBC/JDBC adapters are in 'auto commit' mode by default (after every statement, they execute a commit).
But in general, its up to you to code 'commit' when you are ready to commit...
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
--
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 Wed Oct 28 1998 - 09:43:56 CST
 |
 |