sqlora_8h-source.html

Linux下的操作oracle数据库的连接库

00248   <a class="code" href="group__constants.html#gga6a79">SQLOT_NTY</a>  = 108,                                 
00249   <a class="code" href="group__constants.html#gga6a80">SQLOT_REF</a>  = 110,                                          
00250   <a class="code" href="group__constants.html#gga6a81">SQLOT_CLOB</a> = 112,                                     
00251   <a class="code" href="group__constants.html#gga6a82">SQLOT_BLOB</a> = 113,                                        
00252   <a class="code" href="group__constants.html#gga6a83">SQLOT_BFILEE</a> = 114,                                 
00253   <a class="code" href="group__constants.html#gga6a84">SQLOT_CFILEE</a> = 115,                              
00254   <a class="code" href="group__constants.html#gga6a85">SQLOT_RSET</a> = 116,                                   
00255   <a class="code" href="group__constants.html#gga6a86">SQLOT_NCO</a>  = 122,    
00256   <a class="code" href="group__constants.html#gga6a87">SQLOT_VST</a>  = 155,                                    
00257   <a class="code" href="group__constants.html#gga6a88">SQLOT_ODT</a>  = 156,                                      
00259 <span class="comment">/* datetimes and intervals */</span>
00260   <a class="code" href="group__constants.html#gga6a89">SQLOT_DATE</a>                   = 184,                      
00261   <a class="code" href="group__constants.html#gga6a90">SQLOT_TIME</a>                   = 185,                           
00262   <a class="code" href="group__constants.html#gga6a91">SQLOT_TIME_TZ</a>                = 186,            
00263   <a class="code" href="group__constants.html#gga6a92">SQLOT_TIMESTAMP</a>              = 187,                      
00264   <a class="code" href="group__constants.html#gga6a93">SQLOT_TIMESTAMP_TZ</a>           = 188,       
00265   <a class="code" href="group__constants.html#gga6a94">SQLOT_INTERVAL_YM</a>            = 189,         
00266   <a class="code" href="group__constants.html#gga6a95">SQLOT_INTERVAL_DS</a>            = 190,         
00267   <a class="code" href="group__constants.html#gga6a96">SQLOT_TIMESTAMP_LTZ</a>          = 232         
00268 };
00269 
00270 
00271 
00272 <span class="comment">/* cxcheng: this has been added for backward compatibility -</span>
00273 <span class="comment">   it needs to be here because ocidfn.h can get included ahead of sqldef.h */</span>
00274 <span class="preprocessor">#define SQLOT_FILE SQLOT_BFILEE                              </span><span class="comment">/* binary file lob */</span>
00275 <span class="preprocessor">#define SQLOT_CFILE SQLOT_CFILEE</span>
00276 <span class="preprocessor"></span><span class="preprocessor">#define SQLOT_BFILE SQLOT_BFILEE</span>
00277 <span class="preprocessor"></span>
00278 
00279 
00284 <span class="keyword">enum</span> <a class="code" href="group__constants.html#ga7">sqlo_statement_states</a> {
00285   <a class="code" href="group__constants.html#gga7a97">SQLO_STMT_STATE_INITIALIZED</a> = 1, 
00286   <a class="code" href="group__constants.html#gga7a98">SQLO_STMT_STATE_EXECUTED</a>    = 2, 
<a name="l00287"></a><a class="code" href="group__constants.html#ga7">00287</a>   <a class="code" href="group__constants.html#gga7a99">SQLO_STMT_STATE_END_OF_FETCH</a> = 3 
00288 };
00289 
00290 
00291 
00306 <span class="keyword">typedef</span> <span class="keywordtype">int</span> <a class="code" href="group__typedefs.html#ga0">sqlo_db_handle_t</a>;
00307 
00308 
<a name="l00309"></a><a class="code" href="group__typedefs.html#ga0">00309</a> 
00315 <span class="keyword">typedef</span> <span class="keywordtype">int</span> <a class="code" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a>;
00316 
00317 
<a name="l00318"></a><a class="code" href="group__typedefs.html#ga1">00318</a> 
00322 <span class="keyword">typedef</span> <span class="keyword">enum</span> {
00323   <a class="code" href="group__typedefs.html#gga4a100">SQLO_OCI_HTYPE_ENV</a>     = 1,   
00324   <a class="code" href="group__typedefs.html#gga4a101">SQLO_OCI_HTYPE_ERROR</a>   = 2,   
<a name="l00325"></a><a class="code" href="group__typedefs.html#ga4">00325</a>   <a class="code" href="group__typedefs.html#gga4a102">SQLO_OCI_HTYPE_SVCCTX</a>  = 3,   
00326   <a class="code" href="group__typedefs.html#gga4a103">SQLO_OCI_HTYPE_SERVER</a>  = 4,   
00327   <a class="code" href="group__typedefs.html#gga4a104">SQLO_OCI_HTYPE_SESSION</a> = 5,   
00328   <a class="code" href="group__typedefs.html#gga4a105">SQLO_OCI_HTYPE_STMT</a>    = 6    
00329 } <a class="code" href="group__typedefs.html#ga4">sqlo_oci_handle_types_e</a>;
00330 
00331 
00332 
00338 <span class="keyword">typedef</span> <span class="keywordtype">void</span> * <a class="code" href="group__typedefs.html#ga2">sqlo_lob_desc_t</a>;
00339 
00340 
<a name="l00341"></a><a class="code" href="group__typedefs.html#ga2">00341</a> 
00345 <span class="keyword">typedef</span> void (*<a class="code" href="group__typedefs.html#ga3">sqlo_signal_handler_t</a>) __P((<span class="keywordtype">void</span>));
00346 
00347 
<a name="l00348"></a><a class="code" href="group__typedefs.html#ga3">00348</a> 
00353 <span class="comment">/*-------------------------------------------------------------------------</span>
00354 <span class="comment"> * Version Information</span>
00355 <span class="comment"> *-----------------------------------------------------------------------*/</span>
00356 
00368 <span class="keyword">extern</span> CONST <span class="keywordtype">unsigned</span> <a class="code" href="group__exvars.html#ga0">sqlo_major_version</a>;
00369 
00370 
<a name="l00371"></a><a class="code" href="group__exvars.html#ga1">00371</a> 
00376 <span class="keyword">extern</span> CONST <span class="keywordtype">unsigned</span> <a class="code" href="group__exvars.html#ga2">sqlo_minor_version</a>;
00377 
00378 
<a name="l00379"></a><a class="code" href="group__exvars.html#ga3">00379</a> 
00384 <span class="keyword">extern</span> CONST <span class="keywordtype">unsigned</span> <a class="code" href="group__exvars.html#ga4">sqlo_micro_version</a>;
00385 
00386 
<a name="l00387"></a><a class="code" href="group__exvars.html#ga5">00387</a> 
00392 <span class="keyword">extern</span> CONST <span class="keywordtype">unsigned</span> <a class="code" href="group__exvars.html#ga6">sqlo_interface_age</a>;
00393 
00394 
<a name="l00395"></a><a class="code" href="group__exvars.html#ga7">00395</a> 
00400 <span class="keyword">extern</span> CONST <span class="keywordtype">unsigned</span> <a class="code" href="group__exvars.html#ga8">sqlo_binary_age</a>;
00401 
00402 <span class="comment">/* to keep backward compatibility with &lt;= 2.2, otherwise we break too much */</span>
<a name="l00403"></a><a class="code" href="group__exvars.html#ga9">00403</a> <span class="keyword">extern</span> CONST <span class="keywordtype">unsigned</span> sqlora8_major_version;
00404 <span class="keyword">extern</span> CONST <span class="keywordtype">unsigned</span> sqlora8_minor_version;
00405 <span class="keyword">extern</span> CONST <span class="keywordtype">unsigned</span> sqlora8_micro_version;
00406 <span class="keyword">extern</span> CONST <span class="keywordtype">unsigned</span> sqlora8_interface_age;
00407 <span class="keyword">extern</span> CONST <span class="keywordtype">unsigned</span> sqlora8_binary_age;
00408 
00409 <span class="preprocessor">#define SQLORA8_MAJOR_VERSION LIBSQLORA8_MAJOR_VERSION</span>
00410 <span class="preprocessor"></span><span class="preprocessor">#define SQLORA8_MINOR_VERSION LIBSQLORA8_MINOR_VERSION</span>
00411 <span class="preprocessor"></span><span class="preprocessor">#define SQLORA8_MICRO_VERSION LIBSQLORA8_MICRO_VERSION</span>
00412 <span class="preprocessor"></span>
00413 
00414 
00415 <span class="comment">/* @} */</span>
00416 
00417 
00418 
00425 <span class="preprocessor">#define SQLORA8_CHECK_VERSION(major,minor,micro)    \</span>
00426 <span class="preprocessor">    (LIBSQLORA8_MAJOR_VERSION &gt; (major) || \</span>
00427 <span class="preprocessor">     (LIBSQLORA8_MAJOR_VERSION == (major) &amp;&amp; LIBSQLORA8_MINOR_VERSION &gt; (minor)) || \</span>
<a name="l00428"></a><a class="code" href="sqlora_8h.html#a10">00428</a> <span class="preprocessor">     (LIBSQLORA8_MAJOR_VERSION == (major) &amp;&amp; LIBSQLORA8_MINOR_VERSION == (minor) &amp;&amp; \</span>
00429 <span class="preprocessor">      LIBSQLORA8_MICRO_VERSION &gt;= (micro)))</span>
00430 <span class="preprocessor"></span>
00431 
00432 
00433 <span class="comment">/*-------------------------------------------------------------------------</span>
00434 <span class="comment"> * FUNCTION DECLARATIONS</span>
00435 <span class="comment"> *-----------------------------------------------------------------------*/</span>
00436 __BEGIN_DECLS
00437 
00464 <span class="keywordtype">int</span> sqlo_init __P((<span class="keywordtype">int</span> threaded_mode, <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> max_db, <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> max_cursors));
00465 
00466 
00467 
00482 <span class="keywordtype">int</span> <a class="code" href="group__init.html#ga201">sqlo_version</a> __P((CONST <span class="keywordtype">char</span> * version_str));
00483 
00502 CONST <span class="keywordtype">char</span> * <a class="code" href="group__error.html#ga158">sqlo_geterror</a> __P(( sqlo_db_handle_t dbh ));
00503 
00504 
00505 
00513 <span class="keywordtype">int</span> <a class="code" href="group__error.html#ga159">sqlo_geterrcode</a> __P(( sqlo_db_handle_t dbh ));
00514 
00547 <span class="keywordtype">int</span> <a class="code" href="group__easy.html#ga160">sqlo_exists</a> __P(( sqlo_db_handle_t dbh, 
00548                       CONST <span class="keywordtype">char</span> * table, 
00549                       CONST <span class="keywordtype">char</span> * colname,
00550                       CONST <span class="keywordtype">char</span> * colval, 
00551                       CONST <span class="keywordtype">char</span> * where ));
00552 
00553 
00554 
00574 <span class="keywordtype">int</span> <a class="code" href="group__easy.html#ga161">sqlo_count</a> __P((sqlo_db_handle_t dbh,
00575                     CONST <span class="keywordtype">char</span> * table,
00576                     CONST <span class="keywordtype">char</span> * colname,
00577                     CONST <span class="keywordtype">char</span> * colval,
00578                     CONST <span class="keywordtype">char</span> * where ));
00579 
00580 
00581 
00602 <span class="keywordtype">int</span> <a class="code" href="group__easy.html#ga162">sqlo_run</a> __P(( sqlo_db_handle_t dbh, CONST <span class="keywordtype">char</span> * stmt, <span class="keywordtype">int</span> argc, CONST <span class="keywordtype">char</span> ** argv));
00603 
00604 
00605 
00632 <a class="code" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> <a class="code" href="group__easy.html#ga164">sqlo_open</a> __P((sqlo_db_handle_t dbh, 
00633                                   CONST <span class="keywordtype">char</span> * stmt, 
00634                                   <span class="keywordtype">int</span> argc, 
00635                                   CONST <span class="keywordtype">char</span> ** argv));
00636 
00637 
00638 
00672 <span class="keywordtype">int</span> <a class="code" href="group__easy.html#ga165">sqlo_open2</a> __P((sqlo_stmt_handle_t * sthp, 
00673                     sqlo_db_handle_t dbh, 
00674                     CONST <span class="keywordtype">char</span> * stmt, 
00675                     <span class="keywordtype">int</span> argc, 
00676                     CONST <span class="keywordtype">char</span> ** argv));
00677 
00678 
00679 
00701 <span class="keywordtype">int</span> <a class="code" href="group__easy.html#ga166">sqlo_reopen</a> __P((sqlo_stmt_handle_t sth, 
00702                      <span class="keywordtype">int</span> argc, 
00703                      CONST <span class="keywordtype">char</span> ** argv));
00704 
00705 
00706 
00728 <span class="keywordtype">int</span> <a class="code" href="group__easy.html#ga167">sqlo_fetch</a> __P((sqlo_stmt_handle_t sth, <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> nrows));
00729 
00730