Java Programming

Hi Guys,

our application is written in java and lots of database processing done in custom stored procedure/pl/sql instead in java.

i am thinking how do we make the logging in stored procedure come out in the app server console or to the log file.. since dbms_out.put_line will not output anything if i call the stored procedure from java side.

one way i can think of is to create a wrapper ( outer stored procedure that will set the serveroutput on and bla bla bla ) in java and call the actual stored procedure and it will make all the dbms_out.put_line to be printed on the console?

Any other ideas ?

Thanks