Trigger Showing Alert Message

[celsobtu]

Greetings !!!
Dear colleagues, I'm picking up to make Oracle display an informational message to the user, only informative. I do not want to lock anything ... just alert the user.
I did like this ...:
--------------------------------- -----------------------------------------------

Select all

 
create or replace trigger MostraAviso 
  before insert on tabelaX 
  for each row 
declare 
  -- local variables here 
begin 
 
---MSG DE AVISO 
   If (:new.ati_in_codigo in (3)) Then 
       raise_application_error(-20001,'..ATENÇÃO ! Produto Tóxico !'); 
   end if;   
END;   

------------------------------------------- ---------------------------------------
This way I did. .. the message is in loop ... this is the user clicks on ok .... and the message back on the screen .....

someone has any idea how to solve I can resolve this ...?
Thanks for the attention ....
Celsobtu

[kellcristina]

Celso,

Did you manage to display informational message?
had any other alternative?
I am also trying, but should not abort the inclusion / change of data.

Thanks!
Kelly

[rodfbar]

The message return from the trigger by the raise_application_error is returning to the application that the insert is with error, so it aborts the other insertions ...

return the messages at trigger level and include I unknown ...
I believe that you need to validate this message at application level ... along with your insert

abcs ..

[Trevisolli]

Or, another tip also ...
Play the value of this MSG in a log table, let the process continue and, at the end, in the application, display a window with this information ...
Whatever, send it there.

[kellcristina]

Hi guys!

As it is a non-custom application and there was no field available for viewing the message We resolve the problem by calling a procedure for sending e-mail.

Thanks for the tips !!!
Kelly