Lucas Cao wrote : >I write some dbproc in oracle mode. But the subtrans statement can't be used in >oracle mode procedure. Who >can tell me how to issue subtransactions in this >situation. Thx in advance.
In oracle mode subtransactions are named 'savepoint's. You have to provide a name for each savepoint. Later you can rollback to that savepoint. Example : savepoint SP1 insert into tab values (1) savepoint SP2 insert into tab values (2) rollback to SP2 select * from tab returns one row (1). 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
