Re: SELECT currentlyExecutingFunctionName FROM somewhere

Hi

use dbms_utility.format_call_stack, this can be used to get the name of the function/procedure etc you are in. See Tom Kytes book page 1181 and also probably on his site http://asktom.oracle.com for examples or simple search google.

hth

kind regards

Pete

In article <d0fe74f0.0306230117.79b1eb3_at_posting.google.com>, Gary Holdham II <fredfred560_at_hotmail.com> writes
>Hi, the following procedure prints out 'test_procedure', which is the
>currently executing procedure name. The problem is I have to hard-code
>it. Is there a way to retrieve the currently executing
>procedure/function name (I am wanting this for an error-trapping piece
>of code, to include the procedure/function name in an
>RAISE_APPLICATION_ERROR operation).
>Thank you
>Gary
>
>
>CREATE OR REPLACE PROCEDURE test_procedure AS
> BEGIN
> DBMS_OUTPUT.PUT_LINE('test_procedure');
> END;
>/

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.