RE: OS calls with java stored procedures

2003-12-09 Thread Richard Ji
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 outp

RE: OS calls with java stored procedures

2003-12-09 Thread Jamadagni, Rajendra
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 pe

RE: OS calls with java stored procedures

2003-12-09 Thread John Flack
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 se