Raise Error Message [message #508578] |
Mon, 23 May 2011 04:45 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
meim
Messages: 35 Registered: July 2009
|
Member |
|
|
Hello,
I have a form, and in one case i need to restrict the insert functionality. however, i am not allowed to do that in form level, so am trying now to have that on table level in which i use a trigger to raise error message using Raise_application_error.
Is there a way to control the place where my message should display? for now the trigger works fine, however, the error am getting is a technical message "FRM-40508: ORACLE error: unable to INSERT record " and i can only display my error message from Help > Display Error > Database Error .
Thanks,
Meim
|
|
|
|
Re: Raise Error Message [message #508594 is a reply to message #508592] |
Mon, 23 May 2011 05:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
meim
Messages: 35 Registered: July 2009
|
Member |
|
|
The problem is i can't made any change in form level ( no change at all). it is baseline form and we don't go for any customization.
so using on-error solution will not work with me.
changes i can do only on the custom trigger i implemented.
Thanks
|
|
|
|