var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: error handling in oracle
hello guys i need some help on error handling mechanism of oracle form developer.
how can i catch the form-<err_code> errors on oracle form developer? i can catch the exception ora-<err_code> but i dont know the way to catch the exception and handling them.
thanks in advance.
sorry for my English
Something like this?
IF error_code = <FRM error code here> THEN
thanks Littlefoot for you reply.
consider the example,
declare invalid_data exception;
when invalid_data then
<show some alert>
as far as i know this will catch the ORA-50016 exception and displays an alert to the user. but if i want to catch FORM-50016 will it work?
FORM-50016: Legal characters are 0-9 - + E .
i have a format mask on a number field. and if i enter char and try to continue then this exception is raised.
sorry for my English.
Originally Posted by Littlefoot
use the above code in ON-ERROR trigger at form level and ur problem will get fixed.
thanks Littlefoot and alliadnan for your post.
yes the problem if fixed
thanks you guys.
have a nice week.