PL / SQL (get pkg/func/proc name)

[jbpelletier]

Hi, i code a prod that i use in the exception part of "all" proc/func.. Its called like that

EXCEPTION
WHEN OTHERS THEN
Pr_Iv_Wlog('ERROR','PACKG_NAME.PROC_FUNC_NAME', SQLCODE ,SQLERRM); --this is save in a log table that add a timestamp
RAISE;
END;

i whant to "soft code" the part 'PACKG_NAME.PROC_FUNC_NAME' is there a way to get the package name and the proc/funct where the error occured?

tanx,
jb

 

[sem]

Try to use DBS_UTILITY.FORMAT_ERROR_STACK. It returns the whole stack with full set of ORA-06512 errors. But note that once the exaeption is catched it's no more an error.

Regards, Dima

http://seminihin.narod.ru