title: How to execute an oracle stored procedure?
body: <p>I am using oracle 10g express edition. It has a nice ui for db developers. But i am facing some problems executing stored procedures. </p>
  
  <p>Procedure:</p>
  
  <pre><code>create or replace procedure temp_proc is
  begin
    DBMS_OUTPUT.PUT_LINE('Test');
  end
  </code></pre>
  
  <p>it is created successfully. But when i execute:</p>
  
  <p><code>execute temp_proc;</code></p>
  
  <p>it shows <strong>ORA-00900: invalid SQL statement</strong> </p>
  
  <p>So help needed here</p>