Somebody already used the class oracle.aurora.rdbms.OracleDBMSOutputStream ?

[vinaws]

Hi.

I'm trying to debug a Java Stored Procedure, and I heard about the class oracle.aurora.rdbms.OracleDBMSOutputStream , that is equivalent to DBMS_OUT (PL/SQL). This class allows to put messages in the SQL*Plus buffer at runtime of the procedure. Since last week I've been tried to find the API documentation of the package oracle.aurora.rdbms.* unsuccessfully. Somebody already used this class ?

Vinicius Shtorache
Medisoft Ltda
Curitiba - Brasil

[TimHall]

Hi.

Answered in: http://www.oracle-base.com/Forum/ReadMessage.asp?id=815&forum_id=1

You don't need to worry about doing anything special. Simply print to the console as normal within your Java:

System.out.println("Hello!");

Before you call the Java stored procedure from SQL*Plus simply do the following:

SET SERVEROUTPUT ON SIZE 1000000
CALL DBMS_JAVA.SET_OUTPUT(1000000);

The output should be displayed like normal DBMS_OUTPUT.

Cheers

[vinaws]

Thanks, Tim !