how to post ALL errors on screen with one trigger

[Apprentice101]

So I would like to have all of the error messages that forms displays on the lower left to be displayed on a popup to the users. I dont not a custom message just whatever forms says, but in stead of showing it on the default area to display it on a popup

can you guys please help me with the code? or logistics to set it up?

thanks you.

 

[lewisp]

Reprogram ON-ERROR and put things like MESSAGE_TEXT, ERROR_TEXT etc in an alert.

 

[Apprentice101]

thanks Lewisp,

I have put a trigger at the form level "on-Error" with the following code that a friend gave me. It does run well, but it does not display anything.


DECLARE
err_code number := error_code;
err_type varchar2(3) := error_type;
err_msg varchar2(100) := error_text;
alert_button number;
chosen BOOLEAN;
BEGIN
IF err_code IN (40212, 41003) THEN
NULL;
ELSE
message(err_type||'-'||err_code||': '||err_msg, ACKNOWLEDGE);
END IF;
END;

 

[lewisp]

Try using MESSAGE_CODE, MESSAGE_TEXT or DBMS_ERROR_TEXT instead of error_text etc. to see if that gives you the result you want. You may have to determine the severity of the error to find out which of the codes you need to be looking at.