Where is console output sent (System.out/System.err) in stored procedures written in Java?
Luigi Viggiano With Oracle, console output fromThis 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.
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: