Oracle DBMS_ODCI
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,
Purpose This is a generic package that can be used by all the extensibility projects
AUTHID DEFINER
Dependencies
DBMS_ASSERT DBMS_SYS_SQL ODCISECOBJTABLE
DBMS_I_INDEX_UTL IND$ ODCI_EXTOPT_LIB
DBMS_METADATA OBJ$ PLITBLM
DBMS_SQL ODCIINDEXINFO SECOBJ$
DBMS_STANDARD ODCISECOBJ USER$
Documented Yes
First Available 9.0.1
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;
 
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
 
UPGRADE_SECOBJ
Undocumented dbms_odci.upgrade_secobj(objlist IN ODCISecObjTable);
TBD

Related Topics
Extensible Optimizer
Packages

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