I did a Trigger After Insert on a table, and I would like to test a condition and send a message to the user if this conduct is true. I did like this:
If Vn_Realizado > Vn_Orcado Then
RAISE_APPLICATION_ERROR (-20500,'O Valor Realizado é Superior ao Orçado! ');
End if;
Someone has any suggestions.
Note: We use Oracle's EBS and the message would have to appear in EBS Core Forms at the time the user is inserting a new record.