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] 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




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