dear brothers

assalamo alikom
i have learned in the forum about how to suppress oracle messages and errors
there was many solution proposed such as:
-system.message_level
-console_window
-on_message and on_error triggers
but they give solutions to some problems like frm-40400 message
but they don't resolve the problem for the message that arrive when we make changes and we want to close the window so they ask us "do you want to save changes"
i ask if there is one of the brothers in the forum who have a real and experimented solution to this problem

your brother in islam
thank you

My Sister,,,,
in the first welcome in arab oracle site and you have tow problem
and i think this is solution :
1-for error message you can display this error i mean error code and error number and details
go to this link

Click here

2- about message frm-40400 this is message not for error this is tell you , you dont have any changes in your database i mean update ,insert or delete
so you can put this code for tell you if you want to save change or not
you can put it in level form that trigger name KEY-EXIT

/* if the previous commit was successful then the form status
    would not be CHANGED or INSERT  */
 if :SYSTEM.FORM_STATUS in ('CHANGED','INSERT') then 
    return(FALSE);
 else
    return(TRUE);
 end if;

and put this code in trigger name ON-COMMIT

commit_form ;
 if not form_success then
    raise form_trigger_failure ;
 end if ;

i hope this is explain help you
and you are welcome

تم تعديل 31 يوليو 200520 سنة بواسطة Admin05

thank you very much brother admin-05 and i will try your solution

my brother admin05
i have tried your preposition about the message "do you want to save" but it doesn't work
and it return an error message
that return built in must be in a procedure or function

i hope that you or any one of our brother in the forum
have a real and experienced solution to
this problem
and thank you previously