title: How to execute a oracle procedure from shell
body: <p>I have a stored procedure in oracle i want to call that procedure from cygwin. This is the  procedure </p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE greetings
  AS
  BEGIN
   dbms_output.put_line('Hello World!');
   END;
  </code></pre>
  
  <p>i am doing this </p>
  
  <pre><code>sqlplus -s system@orcl/oracle10g&lt;&lt;END
  execute greetings();
  commit;
  exit;
  END
  </code></pre>