Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

FRM-40735 : ON-ERROR trigger raised unhandled exception ORA-01001

jujaarDec 29 2009 — edited Dec 30 2009

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

Edited by: user12228437 on Dec 29, 2009 3:46 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 27 2010

Added on Dec 29 2009

#forms, #moved-from-devops

16 comments

6,821 views