How to print logs captured using dbms_output.put_line() in log files.

[Legacy User]

I am new to AutoSys and looking for information on printing logs captured using SET SERVEROUTPUT ON in oracle. We have a script which basically invokes a SQL File which in terms call a PROCEDURE.

In SQL File - We have defined set serveroutput on and spool location etc. We are observing the spool file is getting created but we are not observing any statement printed using dbms_output.put_line(). Can someone please help me or point me to documentation how we can get the logs printed captured using dbms_output.put_line().

 

Thanks

Priyank Jain

[Chandru.Venkataraman]

Hi Priyank,

Please ensure you don't have a dbms_output.disable set in the $ORACLE_HOME/sqlplus/admin/glogin.sql or $SQLPATH/loging.sql files.

I am able to see the lines printed with dbms_output.put_line() in the spool. By default SQLPlus does a "dbms_output.enable(...)"  unless overriden by the glogin.sql or login.sql files.

 

Thanks,

Chandru