Skip to Main Content

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!

dbms_error_code has wrong value ora-1403

260532Aug 7 2003 — edited Aug 8 2003
help, we can't find a solution or workaround for the following problem.

We have different scenario's were the content of dbms_error_code in the on-error trigger is wrong.

In this scenario i enforce a primary key violation.

result :
dbms_error>-1403 - ORA-01403: no data found
error_code>FRM-40735 ON-INSERT trigger raised unhandled exception ORA-00001

As you can see the forms error_text is aware of the ora error, but the content of the dbms_error code is wrong.

i encountered lots of problems on metalink but none of them really offered a solution for me.

we tried running patchset14 but this offers no solution for the problem.

all ideas are welcome.
chris
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 5 2003
Added on Aug 7 2003
8 comments
664 views