title: compile procedure in oracle 11g
body: <p>I create a simple procedure in oracle 11g with the client squirrel, this s the code</p>
  
  <pre><code>create or replace procedure EXAMPLE_P is
  begin
      1+2;
  end;/
  </code></pre>
  
  <p>while executing i got this warning</p>
  
  <pre><code>Warning:   Warning: execution completed with warning
  SQLState:  99999
  ErrorCode: 17110
  Position: 0
  
  Query 1 of 1, Rows read: 0, Elapsed time (seconds) - Total: 0.031, SQL query: 0.031, Building output: 0
  </code></pre>
  
  <p>The problem here, i can't call my procedure.</p>
  
  <pre><code>begin
      EXAMPLE_P();
  end;/
  </code></pre>
  
  <p>I got this error when i execute the block above.</p>
  
  <pre><code>Error: ORA-06550: line 2, column 9:
  PLS-00302: component 'EXAMPLE_P' must be declared
  ORA-06550: line 2, column 2:
  PL/SQL: Statement ignored
  
  SQLState:  65000
  ErrorCode: 6550
  Position: 37
  </code></pre>
  
  <p>The procedure exists in the table ALL_OBJECTS with the status INVALID.
  I tried to compile it (validate the status) but i won't work with the query below</p>
  
  <pre><code>alter procedure EXAMPLE_P COMPILE;
  </code></pre>
  
  <p>SomeOne knows what i can do to call my procedure, (i used PL/SQL developer and never meet this problem)</p>