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

<p>Let me explain:</p>

<pre><code>CREATE OR REPLACE procedure some_procedure is
    v_procedure_name varchar2(32);
begin
    v_procedure_name := %%something%%;
end;
</code></pre>

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

Try:
```
```
v_procedure_name := $$PLSQL_UNIT;
```
```
There's also $$PLSQL_LINE if you want to know which line number you are on.