Re: Auto-Commits in Stored Procedures?

From: Mike Burden <michael.burden_at_capgemini.co.uk>
Date: Fri, 05 Mar 1999 15:57:06 +0000
Message-ID: <36DFFED1.DE91A1DD@capgemini.co.uk>

If the procedure issues A DDL statement (like truncate) it will commit the transaction automatically.

Douglas Whitacre wrote:

> 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?
>
> Any help is greatly appreciated.
Received on Fri Mar 05 1999 - 09:57:06 CST