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.
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@xxxxxxxxxx
http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMosicMain.html
-- Regards,