ocilib_8h-source.html

ORACLE编程的好东西,纯C写的OCI封装.很好用,支持数据池.

<a name="l01151"></a>01151 <span class="preprocessor"></span><span class="preprocessor">#define OCI_ARG_BIGUINT         6        </span>
<a name="l01152"></a>01152 <span class="preprocessor"></span><span class="preprocessor">#define OCI_ARG_DOUBLE          7        </span>
<a name="l01153"></a>01153 <span class="preprocessor"></span><span class="preprocessor">#define OCI_ARG_DATETIME        8        </span>
<a name="l01154"></a>01154 <span class="preprocessor"></span><span class="preprocessor">#define OCI_ARG_TEXT            9        </span>
<a name="l01155"></a>01155 <span class="preprocessor"></span><span class="preprocessor">#define OCI_ARG_LOB             10    </span>
<a name="l01156"></a>01156 <span class="preprocessor"></span><span class="preprocessor">#define OCI_ARG_FILE            11</span>
<a name="l01157"></a>01157 <span class="preprocessor"></span><span class="preprocessor">#define OCI_ARG_TIMESTAMP       12</span>
<a name="l01158"></a>01158 <span class="preprocessor"></span><span class="preprocessor">#define OCI_ARG_INTERVAL        13</span>
<a name="l01159"></a>01159 <span class="preprocessor"></span><span class="preprocessor">#define OCI_ARG_RAW             14</span>
<a name="l01160"></a>01160 <span class="preprocessor"></span>
<a name="l01161"></a>01161 <span class="comment">/* statement types */</span>
<a name="l01162"></a>01162 
<a name="l01163"></a>01163 <span class="preprocessor">#define OCI_CST_SELECT          1                        </span>
<a name="l01164"></a>01164 <span class="preprocessor"></span><span class="preprocessor">#define OCI_CST_UPDATE          2                           </span>
<a name="l01165"></a>01165 <span class="preprocessor"></span><span class="preprocessor">#define OCI_CST_DELETE          3                              </span>
<a name="l01166"></a>01166 <span class="preprocessor"></span><span class="preprocessor">#define OCI_CST_INSERT          4                             </span>
<a name="l01167"></a>01167 <span class="preprocessor"></span><span class="preprocessor">#define OCI_CST_CREATE          5                             </span>
<a name="l01168"></a>01168 <span class="preprocessor"></span><span class="preprocessor">#define OCI_CST_DROP            6                              </span>
<a name="l01169"></a>01169 <span class="preprocessor"></span><span class="preprocessor">#define OCI_CST_ALTER           7                              </span>
<a name="l01170"></a>01170 <span class="preprocessor"></span><span class="preprocessor">#define OCI_CST_BEGIN           8                   </span>
<a name="l01171"></a>01171 <span class="preprocessor"></span><span class="preprocessor">#define OCI_CST_DECLARE         9        </span>
<a name="l01172"></a>01172 <span class="preprocessor"></span>
<a name="l01173"></a>01173 <span class="comment">/* environnement modes */</span>
<a name="l01174"></a>01174 
<a name="l01175"></a>01175 <span class="preprocessor">#define OCI_ENV_DEFAULT         0</span>
<a name="l01176"></a>01176 <span class="preprocessor"></span><span class="preprocessor">#define OCI_ENV_THREADED        1</span>
<a name="l01177"></a>01177 <span class="preprocessor"></span><span class="preprocessor">#define OCI_ENV_CONTEXT         2</span>
<a name="l01178"></a>01178 <span class="preprocessor"></span>
<a name="l01179"></a>01179     <span class="comment">/* sessions modes */</span>
<a name="l01180"></a>01180 
<a name="l01181"></a>01181 <span class="preprocessor">#define OCI_SESSION_DEFAULT     0</span>
<a name="l01182"></a>01182 <span class="preprocessor"></span><span class="preprocessor">#define OCI_SESSION_SYSDBA      2</span>
<a name="l01183"></a>01183 <span class="preprocessor"></span><span class="preprocessor">#define OCI_SESSION_SYSOPER     4</span>
<a name="l01184"></a>01184 <span class="preprocessor"></span>
<a name="l01185"></a>01185 <span class="comment">/* charsetform types */</span>
<a name="l01186"></a>01186 
<a name="l01187"></a>01187 <span class="preprocessor">#define OCI_CSF_NONE            0</span>
<a name="l01188"></a>01188 <span class="preprocessor"></span><span class="preprocessor">#define OCI_CSF_CHARSET         1</span>
<a name="l01189"></a>01189 <span class="preprocessor"></span><span class="preprocessor">#define OCI_CSF_NATIONAL        2</span>
<a name="l01190"></a>01190 <span class="preprocessor"></span>
<a name="l01191"></a>01191 <span class="comment">/* statement fetch mode */</span>
<a name="l01192"></a>01192 
<a name="l01193"></a>01193 <span class="preprocessor">#define OCI_SFM_DEFAULT         0</span>
<a name="l01194"></a>01194 <span class="preprocessor"></span><span class="preprocessor">#define OCI_SFM_SCROLLABLE      0x08</span>
<a name="l01195"></a>01195 <span class="preprocessor"></span>
<a name="l01196"></a>01196 <span class="comment">/* statement fetch direction */</span>
<a name="l01197"></a>01197 
<a name="l01198"></a>01198 <span class="preprocessor">#define OCI_SFD_ABSOLUTE        0x20</span>
<a name="l01199"></a>01199 <span class="preprocessor"></span><span class="preprocessor">#define OCI_SFD_RELATIVE        0x40</span>
<a name="l01200"></a>01200 <span class="preprocessor"></span>
<a name="l01201"></a>01201 <span class="comment">/* timestamp types */</span>
<a name="l01202"></a>01202 
<a name="l01203"></a>01203 <span class="preprocessor">#define OCI_TIMESTAMP           1</span>
<a name="l01204"></a>01204 <span class="preprocessor"></span><span class="preprocessor">#define OCI_TIMESTAMP_TZ        2</span>
<a name="l01205"></a>01205 <span class="preprocessor"></span><span class="preprocessor">#define OCI_TIMESTAMP_LTZ       3</span>
<a name="l01206"></a>01206 <span class="preprocessor"></span>
<a name="l01207"></a>01207 <span class="comment">/* interval types */</span>
<a name="l01208"></a>01208 
<a name="l01209"></a>01209 <span class="preprocessor">#define OCI_INTERVAL_YM         1</span>
<a name="l01210"></a>01210 <span class="preprocessor"></span><span class="preprocessor">#define OCI_INTERVAL_DS         2</span>
<a name="l01211"></a>01211 <span class="preprocessor"></span>
<a name="l01212"></a>01212 <span class="comment">/* long types */</span>
<a name="l01213"></a>01213 
<a name="l01214"></a>01214 <span class="preprocessor">#define OCI_BLONG               1</span>
<a name="l01215"></a>01215 <span class="preprocessor"></span><span class="preprocessor">#define OCI_CLONG               2</span>
<a name="l01216"></a>01216 <span class="preprocessor"></span>
<a name="l01217"></a>01217 <span class="comment">/* lLob types */</span>
<a name="l01218"></a>01218 
<a name="l01219"></a>01219 <span class="preprocessor">#define OCI_BLOB                1</span>
<a name="l01220"></a>01220 <span class="preprocessor"></span><span class="preprocessor">#define OCI_CLOB                2</span>
<a name="l01221"></a>01221 <span class="preprocessor"></span><span class="preprocessor">#define OCI_NCLOB               3</span>
<a name="l01222"></a>01222 <span class="preprocessor"></span>
<a name="l01223"></a>01223 <span class="comment">/* lob opening mode */</span>
<a name="l01224"></a>01224 
<a name="l01225"></a>01225 <span class="preprocessor">#define OCI_LOB_READONLY        1  </span>
<a name="l01226"></a>01226 <span class="preprocessor"></span><span class="preprocessor">#define OCI_LOB_READWRITE       2 </span>
<a name="l01227"></a>01227 <span class="preprocessor"></span>
<a name="l01228"></a>01228 <span class="comment">/* file types */</span>
<a name="l01229"></a>01229 
<a name="l01230"></a>01230 <span class="preprocessor">#define OCI_BFILE               1</span>
<a name="l01231"></a>01231 <span class="preprocessor"></span><span class="preprocessor">#define OCI_CFILE               2</span>
<a name="l01232"></a>01232 <span class="preprocessor"></span>
<a name="l01233"></a>01233 <span class="comment">/* lob browing mode */</span>
<a name="l01234"></a>01234 
<a name="l01235"></a>01235 <span class="preprocessor">#define OCI_SEEK_SET            1</span>
<a name="l01236"></a>01236 <span class="preprocessor"></span><span class="preprocessor">#define OCI_SEEK_END            2</span>
<a name="l01237"></a>01237 <span class="preprocessor"></span><span class="preprocessor">#define OCI_SEEK_CUR            3</span>
<a name="l01238"></a>01238 <span class="preprocessor"></span>
<a name="l01239"></a>01239 <span class="comment">/* schema types */</span>
<a name="l01240"></a>01240 
<a name="l01241"></a>01241 <span class="preprocessor">#define OCI_SCHEMA_TABLE        1</span>
<a name="l01242"></a>01242 <span class="preprocessor"></span><span class="preprocessor">#define OCI_SCHEMA_VIEW         2</span>
<a name="l01243"></a>01243 <span class="preprocessor"></span><span class="preprocessor">#define OCI_SCHEMA_TYPE         3</span>
<a name="l01244"></a>01244 <span class="preprocessor"></span>
<a name="l01245"></a>01245 <span class="comment">/* Collection types */</span>
<a name="l01246"></a>01246 
<a name="l01247"></a>01247 <span class="preprocessor">#define OCI_COLL_VARRAY         1</span>
<a name="l01248"></a>01248 <span class="preprocessor"></span><span class="preprocessor">#define OCI_COLL_NESTED_TABLE   2</span>
<a name="l01249"></a>01249 <span class="preprocessor"></span>
<a name="l01250"></a>01250 <span class="comment">/* size constants */</span>
<a name="l01251"></a>01251 
<a name="l01252"></a>01252 <span class="preprocessor">#define OCI_SIZE_FORMAT         64</span>
<a name="l01253"></a>01253 <span class="preprocessor"></span><span class="preprocessor">#define OCI_SIZE_BUFFER         512</span>
<a name="l01254"></a>01254 <span class="preprocessor"></span><span class="preprocessor">#define OCI_SIZE_LONG           (64*1024)-1</span>
<a name="l01255"></a>01255 <span class="preprocessor"></span><span class="preprocessor">#define OCI_SIZE_DATE           44</span>
<a name="l01256"></a>01256 <span class="preprocessor"></span><span class="preprocessor">#define OCI_SIZE_TIMESTAMP      60</span>
<a name="l01257"></a>01257 <span class="preprocessor"></span><span class="preprocessor">#define OCI_SIZE_FORMAT_TODATE  14</span>
<a name="l01258"></a>01258 <span class="preprocessor"></span><span class="preprocessor">#define OCI_SIZE_NULL           4 </span>
<a name="l01259"></a>01259 <span class="preprocessor"></span><span class="preprocessor">#define OCI_SIZE_PRECISION      10</span>
<a name="l01260"></a>01260 <span class="preprocessor"></span><span class="preprocessor">#define OCI_SIZE_ROWID          23</span>
<a name="l01261"></a>01261 <span class="preprocessor"></span><span class="preprocessor">#define OCI_SIZE_DIRECTORY      30</span>
<a name="l01262"></a>01262 <span class="preprocessor"></span><span class="preprocessor">#define OCI_SIZE_FILENAME       255</span>
<a name="l01263"></a>01263 <span class="preprocessor"></span><span class="preprocessor">#define OCI_SIZE_FORMAT_NUMS    40</span>
<a name="l01264"></a>01264 <span class="preprocessor"></span><span class="preprocessor">#define OCI_SIZE_FORMAT_NUML    65</span>
<a name="l01265"></a>01265 <span class="preprocessor"></span>
<a name="l01266"></a>01266 <span class="comment">/* hash tables support */</span>
<a name="l01267"></a>01267 
<a name="l01268"></a>01268 <span class="preprocessor">#define OCI_HASH_STRING         1</span>
<a name="l01269"></a>01269 <span class="preprocessor"></span><span class="preprocessor">#define OCI_HASH_INTEGER        2</span>
<a name="l01270"></a>01270 <span class="preprocessor"></span><span class="preprocessor">#define OCI_HASH_POINTER        3</span>
<a name="l01271"></a>01271 <span class="preprocessor"></span>
<a name="l01272"></a>01272 <span class="preprocessor">#define OCI_HASH_DEFAULT_SIZE   256</span>
<a na