Auto-commit
in Stored Procedure
I have a stored procedure
which DOES NOT include a specific commit, yet the
changes in that procedure
get committed. I thought that by default if you
don't explicitly perform a
commit in a stored procedure that it would
rollback any changes made
to the tables. Can someone help with this? Is it
different when run through
SQL*Plus (taking the defaults) and through
compiled languages?
Ans1:
No, why should it? Still,
if *you* execute a rollback, then the changes made
by your stored procedure will
be undone as well.
Ans2:
If the procedure issues A
DDL statement (like truncate) it will commit the
transaction automatically.