Re: UNIX script problem with sqlplus

Hi

Try adding this before your spool command:

set termout off ;
set heading off ;
set echo off ;
set feedback off ;

After the spool off type exactly the same but replace off by on.

In fact you should check your sqlplus environnment (SET command)

Hope it helps as I'm also quite new in Oracle and Unix...

Lalaina
In article <tics28-2008980831120001_at_tics28.sps.mot.com>,   tics28@"spam-off"email.sps.mot.com (Alan Long) wrote:
> 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")
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 20 1998 - 06:43:51 CDT