title: Find out name of PL/SQL procedure
body: <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>