Hi,

I'm trying to write and error handling set of procedures for a large application. Is it possible to obtain the line number where a pl/sql error occurred? sqlerrm and dbms_utility.format_error_stack do not give me this infomation.

Oracle workflow manages to do this and log this information into the wf_item_activity_statuses table, does anyone know how it achieves this?


Thanks.

Daz.