1 PACKAGE DBMS_ODCI AS
2 -- Overview
3 -- This is a generic package that can be used by all the extensibility
4 -- projects. This package is owned by SYS and is granted to PUBLIC
5
6 -- This function is used to help users estimate the number of CPU cycles
7 -- that have been used in a certain time interval.
8 FUNCTION estimate_cpu_units(elapsed_time IN NUMBER)
9 RETURN NUMBER;
10
11 -- This procedure is used to maintain secobj$ during upgrade
12 PROCEDURE upgrade_secobj(objlist ODCISecObjTable);
13
14 PROCEDURE SaveRefCursor(rc IN SYS_REFCURSOR, curnum OUT NUMBER)
15 IS LANGUAGE C
16 LIBRARY odci_extopt_lib
17 NAME "SaveRefCursor"
18 WITH CONTEXT
19 PARAMETERS
20 (
21 CONTEXT,
22 rc,
23 curnum OCINumber,
24 curnum INDICATOR
25 );
26
27 PROCEDURE RestoreRefCursor(rc OUT SYS_REFCURSOR, curnum IN NUMBER)
28 IS LANGUAGE C
29 LIBRARY odci_extopt_lib
30 NAME "RestoreRefCursor"
31 WITH CONTEXT
32 PARAMETERS
33 (
34 CONTEXT,
35 rc,
36 curnum OCINumber,
37 curnum INDICATOR
38 );
39
40 PROCEDURE GetMetadata(ia IN SYS.ODCIIndexInfo, exp_version IN VARCHAR2,
41 idx_version IN NUMBER default 1, stmt_string OUT VARCHAR2,
42 new_block OUT NUMBER);
43
44 PROCEDURE GetTableNames(ia IN SYS.ODCIIndexInfo, read_only IN NUMBER,
45 exp_version IN VARCHAR2, idx_version IN NUMBER, stmt_string OUT VARCHAR2,
46 gtn_context OUT NUMBER, status OUT NUMBER);
47
48 PROCEDURE Cleanup(ia IN SYS.ODCIIndexInfo, gtn_context IN NUMBER);
49
50 END DBMS_ODCI;