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

dba1 mcc wrote:

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

Are you using java?
if so, try this:
exec dbms_java.set_output(1000000)

-- 
Bricklen Anderson, Database Administrator
PresiNET Systems
http://www.PresiNET.com
Online Demo: https://www.presinet.com/secure/login

_______________________________________________________________________
This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than the
intended recipient is unauthorized. If you have received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
----------------------------------------------------------------
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
-----------------------------------------------------------------