alangibson/log4plsql

Wrong default value for USE_LOG4J

Opened this issue · 0 comments

PLOGPARAM package definition has DEFAULT_USE_LOG4J constant for LOG4J output mode in lines.

There is a check if package PLOG_OUT_AQ is installed.

A package PLOG_OUT_AQ may be installed by user: see install.sql

If PLOG_OUT_AQ package is not installed, we got an error in default output context:

SQL> exec plog.fatal( 'text' );
BEGIN plog.fatal( 'text' ); END;

*
ERROR at line 1:
ORA-20200: Parameter USE_LOG4J is TRUE but no advanced queue output (package
PLOG_OUT_AQ) is installed
ORA-06512: at "PL_SQL.PLOG", line 1432
ORA-06512: at "PL_SQL.PLOG", line 1542
ORA-06512: at "PL_SQL.PLOG", line 1824
ORA-06512: at "PL_SQL.PLOG", line 3056
ORA-06512: at line 1