faqts : Computers : Programming : Languages : PHP : Database Backed Sites : Oracle

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

17 of 20 people (85%) answered Yes
Recently 8 of 10 people (80%) answered Yes

Entry

Why does my Oracle SQL get committed even if I don't call commit?

Jul 8th, 1999 21:12
Nathan Wallace, Mark Britton


Oracle will do an automatic commit at the end of your php3 script if you
don't do a rollback before then.  This is Oracle behavior, not php. 
This is the same behaviour you would see in SQL*PLus.  If you run your
procedure from SQL*Plus and then exit, your changes will be committed
even though you never explicitly committed.