dbms_java.set_output redirects outputof Java procedures/triggers to dbms_output.
create or replace and compile java source named tq84_src as
public class tq84_cls {
public static void write(String msg) {
System.out.println (msg);
}
}
/
alter java source tq84_src compile;
create or replace procedure tq84_write(msg varchar2) as
language java
name 'tq84_cls.write(java.lang.String)';
/
The following procedure executes ok, but nothing is (visibly) printed:
begin
tq84_write('hello world');
end;
/
Enabling output and trying again:
begin
dbms_java.set_output(10000);
end;
/
begin
tq84_write('hello world');
end;
/
If still nothing is visible, perhaps serveroutput (SQL*Plus) needs to be enabled, too:
set serveroutput on
begin
tq84_write('hello world');
end;
/
Cleaning up:
drop procedure tq84_write;
drop java source tq84_src;