Java stored procedure : how to get the output written to system.out ?

[Juergen Lumera]

Hello,

maybe this is very stupid question but i have no idea how i can display the output written to standard.out within a Java stored procedure. Of course i know there is a logfile on the server where i can find this information, but i thought it must be possible to display this file inside PL/SQL Developer just in the time i execute the PL/SQL wrapper for th eJava code.

any hints ?

Juergen

 

[JohnnyBeGood]

In a test window write this

declare
-- Local variables here
i number;
begin
dbms_java.set_output(100000);

execute your java procedure here
end;

In the DBMS_OUTPUT window you'll see the result