Yes, it's
exec dbms_java.set_output(2000);

Richard Ji

-----Original Message-----
Sent: Tuesday, December 09, 2003 8:50 AM
To: Multiple recipients of list ORACLE-L


I'm working from memory here, but there is a procedure in a built-in package, I think 
it is DBMS_JAVA, that redirects standard output from a Java Stored Procedure to the 
same buffer that DBMS_OUTPUT uses.  You call this procedure, then your Java method, 
and then you can SET SERVEROUTPUT ON to see the output in SQL*Plus or you can read it 
with DBMS_OUTPUT.GET and DBMS_OUTPUT.GET_LINE.

-----Original Message-----
Sent: Tuesday, December 09, 2003 8:35 AM
To: Multiple recipients of list ORACLE-L


Im playing with the example in tom kytes book. we have alot of korn shell scripts that 
we use as functions. 

We 'echo' out values to standard out. is there anyway to catch this echo with a java 
stored procedure? I thought about redirecting it to a file and reading it in with 
utl_file, but that makes it more complex. 

any other way to do this? 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Flack
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Ji
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Reply via email to