UNIX script problem with sqlplus

I have a unix file temp1.sql containing:

     spool temp1

     select part_id
     from product
     ;

     spool off

I want to run this automatically using crontab, so I have a unix file temp1.run containing:

     . ~/.profile
     sqlplus userid/password < temp1.sql
     mail tics28_at_email.sps.mot.com < temp1.lst

This essentially works but temp1.lst contains:

     SQL>
     SQL> select part_id
       2  from product
       4  ;

     PART_ID


     -----------------------------------


     A/32
     SQL>
     SQL> spool off

How can I suppress the SQL prompts and the sqlplus code from the output, so that I only get the data? When I run temp1.sql from within sqlplus, the output file temp1.lst just contains:

     PART_ID


     -----------------------------------


     A/32

As is probably quite obvious, I don't have a lot of UNIX ability!

--
Alan Long
Materials Systems Group
Motorola, East Kilbride, Scotland
email tics28@"spam-off"email.sps.mot.com (remove the "spam-off") Received on Thu Aug 20 1998 - 02:31:12 CDT