Oracle | DBMS

Oracle DBMS_ODCI 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 This is a generic package that can be used by all the extensibility projects

AUTHID CURRENT_USER

Dependencies

DBMS_METADATA	ODCIINDEXINFO	ODCI_OBJ_LIB
DBMS_STANDARD	ODCI_EXTOPT_LIB	ORA_FI_T
DUAL	ODCI_INDEX_LIB	SEM_INDEXTYPE_IM

Documented Yes: Packages and Types Reference

First Available 9.0

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/catodci.sql

Subprograms

CLEANUP	GETMETADATA	RESTOREREFCURSOR
ESTIMATE_CPU_UNITS	GETTABLENAMES	SAVEREFCURSOR

CLEANUP

Undocumented dbms_odci.estimate_cleanup( ia IN SYS.ODCIIndexInfo, gtn_context IN NUMBER);

TBD

ESTIMATE_CPU_UNITS

Estimate instructions per second used in the specified time cycle in milliseconds dbms_odci.estimate_cpu_units(elapsed_time IN NUMBER) RETURN NUMBER;

SELECT dbms_odci.estimate_cpu_units(1) * 1000

      FROM dual;

      

      DBMS_ODCI.ESTIMATE_CPU_UNITS(1)*1000

      ------------------------------------

                          
      1944050382

GETMETADATA

Undocumented dbms_odci.getmetadata( ia IN SYS.ODCIIndexInfo, exp_version IN VARCHAR2, idx_version IN NUMBER DEFAULT 1, stmt_string OUT VARCHAR2, new_block OUT NUMBER);

TBD

GETTABLENAMES

Undocumented dbms_odci.gettablenames( ia IN SYS.ODCIIndexInfo, read_only IN NUMBER, exp_version IN VARCHAR2, idx_version IN NUMBER, stmt_string OUT VARCHAR2, gtn_context OUT NUMBER, status OUT NUMBER);

TBD

RESTOREREFCURSOR

Undocumented PROCEDURE RestoreRefCursor(rc OUT SYS_REFCURSOR, curnum IN NUMBER) IS LANGUAGE C LIBRARY odci_extopt_lib NAME "RestoreRefCursor" WITH CONTEXT PARAMETERS (CONTEXT, rc, curnum OCINumber, curnum INDICATOR);

TBD

SAVEREFCURSOR

Undocumented dbms_odci.SaveRefCursor(rc IN SYS_REFCURSOR, curnum OUT NUMBER) IS LANGUAGE C LIBRARY odci_extopt_lib NAME "SaveRefCursor" WITH CONTEXT PARAMETERS (CONTEXT, rc, curnum OCINumber, curnum INDICATOR);

TBD