SQL & PL/SQL

Hi All,

I am working on Exception Handling for PL/SQL blocks, I am using the "DBMS_UTILITY.FORMAT_ERROR_BACKTRACE" to get the exact line number and the calling procedure stack. This works fine!!!

But if the exception is from a DML statement(Update or Delete), I would also like to get extra information like rowid.

I know we have something called DBMS_ERRLOG package which is used to log the DML errors are table level which can give this additional information, but I dont the extract table to be created and one more problem with this is it just logs the information and will not throw exception.

Not sure if there is a way to get the rowid from when others block using any statement or package??



Thanks,