How to get the backend error/exception in forms alert at front end?

[dilipdafda]

Hi all,

I do not have the idea how could I get the backend error/exception message into forms6i application?

I used RAISE_APPLICATION_ERROR(error_number, error_text) in DB table's trigger, I want the message in my front-end. However, I am getting the error that Oracle unable to insert and on pressing shift + F1 I am getting the message that I wrote in DB. But I want it as an alert.

and can I give yes-no type alert there?

for example

create table test1(col1 number(2));

create trigger trg_test1
before insert on test1
for each row
begin
if col1 < 0 then
raise_application_error(-20001, 'Negative value not allowed..!!');
end if;
end;

when this is done, create one form with database block for table test1 and
try to insert negative value and save the transaction. it will give message oracle error, unable to insert, but not giving the message 'Negative value not allowed..!!' more over I don't want it on display line I want that message in alert.

and let me know, if we could give yes-no type message and on that basis we could take the decision in backend.

Dilip Dafda

[debasisdas]

you need to trap the error number from RAISE-APPLICATION_ERROR in the frontend to get the desired output.

[dilipdafda]

you need to trap the error number from RAISE-APPLICATION_ERROR in the frontend to get the desired output.

No, its not accomplished, you didn't get my problem, I already tried the same. I am getting "unable to insert record" error, instead of that I want my error message. if I press shift + F1 then I am getting the msg. in the error box. but I want it as a normal alert that user receives.

Also check for my other questions in the query.

[nramrits]

This One Is Useful For U
Pls Write This Code Into On-error Trigger In Form Level
Message(dbms_error_code||'-'||dbms_error_text);
Message(' ');-- It Display An Ora- Errors In Forms

Or
Message(error_code||'-'||error_text);
Message(' ');-- It Display An Forms Errors