Yes, I am running a sql file from SQLPLUS.

TOm

--- Denny Koovakattu <[Email Address Removed] wrote:
> Hi,
>
> set echo on works only when running a SQL file .
>
> Regards,
> Denny
>
> --- Tom Smith <[Email Address Removed] wrote:
> > When I call sqlplus script from a shell script,
> the
> > set echo on command does not work.
> >
> > For example, I have the following shell script
> > -------------------------------
> > #!/usr/bin/ksh
> > #test.sh
> >
> > sqlplus scott/[Email Address Removed] > @junk.sql
> > EOF
> > -------
> >
> > junk.sql looks like this:
> >
> > spool junk.lst
> > set echo on
> > select count(*) from psoprdefn_tmp;
> > spool off
> > ------------------
> >
> > When I run the shell script, it does not print the
> > "select count(*) from psoprdefn_tmp; " in the
> > junk.lst
> > file.
> >
> > But if I run the script like the following, it
> > prints
> > the SQL command:
> >
> > sqlplus scott/[Email Address Removed] @Junk.sql
> >
> > Could somebody help me with this:
> >
> > Thanks,
> >
> > Tom
>
>
> =====
> --
> Denny Koovakattu
> denny.[Email Address Removed] http://oneco.net/
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Movies - coverage of the 74th Academy Awards®
> http://movies.yahoo.com/


__________________________________________________
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/
Oracle LazyDBA home page