title: Is it possible to pass bind variable as parameter?
body: <p>Is it possible to pass a bind variable to a procedure? Here a simplified snippet, to show what I'm trying to do:</p>
  <pre><code>CREATE OR REPLACE PROCEDURE TEST_CSV ( :d1 IN DATE DEFAULT null, :n1 IN NUMBER DEFAULT null)
  IS 
  BEGIN    
      SELECT DISTINCT * from table WHERE MY_NUM = :n1;    
  END;
  </code></pre>