|
-
doubt in exception and trigger,,, please help
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 ?
-
put it in the exception clause
-
Code:
BEGIN
BEGIN
stmt1;
EXCEPTION
WHEN no_data_found THEN NULL;
END;
stmt2;
END;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|