How to find out line number, procedure name in PL/SQL in case of an error

bhagwat picture bhagwat · May 10, 2010 · Viewed 11k times · Source

I am using a D2k 6i form and getting the error on form from stored database(oracle9i) procedure ORA-00001:Unique constraint(.) violated but i m not able to trace out from which procedure it is coming. can anybody help me regarding this

Answer

akf picture akf · May 11, 2010

For posterity, here is the solution the OP found:

ok in D2k forms there is an ON-ERROR trigger where you can use the function DBMS_ERROR_TEXT to get the procedure,package name line number of the statement from where the error is coming