[Home] [Help]
PACKAGE: SYS.ODCICONST
Source
1 PACKAGE ODCIConst IS
2
3 pragma restrict_references(ODCIConst, WNDS, RNDS, WNPS, RNPS);
4
5 -- Constants for Return Status
6 Success CONSTANT INTEGER := 0;
7 Error CONSTANT INTEGER := 1;
8 Warning CONSTANT INTEGER := 2;
9 ErrContinue CONSTANT INTEGER := 3;
10 Fatal CONSTANT INTEGER := 4;
11
12 -- Constants for ODCIPredInfo.Flags
13 PredExactMatch CONSTANT INTEGER := 1;
14 PredPrefixMatch CONSTANT INTEGER := 2;
15 PredIncludeStart CONSTANT INTEGER := 4;
16 PredIncludeStop CONSTANT INTEGER := 8;
17 PredObjectFunc CONSTANT INTEGER := 16;
18 PredObjectPkg CONSTANT INTEGER := 32;
19 PredObjectType CONSTANT INTEGER := 64;
20 PredMultiTable CONSTANT INTEGER := 128;
21 PredNotEqual CONSTANT INTEGER := 256;
22
23 -- Constants for ODCIQueryInfo.Flags
24 QueryFirstRows CONSTANT INTEGER := 1;
25 QueryAllRows CONSTANT INTEGER := 2;
26 QuerySortAsc CONSTANT INTEGER := 4;
27 QuerySortDesc CONSTANT INTEGER := 8;
28 QueryBlocking CONSTANT INTEGER := 16;
29
30 -- Constants for ScnFlg(Func /w Index Context)
31 CleanupCall CONSTANT INTEGER := 1;
32 RegularCall CONSTANT INTEGER := 2;
33
34 -- Constants for ODCIFuncInfo.Flags
35 ObjectFunc CONSTANT INTEGER := 1;
36 ObjectPkg CONSTANT INTEGER := 2;
37 ObjectType CONSTANT INTEGER := 4;
38
39 -- Constants for ODCIArgDesc.ArgType
40 ArgOther CONSTANT INTEGER := 1;
41 ArgCol CONSTANT INTEGER := 2;
42 ArgLit CONSTANT INTEGER := 3;
43 ArgAttr CONSTANT INTEGER := 4;
44 ArgNull CONSTANT INTEGER := 5;
45 ArgCursor CONSTANT INTEGER := 6;
46
47 -- Constants for ODCIStatsOptions.Options
48 PercentOption CONSTANT INTEGER := 1;
49 RowOption CONSTANT INTEGER := 2;
50
51 -- Constants for ODCIStatsOptions.Flags
52 EstimateStats CONSTANT INTEGER := 1;
53 ComputeStats CONSTANT INTEGER := 2;
54 Validate CONSTANT INTEGER := 4;
55
56 -- Constants for ODCIIndexAlter parameter alter_option
57 AlterIndexNone CONSTANT INTEGER := 0;
58 AlterIndexRename CONSTANT INTEGER := 1;
59 AlterIndexRebuild CONSTANT INTEGER := 2;
60 AlterIndexRebuildOnline CONSTANT INTEGER := 3;
61 AlterIndexModifyCol CONSTANT INTEGER := 4;
62 AlterIndexUpdBlockRefs CONSTANT INTEGER := 5;
63 AlterIndexRenameCol CONSTANT INTEGER := 6;
64 AlterIndexRenameTab CONSTANT INTEGER := 7;
65 AlterIndexMigrate CONSTANT INTEGER := 8;
66
67 -- Constants for ODCIIndexInfo.IndexInfoFlags
68 Local CONSTANT INTEGER := 1;
69 RangePartn CONSTANT INTEGER := 2;
70 HashPartn CONSTANT INTEGER := 4;
71 Online CONSTANT INTEGER := 8;
72 Parallel CONSTANT INTEGER := 16;
73 Unusable CONSTANT INTEGER := 32;
74 IndexOnIOT CONSTANT INTEGER := 64;
75 TransTblspc CONSTANT INTEGER := 128;
76 FunctionIdx CONSTANT INTEGER := 256;
77 ListPartn CONSTANT INTEGER := 512;
78 UpdateGlobalIndexes CONSTANT INTEGER := 1024;
79
80 -- Constants for ODCIIndexInfo.IndexParaDegree
81 DefaultDegree CONSTANT INTEGER := 32767;
82
83 -- Constants for ODCIEnv.Envflags
84 DebuggingOn CONSTANT INTEGER := 1;
85 NoData CONSTANT INTEGER := 2;
86 UserParamString CONSTANT INTEGER := 4;
87 RowMigration CONSTANT INTEGER := 8;
88 IndexKeyChanged CONSTANT INTEGER := 16;
89
90 -- Constants for ODCIEnv.CallProperty
91 None CONSTANT INTEGER := 0;
92 FirstCall CONSTANT INTEGER := 1;
93 IntermediateCall CONSTANT INTEGER := 2;
94 FinalCall CONSTANT INTEGER := 3;
95 RebuildIndex CONSTANT INTEGER := 4;
96 RebuildPMO CONSTANT INTEGER := 5;
97 StatsGlobal CONSTANT INTEGER := 6;
98 StatsGlobalAndPartition CONSTANT INTEGER := 7;
99 StatsPartition CONSTANT INTEGER := 8;
100
101 -- NOTE: the following ODCIExtTable related definitions should
102 -- not be documented (internal use only).
103 -- Constants for ODCIExtTableInfo.OpCode
104 FetchOp CONSTANT INTEGER := 1;
105 PopulateOp CONSTANT INTEGER := 2;
106
107 -- Constants for ODCIExtTableInfo.Flag
108 Sample CONSTANT INTEGER := 1;
109 SampleBlock CONSTANT INTEGER := 2;
110
111 -- Constants for ODCIExtTableQCInfo.IntraSourceConcurrency (OUT) argument
112 True CONSTANT INTEGER := 1;
113 False CONSTANT INTEGER := 0;
114
115 -- Constants (bit definitions) for 'flag' (IN) argument to ODCIExtTableOpen
116 QueryCoordinator CONSTANT INTEGER := 1;
117 Shadow CONSTANT INTEGER := 2;
118 Slave CONSTANT INTEGER := 4;
119
120 -- Constants (bit definitons) for ODCIExtTableFetch 'flag' OUT argument
121 FetchEOS CONSTANT INTEGER := 1;
122
123 -- Constants (bit definitions) for ODCIColInfo.Flags
124 CompFilterByCol CONSTANT INTEGER := 1;
125 CompOrderByCol CONSTANT INTEGER := 2;
126 CompOrderDscCol CONSTANT INTEGER := 4;
127 CompUpdatedCol CONSTANT INTEGER := 8;
128 CompRenamedCol CONSTANT INTEGER := 16;
129 CompRenamedTopADT CONSTANT INTEGER := 32;
130
131 -- Constants for ODCIOrderByInfo.ExprType
132 ColumnExpr CONSTANT INTEGER := 1;
133 AncOpExpr CONSTANT INTEGER := 2;
134
135 -- Constants for ODCIOrderByInfo.SortOrder
136 SortAsc CONSTANT INTEGER := 1;
137 SortDesc CONSTANT INTEGER := 2;
138 NullsFirst CONSTANT INTEGER := 4;
139
140
141 -- Constants for ODCIPartInfo.PartOpt
142 AddPartition CONSTANT INTEGER := 1;
143 DropPartition CONSTANT INTEGER := 2;
144
145 END ODCIConst;