Where is console output sent (System.out/System.err) in stored procedures written in Java?
Created May 7, 2012
Luigi Viggiano With Oracle, console output from
System.out.println()statements will be written to trace files in the Oracle UDUMP destination directory.
source: Oracle FAQ: Java Database Connectivity (JDBC) and JSQL, "What happens when you write to the console from a Java Stored Procedure?"
Joe Sam Shirah adds:
This is apparently one of those cases that is OS and/or DBMS engine dependent. On the AS/400, for example, any Java batch program ( one not running in an interactive subsystem ) sends System out and err to a spooled file ( queued printer output ). Therefore, if one wants to be portable, it might be best to redirect these streams to standard files.