Problem with Multiple transaction ROLLBACK

From: nick <nickcool_at_ms17.hinet.net>
Date: Fri, 28 May 1999 23:36:53 +0800
Message-ID: <7imd9s$1kc@netnews.hinet.net>

BEGIN

      SELECT ....;
      UPDATE ...;
      sp_ins (...);          /* suposed this procedure raise an error.
Rollback works well */


             .


             .


      sp_upd (...);        /* But when this procedure raise an error*/
      sp_del (...);         /* before this call already commit  WHY? */


             .


      INSERT ...;
EXCEPTION
         WHEN OTHERS THEN
                      ROLLBACK;
                      RAISE;
      COMMIT;

END; Thanks in advance,
Nick. Received on Fri May 28 1999 - 10:36:53 CDT