Hi all,

Does anyone know how to detect if error occurred during runtime in a
transaction block?

For example :

        Begin tran A

        Drop table X #error will occurred because there is no table X

        #if error occurred go to exit point. This is the sql code I'm
asking.

        COMMIT TRAN A

        Exit : ROLLBACK TRAN A

Thanks,
Felix Ang


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to