Re: Display shell script output

If you want to see the command executed, try this

output=`sqlplus -s system/password<<EOF <system/password@%3C%3CEOF> set echo on
set termout on
set feedback on
Create user test identified by test
default tablespace rcvcat_tbs
quota 0 on system;
exit;
EOF`
echo $output

Hope this helps.

Limin.

On 7/14/06, Ranko Mosic <ranko.mosic_at_gmail.com> wrote:
>
> Hi List,
> I need to be able to see commands executed on the sceen - they are not
> echoed now:
> #!/bin/ksh
> sqlplus system/password<<EOF <system/password@%3C%3CEOF>
> set echo on
> set termout on
> set feedback on
> Create user test identified by test
> default tablespace rcvcat_tbs
> quota 0 on system;
> exit;
> EOF
>
>
> --
> Regards,
> Ranko Mosic
> Contract Senior Oracle DBA
> B. Eng, Oracle 10g, 9i Certified Database Professional
> Phone: 416-450-2785
> email: mosicr_at_rogers.com
>
> http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html
>
>

-- 
Regards,

Limin Guo.

--
http://www.freelists.org/webpage/oracle-l