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?
U have to use package dbms_debug.
More indormation u can find in :
Click Here to Expand Forum to Full Width