dbms_error_code has wrong value ora-1403
260532Aug 7 2003 — edited Aug 8 2003help, 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