Where is console output sent (System.out/System.err) in stored procedures written in Java?

Luigi Viggiano

With Oracle, console output from

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.