For how many years have you been working
with physical servers that are starving your database of the memory
necessary to deploy important new performance features such as the Result
Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and
Full Database Caching? Too long? Contact me to learn how to improve all
queries ... not just some queries.
Purpose
On behalf of Database Vault evaluates a Rule Set in accordance with the options specified in the rule_set$ table.
dbms_macsec_rules.evaluate(
p_rule_set IN VARCHAR2,
p_sql_text IN VARCHAR2,
x_result OUT BOOLEAN,
x_rule OUT VARCHAR2,
x_rule_error OUT BOOLEAN,
x_handler_error OUT BOOLEAN,
x_error_code OUT NUMBER,
x_error_text OUT VARCHAR2);
PRAGMA SUPPLEMENTAL_LOG_DATA(evaluate, NONE);
dbms_macsec_rules.evaluate_tr(
p_rule_set IN NUMBER,
p_eval_ret IN OUT BINARY_INTEGER,
p_error_code IN OUT BINARY_INTEGER,
p_error_text IN OUT VARCHAR2) AS
LANGUAGE C
NAME "kzvdversetev"
LIBRARY DVSYS.KZV$RUL_LIBT
WITH CONTEXT PARAMETERS(context, p_rule_set OCINUMBER, p_eval_ret, p_error_code, p_error_text);
PRAGMA SUPPLEMENTAL_LOG_DATA(evaluate_tr, NONE);
This is a temporary wrapper for evaluate. OCI cannot pass BOOLEAN variables to or from PL/SQL so a wrapper is need to convert BOOLEAN to INTEGER
dbms_macsec_rules.evaluate_wr(
p_rule_set IN VARCHAR2,
x_result OUT INTEGER,
x_rule OUT VARCHAR2,
x_rule_error OUT INTEGER,
x_handler_error OUT INTEGER,
x_error_code OUT NUMBER,
x_error_text OUT VARCHAR2);
PRAGMA SUPPLEMENTAL_LOG_DATA(evaluate_wr, NONE);