Oracle DBMS_LOGSTDBY_CONTEXT
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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
Contexts
Packages
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved