How to debug runtime errors?
Issue the following commands in SQL*Plus before running the java stored procedure: set serveroutput on size 1000000 exec dbms_java.set_output(1000000) One million (bytes) is the maximum size that the output buffer can be set to. You could also check the Oracle log files in the ‘background_dump_dest’ directory.