Click to See Complete Forum and Search --> : doubt in exception and trigger,,, please help


ravifrequent
03-26-2006, 12:56 AM
how to solve this exception problem ?? please help

Begin
STMT 1;(im-material if this stmt is executed)
STMT 2;(but this stmt shud be executed)

EXCEPTION
when NO_DATA_FOUND then
raise_app_error(err.num,err.mesg);
END

how do i get the STMT 2 stmt to get executed.if suppose STMT 1 gives error.

also how many maximum number of trigger can a table have ?

davey23uk
03-26-2006, 07:37 AM
put it in the exception clause

WilliamR
03-26-2006, 02:12 PM
BEGIN
BEGIN
stmt1;
EXCEPTION
WHEN no_data_found THEN NULL;
END;

stmt2;
END;