FRM-40735 : ON-ERROR trigger raised unhandled exception ORA-01001
Hi,
I have put in some code in CUSTOM.pll. It works fine if all the mandatory fields in the forms are supplied.
The forms raises the error FRM-40735 : ON-ERROR trigger raised unhandled exception ORA-01001 whenever a validation which is put in either API hooks or in the pl/sql packages fails and raises an error to be displayed on the screen.
Instead of displaying the user friendly message,it shows the error mentioned above.
I have used PRE-INSERT event in the forms.
Any pointers to this will be highly appreciated.
Thanks
Jujaar
I have put in some code in CUSTOM.pll. It works fine if all the mandatory fields in the forms are supplied.
The forms raises the error FRM-40735 : ON-ERROR trigger raised unhandled exception ORA-01001 whenever a validation which is put in either API hooks or in the pl/sql packages fails and raises an error to be displayed on the screen.
Instead of displaying the user friendly message,it shows the error mentioned above.
I have used PRE-INSERT event in the forms.
Any pointers to this will be highly appreciated.
Thanks
Jujaar
0