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.
See Also:
Oracle Data Guard Concepts and Administration for more information about SQL Apply and logical standby databasesThis chapter contains the following topics:
Overview
Security Model
SQL Apply processes have access to a context namespace called LSBY_APPLY_CONTEXT
. Table 93-1 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 93-1 Predefined Parameters of Namespace LSBY_APPLY_CONTEXT
Parameter | Description |
---|---|
|
First 4000 bytes of the statement that the Apply process is processing. |
|
See Table 92-23 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). |
The security model for the DBMS_LOGSTDBY_CONTEXT
package is the same as for the DBMS_LOGSTDBY
package.
See Also:
DBMS_LOGSTDBYTable 93-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. |
This procedure clears all parameters contained within namespace LSBY_APPLY_CONTEXT.