Oracle | DBMS_LOGSTDBY

Oracle DBMS_LOGSTDBY_CONTEXT Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose As of Oracle Database 12c release 1 (12.1), SQL Apply processes have access to a context namespace called LSBY_APPLY_CONTEXT. You can use the procedures provided in the DBMS_LOGSTDBY_CONTEXT package to set and retrieve various parameters associated with LSBY_APPLY_CONTEXT. This is useful when writing skip procedures that are registered with SQL Apply using the DBMS_LOGSTBDY.SKIP and DBMS_LOGSTDBY.SKIP_ERROR procedures.

AUTHID DEFINER

Defined Context CREATE CONTEXT lsby_apply_context USING dbms_logstdby_context;

Dependencies

DBMS_SESSION

Documented Yes: Packages and Types Reference

First Available 12.1

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmslsby.sql

Subprograms

CLEAR_ALL_CONTEXT	GET_CONTEXT	SET_CONTEXT
CLEAR_CONTEXT

CLEAR_ALL_CONTEXT

Clears all parameter values dbms_logstdby_context.clear_all_context;

exec dbms_logstdby_context.clear_all_context;

CLEAR_CONTEXT

Clears the specified parameter value dbms_logstdby_context.clear_context(name IN VARCHAR2);

See GET_CONTEXT Demo Below

GET_CONTEXT

Retrurns a context parameter value dbms_logstdby_context.get_context( name IN VARCHAR2, value OUT VARCHAR2);

DECLARE

       outVal VARCHAR2(30);

      BEGIN

        dbms_logstdby_context.set_context('PACKAGE_SCHEMA', 'UWCLASS');

        dbms_logstdby_context.get_context('PACKAGE_SCHEMA', outVal);

        dbms_output.put_line('Before Clear: ' || outVal);

        dbms_logstdby_context.clear_context('PACKAGE_SCHEMA');

        dbms_logstdby_context.get_context('PACKAGE_SCHEMA', outVal);

        dbms_output.put_line('After Clear: ' || outVal);

      END;

      /

SET_CONTEXT

Sets the value of a named parameter dbms_logstdby_context.set_context( name IN VARCHAR2, value IN VARCHAR2);

See GET_CONTEXT Demo Above