Skip to content

Wrong default value for USE_LOG4J #3

Description

@soliverr

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

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions