Passing Parameter to SQL+ script containing PL/SQL block..

this line in UNIX shell script starts SQL+ to run a script (REPORT.sql) and pass it a parameter:

sqlplus -S user/pwd @REPORT.sql "MAINREPORT"

--this is REPORT.sql

BEGIN
  if '&1' = 'MAINREPORT'
  then

      CORP_PKG.MAINREPORT;
  else
    ....

END;
/

Can I use '&1' in the sql script to receive the parameter ? It does not seem to work....

Thanks
Rob Received on Thu May 16 2002 - 13:25:04 CDT