How to setup Automation Designer to save DBMS_OUTPUT to a file? I am a simple Automation Script to execute a procedure. The procedure contain DBMS_OUTPUT but this is not being save the file.
Add the Set server output on line before the execute procedure, this should save the DBMS_OUTPUT to the file you are pointing to.
set serveroutput on