Friday, September 11, 2009

ERROE CODE WISE VALIDATION

BEGIN
IF MESSAGE_CODE = 40301 THEN
base_message_box
('Invalid Transaction No...
Use the Enquiry Mode, identify the Transaction No and then Proceed'
);
RAISE form_trigger_failure;
ELSE
MESSAGE (MESSAGE_TEXT);
END IF;
END;

No comments: