Oracle DBMS_LOGSTDBY_CONTEXT
Version 19.3

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
First Available 12.1.0.1
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/dbmslsby.sql
Subprograms
 
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

Related Topics
Built-in Functions
Built-in Packages
Contexts
What's New In 18c
What's New In 19c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx