[Info-ingres] raise error - 11-02-2005 , 10:50 AM
I use a "raise error" statement in a data base procedure that is called by rule and this rule is fired by another data base procedure.
dpb_1 = BEGIN
SET colum = 1
rule_1 (execute procedure dbp_2 after update (colum) on table );
dpb_2 = BEGIN
RAISE ERROR 19001 ' Error message';
I want to know the value of raise error ( 19001 ) in the first data base procedure.
Re: [Info-ingres] raise error - 11-02-2005 , 02:20 PM
"Sergio" <sergio.sperandio66 (AT) tin (DOT) it> wrote
You can't. The documented behaviour is that then a rule fired procedure
gets an error it immediately loses control and the statement that caused the
rule to execute the procedure also gets rolled back.