DBMS_OUTPUT and GTT issues running PL/SQL programs in Snaplogic
We are having issues with output when running our PL/SQL programs from Snaplogic.
Many of our existing pl/sql packages use DBMS_OUTPUT to write some information about the execution of the job–like row counts, any warning messages etc. When run from within Oracle, the DBMS_OUTPUT buffer gets automatically written to a log file. When run from Snaplogic, no log file is written.
PL/SQL programs that produce a more detailed report, use a Global Temporary Table, to build the report during processing, then write the data from the GTT to the report file at the end of the program. This doesn’t work in Snaplogic either, because instead of each job running in it’s own session, all of the oracle jobs that snaplogic runs use the same session–hence they share the same instance of the GTT. If multiple programs are running at the same time the reports become gobbledegook.
The end result is, every legacy PL/SQL program that we want to run from Snaplogic has to be rewritten.
Anyone else having this issue? What have you done about it?