[Q] execute PL/sql code NO output display on screen????

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Thu, 13 May 2004 12:06:14 -0700 (PDT)
Message-ID: <20040513190614.51351.qmail@web60802.mail.yahoo.com>

I execute PL/SQL code to call UNIX shell script, but it did NOT display output on screen. The ORACLE version is 9.2.0.5 on SUN Solaris 8.

Any ideal?

/home/app/oracle/sql/tmp[57]%pg aaa.sh
ls -al | tee /home/app/oracle/sql/tmp/aaa.log date
IFSS::/home/app/oracle/sql/tmp[58]%sqlplus

SQL*Plus: Release 9.2.0.5.0 - Production on Thu May 13 15:02:53 2004

Enter user-name: duffy
Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production

SQL> set serveroutput on
SQL> set long 10000
SQL> exec shell('sh /home/app/oracle/sql/tmp/aaa.sh');

PL/SQL procedure successfully completed.

SQL> host
/home/app/oracle/sql/tmp[34]%ls -lt
total 124
-rw-r--r-- 1 oracle dba 795 May 13 15:03
aaa.log
-rwxr-xr-x 1 oracle dba 52 May 13 15:02
aaa.sh
-rwxr-xr-x 1 oracle dba 1700 May 13 14:11
shell.so
-rw-r--r-- 1 oracle dba 584 May 13 14:09 shell.o

Do you Yahoo!?
Yahoo! Movies - Buy advance tickets for 'Shrek 2' http://movies.yahoo.com/showtimes/movie?mid=1808405861

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Thu May 13 2004 - 15:16:47 CDT