On Thu, 2002-03-07 at 22:38, Anhaus, Thomas wrote: > Mark Wong wrote : > > >Are all statements in a stored procedure considered a single transaction > >where a commit is implicitly called when the stored procedure exits? > >This is assuming no commits or rollbacks are explicitly called in the > >body of the stored procedure. > > No, stored procedure calls behave like any other sql statement, i.e. they > are > NOT committed implicitly after the call. > Note : The <commit statement> and <rollback statement> are NOT permitted in > a > stored procedure.
Perhaps my question was a little unclear. I was attempting to ask whether commits are implicitly called after a <routine_sql_statement> in a stored procedure. Your response implies that they are not, athough it addresses calls to stored procedures. So if I have a series of inserts in a stored procedure, is there no way to force a commit after each insert? Thanks, Mark _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
