I have a main procedure which is used to invoke other sub-procedures. I've added the 'DECLARE EXIT HANDLER FOR SQLEXCEPTION' in the main procedure. But when any exception raised in sub-procedure, the HANDLER in main procedure doesn't work. So how can I catch exceptions generated in all sup-procedures?
vertion of my TD is 13.1, and the following is the simplified of my code.
Thanks for your reply. Have modified my procedures and used RESIGNAL to raise my own exception.