RE: OS calls with java stored procedures

From: Richard Ji <Richard.Ji_at_ztango.com>
Date: Tue, 09 Dec 2003 15:29:24 -0800
Message-ID: <F001.005D953F.20031209152924@fatcity.com>

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: JohnF_at_smdi.com

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: ListGuru_at_fatcity.com (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: Richard.Ji_at_ztango.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------