Oracle | DBMS_CMP

Oracle DBMS_CMP_INT Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Content Management Program Support Utilities

AUTHID DEFINER

Data Types CMP_CTX_TYP LISTVALLIST PINTLIST ROWIDLIST SCAN_CTX_LIST SCAN_CTX_TYP

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