title: passing parameters from unix to pl sql
body: <p>I have a dumb problem.
  From a ksh I'm connecting to sql plus to execute some query.
  I want to pass 2 parameters from unix to pl sql.
  I found some stuff but it does not works.</p>
  
  <p>UNIX:</p>
  
  <pre><code>sqlplus -L $ORA_CONNECT @"$FIC_REQ" $1 $2
  </code></pre>
  
  <p>PLSQL:</p>
  
  <pre><code>   DECLARE
  
       param1 := $1;
       param2 := $2;
  BEGIN
  
   SELECT * from MYTABLE where field1=param1 and field2=param2;
  
  END
  </code></pre>
  
  <p>Any idea how to do it ?</p>
  
  <hr>
  
  <p>Actually, I got it.</p>
  
  <p>I must use a double dollar in plsql, like</p>
  
  <p>param1:=$$1
  param2:=$$2</p>