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.
Thomas
---
Thomas Anhaus
SAPDB, SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
