Oracle DBMS_CMP_INT
Version 21c

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 Content Management Program Support Utilities
AUTHID DEFINER
Dependencies
COMPARISON$ DBMS_LOCK DBMS_SYSTEM
COMPARISON_COL$ DBMS_LOGREP_UTIL DBMS_SYS_ERROR
COMPARISON_ROW_DIF$ DBMS_PRIV_CAPTURE DBMS_UTILITY
COMPARISON_SCAN$ DBMS_SQL DUAL
COMPARISON_SCAN_SEQ$ DBMS_STANDARD PLITBLM
COMPARISON_SCAN_VAL$ DBMS_STREAMS_ADM_UTL USER$
COMPARISON_SEQ$ DBMS_STREAMS_DECL UTL_FILE
DBMS_COMPARISON    
Documented No
First Available Not known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvthcmp.plb
{ORACLE_HOME}/rdbms/admin/prvtbcmp.plb
Subprograms
 
CMP_TRACE
Undocumented dbms_cmp_int.cmp_trace(
message     IN VARCHAR2,
time_info   IN BOOLEAN,
event_level IN BINARY_INTEGER);
exec dbms_cmp_int.cmp_trace('Test Msg', TRUE, 1);

procedure successfully completed.
 
CMP_TRACE_CLOB
Undocumented dbms_cmp_int.cmp_trace_clob(
message     IN OUT    CLOB,
time_info   IN BOOLEAN,
event_level IN        BINARY_INTEGER);
DECLARE
 ioVar CLOB := 'Test Msg';
BEGIN
  dbms_cmp_int.cmp_trace_clob(ioVar, TRUE, 1);
  dbms_output.put_line(ioVar);
END;
/
Test Msg

procedure successfully completed.
 
DROP_CMP
Undocumented dbms_cmp_int.drop_cmp(cmp_ctx IN OUT sys.dbms_cmp_int.cmp_ctx_typ);
TBD
 
DROP_CMP_BY_CMPID
Undocumented dbms_cmp_int.drop_cmp_by_cmpid(
cmp_id    IN NUMBER,
userid    IN NUMBER,
user_name IN VARCHAR2);
TBD
 
GET_CMP_CTX
Undocumented dbms_cmp_int.get_cmp_ctx(
cmp_name  IN     VARCHAR2,
cmp_ctx   IN OUT sys.dbms_cmp_int.cmp_ctx_typ,
user_id   IN     NUMBER,
user_name IN     VARCHAR2,
is_dba    IN     BINARY_INTEGER);
TBD
 
GET_CMP_SCAN
Undocumented dbms_cmp_int.get_cmp_scan(
cmp_ctx  IN OUT sys.dbms_cmp_int.cmp_ctx_typ,
scan_ctx IN OUT sys.dbms_cmp_int.scan_ctx_typ);
TBD
 
GET_CMP_SCANS
Undocumented dbms_cmp_int.get_cmp_scans(
cmp_ctx          IN OUT sys.dbms_cmp_int.cmp_ctx_typ,
scan_ctx         IN OUT sys.dbms_cmp_int.scan_ctx_typ,
ch_scan_ctx_list IN OUT sys.dbms_cmp_int.scan_ctx_list);
TBD
 
GET_NEXT_SCAN_SEQ
Undocumented dbms_cmp_int.get_next_scan_seq RETURN NUMBER;
SELECT dbms_cmp_int.get_next_scan_seq
FROM dual;

GET_NEXT_SCAN_SEQ
-----------------
                1
 
IS_CMP_TRACING_ON
Undocumented dbms_cmp_int.is_cmp_tracing_on(event_level IN BINARY_INTEGER) RETURN BOOLEAN;
BEGIN
  IF dbms_cmp_int.is_cmp_tracing_on(1) THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
F

procedure successfully completed.
 
PURGE_CMP
Undocumented dbms_cmp_int.purge_cmp(
cmp_ctx    IN OUT sys.dbms_cmp_int.cmp_ctx_typ,
scan_ctx   IN OUT sys.dbms_cmp_int.scan_ctx_typ,
purge_time IN     TIMESTAMP);
TBD
 
PUT_CMP_CTX
Undocumented dbms_cmp_int.put_cmp_ctx(cmp_ctx IN OUT sys.dbms_cmp_int.cmp_ctx_typ);
TBD
 
PUT_CMP_SCAN
Undocumented dbms_cmp_int.put_cmp_scan(
cmp_ctx  IN OUT sys.dbms_cmp_int.cmp_ctx_typ,
scan_ctx IN OUT sys.dbms_cmp_int.scan_ctx_typ);
TBD
 
PUT_CMP_SCANS
Undocumented dbms_cmp_int.put_cmp_scans(
cmp_ctx           IN OUT sys.dbms_cmp_int.cmp_ctx_typ,
scan_ctx          IN OUT sys.dbms_cmp_int.scan_ctx_typ,
list_min_val_list IN OUT sys.dbms_cmp_int.listvallist,
list_max_val_list IN OUT sys.dbms_cmp_int.listvallist,
num_rows_list     IN OUT sys.dbms_cmp_int.pintlist,
status_list       IN OUT sys.dbms_cmp_int.pintlist);
TBD
 
PUT_ROW_DIFS
Undocumented dbms_cmp_int.put_row_difs(
cmp_ctx        IN OUT sys.dbms_cmp_int.cmp_ctx_typ,
scan_ctx       IN OUT sys.dbms_cmp_int.scan_ctx_typ,
start_idx      IN     NUMBER,
end_idx        IN     NUMBER,
loc_rowid_list IN     sys.dbms_sql.urowid_table,
rmt_rowid_list IN     sys.dbms_sql.urowid_table,
idx_val_list   IN     sys.dbms_sql.varchar2_table);
TBD
 
UPDATE_CMP_SCAN
Undocumented dbms_cmp_int.update_cmp_scan(
cmp_ctx  IN OUT sys.dbms_cmp_int.cmp_ctx_typ
scan_ctx IN OUT sys.dbms_cmp_int.scan_ctx_typ
status   IN     BINARY_INTEGER);
TBD
 
UPDATE_CMP_SCAN_NUM_ROWS
Undocumented dbms_cmp_int.update_cmp_scan_num_rows(
cmp_ctx  IN OUT sys.dbms_cmp_int.cmp_ctx_typ
scan_ctx IN OUT sys.dbms_cmp_int.scan_ctx_typ);
TBD
 
UPDATE_ROW_DIFS
Undocumented dbms_cmp_int.update_row_difs(
cmp_ctx  IN OUT sys.dbms_cmp_int.cmp_ctx_typ,
scan_ctx IN OUT sys.dbms_cmp_int.scan_ctx_typ);
TBD
 
UPDATE_ROW_DIFS2
Undocumented dbms_cmp_int.upate_row_difs2(
cmp_ctx     IN OUT sys.dbms_cmp_int.cmp_ctx_typ,
scan_ctx    IN OUT sys.dbms_cmp_int.scan_ctx_typ,
lrowid_list IN OUT sys.dbms_cmp_int.rowidlist,
rrowid_list IN OUT sys.dbms_cmp_int.rowidlist,
status_list IN OUT sys.dbms_cmp_int.pintlist);
TBD
 
UPDATE_ROW_INSERTED_DIFS
Undocumented dbms_cmp_int.update_row_inserted_difs(
cmp_ctx      IN OUT sys.dbms_cmp_int.cmp_ctx_typ,
scan_ctx     IN OUT sys.dbms_cmp_int.scan_ctx_typ,
lrowid_list  IN OUT sys.dbms_cmp_int.rowidlist,
rrowid_list  IN OUT sys.dbms_cmp_int.rowidlist,
local_insert IN     BOOLEAN);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_COMPARISON
What's New In 19c
What's New In 20c-21c

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