From UNIX shell, if you would like to connect to sqlplus
and do some processing, you can go about this way by enclosing the following in a shell script

sqlplus -s user_id/passwd << end-it

set pages 0 feedback off echo off

--run the procedure you want to
@proc_name;

exit;

end-it

Run the above script at the shell command prompt

[Edited by seshagiri on 03-14-2001 at 11:21 AM]