找出PL/SQL过程的名称 [英] Find out name of PL/SQL procedure

问题描述

Oracle中的PL/SQL过程可以知道它自己的名字吗?

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

让我解释一下:

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

在执行%%something%%之后，变量v_procedure_name应该包含'SOME_PROCEDURE'.如果它包含该过程的object_id也可以，因此我可以在all_objects中查找名称.

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.

推荐答案

尝试:

v_procedure_name := $$PLSQL_UNIT;

如果您想知道自己所在的行号，还可以使用$$ PLSQL_LINE.

There's also $$PLSQL_LINE if you want to know which line number you are on.

这篇关于找出PL/SQL过程的名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！