Re: Java procedure in Oracle

ecejabs_at_ece.ericsson.se wrote:

> Hello !
>
> Does anybody know how to make traces with Java in Oracle? I have a
> java class, mapped to a PL/SQL procedure. I load that with the
> loadclass utility.
>
> But the problem is that I don't know how to print messages. Has Oracle
> Server any file where the System.out.println instruction is redirect?
>
> Thanks.
>
> Abel

Hi Abel,
The following is excerpted from one of the Oracle 8.1.6 manuals that deal with java (I don't remember which)

Redirecting Output on the Server

System.out and System.err print to the current trace files. To redirect output to
the SQL*Plus text buffer, use this workaround:

SQL> SET SERVEROUTPUT ON SQL> CALL dbms_java.set_output(2000);

The minimum (and default) buffer size is 2,000 bytes; the maximum size is 1,000,000
bytes. In the following example, the buffer size is increased to 5,000 bytes:

SQL> SET SERVEROUTPUT ON SIZE 5000 SQL> CALL dbms_java.set_output(5000);

Output prints at the end of the call.

HTH,
Avi. Received on Mon Oct 30 2000 - 23:43:12 CST