Hi fellas,
I have comacross 100501 Non-Oracle exception in one of my oracle form yesterday. 100501 is the error code of FORM_TRIGGER_FAILURE. In my form, after firing some validation, this non oracle exception message poped up and then gone after click on the ok button on the message box. This message didn't do any harm my form's functionality but do kind of a harm in QC (quality controlling) phase.
the previous developer who modified the form i'm working now used RAISE FORM_TRIGGER_FAILURE in exception handling area. The original code is,
EXCEPTION
WHEN OTHERS THEN
set_application_property(CURSOR_STYLE, 'DEFAULT');
alert_message(110,SQLERRM);
ROLLBACK;
RAISE FORM_TRIGGER_FAILURE;
The relevant exception in my scenario is a FORM_TRIGGER_FAILURE. Therefore the relevant error code is displaying via alert_message. In a scenario like this simply you can comment the relevant code which is responsible of displaying error messages or you could simple write a small coding part like below to handle that scenario separately.
EXCEPTION
WHEN FORM_TRIGGER_FAILURE THEN
set_application_property(CURSOR_STYLE, 'DEFAULT');
ROLLBACK;
RAISE FORM_TRIGGER_FAILURE;
WHEN OTHERS THEN
set_application_property(CURSOR_STYLE, 'DEFAULT');
alert_message(110,SQLERRM);
ROLLBACK;
RAISE FORM_TRIGGER_FAILURE;
Most valuable code is,
WHEN FORM_TRIGGER_FAILURE THEN
RAISE FORM_TRIGGER_FAILURE;
I have comacross 100501 Non-Oracle exception in one of my oracle form yesterday. 100501 is the error code of FORM_TRIGGER_FAILURE. In my form, after firing some validation, this non oracle exception message poped up and then gone after click on the ok button on the message box. This message didn't do any harm my form's functionality but do kind of a harm in QC (quality controlling) phase.
the previous developer who modified the form i'm working now used RAISE FORM_TRIGGER_FAILURE in exception handling area. The original code is,
EXCEPTION
WHEN OTHERS THEN
set_application_property(CURSOR_STYLE, 'DEFAULT');
alert_message(110,SQLERRM);
ROLLBACK;
RAISE FORM_TRIGGER_FAILURE;
The relevant exception in my scenario is a FORM_TRIGGER_FAILURE. Therefore the relevant error code is displaying via alert_message. In a scenario like this simply you can comment the relevant code which is responsible of displaying error messages or you could simple write a small coding part like below to handle that scenario separately.
EXCEPTION
WHEN FORM_TRIGGER_FAILURE THEN
set_application_property(CURSOR_STYLE, 'DEFAULT');
ROLLBACK;
RAISE FORM_TRIGGER_FAILURE;
WHEN OTHERS THEN
set_application_property(CURSOR_STYLE, 'DEFAULT');
alert_message(110,SQLERRM);
ROLLBACK;
RAISE FORM_TRIGGER_FAILURE;
Most valuable code is,
WHEN FORM_TRIGGER_FAILURE THEN
RAISE FORM_TRIGGER_FAILURE;