Oracle DBMS_ODCI
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 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
First Available 9.0
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/catodci.sql
Subprograms
 
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

Related Topics
Built-in Functions
Built-in Packages
Extensible Optimizer
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