Oracle | DBMS_CMP

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	GET_NEXT_SCAN_SEQ	PUT_ROW_DIFS
CMP_TRACE_CLOB	IS_CMP_TRACING_ON	UPDATE_CMP_SCAN
DROP_CMP	PURGE_CMP	UPDATE_CMP_SCAN_NUM_ROWS
DROP_CMP_BY_CMPID	PUT_CMP_CTX	UPDATE_ROW_DIFS
GET_CMP_CTX	PUT_CMP_SCAN	UPDATE_ROW_DIFS2
GET_CMP_SCAN	PUT_CMP_SCANS	UPDATE_ROW_INSERTED_DIFS
GET_CMP_SCANS

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