Skip to content

Wrong default value for USE_LOG4J #3

@soliverr

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

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