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 ?
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 ?