117 DBMS_LOGSTDBY_CONTEXT
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.
This chapter contains the following topics:
See Also:
Oracle Data Guard Concepts and Administration for more information about SQL Apply and logical standby databases
117.1 DBMS_LOGSTDBY_CONTEXT Overview
SQL Apply processes have access to a context namespace called LSBY_APPLY_CONTEXT
.
The following table lists the predefined parameters associated with LSBY_APPLY_CONTEXT
that you can set and retrieve by using the procedures provided in the DBMS_LOGSTDBY_CONTEXT
package. The ability to set and retrieve the parameters in this way is useful when writing skip procedures that are registered with SQL Apply using the DBMS_LOGSTBDY.SKIP
and DBMS_LOGSTDBY.SKIP_ERROR
procedures.
Table 117-1 Predefined Parameters of Namespace LSBY_APPLY_CONTEXT
Parameter | Description |
---|---|
|
First 4000 bytes of the statement that the Apply process is processing. |
|
See Table 115-15 for a list of various statement types. |
|
Schema that owns the PL/SQL package being processed (if applicable). |
|
Name of the PL/SQL package being processed (if applicable). |
|
Name of the PL/SQL procedure being processed (if applicable). |
|
Current schema in effect when the DDL or PL/SQL procedure was executed at the primary. |
|
XIDUSN of the transaction at the primary database. |
|
XIDSLT of the transaction at the primary database. |
|
XIDSQN of the transaction at the primary database. |
|
Schema that owns the object being processed by SQL Apply (in the case of DML or DDL operations). |
|
Object name being processed by SQL Apply (in case of DML or DDL operations). |
|
Container where the target object or the PL/SQL procedure resides (in the case of a multitenant container database (CDB)). |
|
Text of the original error encountered by the SQL Apply process (if applicable). |
|
Text of the new error to be raised by the SQL Apply process (if applicable, See the DBMS_LOGSTDBY SKIP_ERROR Procedure ). |
|
Text of the replacement statement that SQL Apply must execute (If applicable, See the DBMS_LOGSTDBY SKIP Procedure). |
|
The skip action to be performed by SQL Apply (See the DBMS_LOGSTDBY SKIP Procedure). |
117.2 DBMS_LOGSTDBY_CONTEXT Security Model
The security model for the DBMS_LOGSTDBY_CONTEXT
package is the same as for the DBMS_LOGSTDBY
package.
See Also:
117.3 Summary of DBMS_LOGSTDBY_CONTEXT Subprograms
This table lists and briefly describes the DBMS_LOGSTDBY_CONTEXT
package subprograms.
Table 117-2 DBMS_LOGSTDBY_CONTEXT Package Subprograms
Subprogram | Description |
---|---|
Clears all parameters contained within namespace |
|
Clears the specific parameter. |
|
Retrieves the value for the specified parameter. |
|
Sets the named parameter with the specified value. |
117.3.1 CLEAR_ALL_CONTEXT Procedure
This procedure clears all parameters contained within namespace LSBY_APPLY_CONTEXT.
Syntax
DBMS_LOGSTDBY_CONTEXT.CLEAR_ALL_CONTEXT;
Parameters
None
117.3.2 CLEAR_CONTEXT Procedure
This procedure clears the specific parameter.
Syntax
DBMS_LOGSTDBY_CONTEXT.CLEAR_CONTEXT ( name IN VARCHAR2);
Parameters
Table 117-3 CLEAR_CONTEXT Procedure Parameters
Parameter | Description |
---|---|
|
Name of the parameter to be cleared. |
117.3.3 GET_CONTEXT Procedure
This procedure retrieves the value for the specified parameter.
Syntax
DBMS_LOGSTDBY_CONTEXT.GET_CONTEXT ( name IN VARCHAR2, value OUT VARCHAR2);
Parameters
Table 117-4 GET_CONTEXT Procedure Parameters
Parameter | Description |
---|---|
|
Name of the parameter. |
value |
The value retrieved for the parameter. |
117.3.4 SET_CONTEXT Procedure
This procedure sets the named parameter with the specified value.
Syntax
DBMS_LOGSTDBY_CONTEXT.SET_CONTEXT ( name IN VARCHAR2 value IN VARCHAR2);
Parameters
Table 117-5 SET_CONTEXT Procedure Parameters
Parameter | Description |
---|---|
|
Name of the parameter to be set. |
value |
Value to be assigned to the parameter being set. |