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
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
ummm ... something like
system('`my_code`'); --- check there are backticks ...
Not sure if it will run, but hey ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly
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