Alex Rivera | Logout

Find out name of PL/SQL procedure

Asked 2008-11-13T08:45:26.697
18

Can PL/SQL procedure in Oracle know it's own name?

Let me explain:

CREATE OR REPLACE procedure some_procedure is
    v_procedure_name varchar2(32);
begin
    v_procedure_name := %%something%%;
end;

After %%something%% executes, variable v_procedure_name should contain 'SOME_PROCEDURE'. It is also OK if it contains object_id of that procedure, so I can look up name in all_objects.

Edit
Report

1 Answer

3

If you are pre-10g, you can 'dig' (parse) it out of dbms_utility.format_call_stack Procedures/functions in packages can be overloaded (and nested), so the package name/line number is normally better than the name.

answered 2008-11-13T09:45:09.417

Your Answer