Yann Michel wrote : >Hello,
>I have a question concerning the transaction handling in stored >procedures. Does SAP-DB support transaktions in stored procedures or is >a procedure call a transaction (similar to postgresql)? >I'd like to loop over a cursor and commit a single row or roll it back. >Regards, >Yann SAP-DB does NOT support transactions in stored procedures and a procedure call is NOT a transaction. Instead a procedure behaves like any other sql statement, if the procedure is embedded in a subtransaction. This is not done automatically, but it's recommend to follow this guideline. For further information please see http://listserv.sap.com/pipermail/sapdb.general/2002-March/011112.html where a similar question has already been answered. Best Regards, Thomas -- Thomas Anhaus SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
