Wrong default value for USE_LOG4J
Opened this issue · 0 comments
soliverr commented
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