title: Calling a stored procedure in Oracle with IN and OUT parameters
body: <p>I have this procedure:</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE PROC1(invoicenr IN NUMBER, amnt OUT NUMBER)
  AS BEGIN
  SELECT AMOUNT INTO amnt FROM INVOICE WHERE INVOICE_NR = invoicenr;
  END;
  </code></pre>
  
  <p>So when I run it like this it returns absolutely nothing:</p>
  
  <pre><code>DECLARE
      amount NUMBER;
  BEGIN
      PROC1(1000001, amount);
      dbms_output.put_line(amount);
  END;
  </code></pre>
  
  <p>BTW I use DreamCoder for Oracle. Is there a problem with the procedure itself or with the way I call it? There is an entry in the INVOICE table with INVOICE_NR equal to 1000001.</p>