passing parameters to unix takes the following form :

1. call the unix script with the paramters

unix_script p_uid p_pwd

the p_uid and p_pwd will appear in Unix script as $1 $2



2. Now unix script in turn will do following to make use of
two paramters

1. make a x.sql script with two DEFINE paramters.

echo 'DEFINE p_uid='$1 >> x.sql
echo 'DEFINE p_pwd='$2 >> x.sql

2. run another .sql script which will first run x.sql and
call the procedure or select statement while using
&p_uid and &p_pwd.


I hope this helps.

Regards

gtm