-
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.
-
U have to use package dbms_debug.
More indormation u can find in :
http://docs.oracle.com/cd_a97630/app...ug.htm#1003779
