Getting values into SQLPLUS from Unix

Hi,

I have some small code that looks like this:

sqlplus /nolog <<EOF

   connect / as sysdba
   ALTER SESSION SET CURRENT_SCHEMA=&1
   exec dbms_snapshot.refresh(UPPER('&1.&2'));    exit
EOF I want to pass in the values for &1 and &2........I am calling this from a Unix shell script. Any ideas?

Thanks,

Arthur Received on Thu Dec 15 2005 - 09:49:03 CST