ocilib__types_8h-source.html

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

<a name="l00355"></a>00355     ub4              nb_defs;       <span class="comment">/* number of elements */</span>
<a name="l00356"></a>00356     ub4              row_cur;       <span class="comment">/* actual position in the array of rows */</span>
<a name="l00357"></a>00357     ub4              row_abs;       <span class="comment">/* absolute position in the resulset */</span>
<a name="l00358"></a>00358     ub4              row_count;     <span class="comment">/* number of rows fetched so far */</span>
<a name="l00359"></a>00359     ub4              row_fetched;   <span class="comment">/* rows fetched by last call (scrollable) */</span>
<a name="l00360"></a>00360     <span class="keywordtype">boolean</span>          eof;           <span class="comment">/* end of resultset reached ?  */</span>
<a name="l00361"></a>00361     <span class="keywordtype">boolean</span>          bof;           <span class="comment">/* beginning of resultset reached ?  */</span>
<a name="l00362"></a>00362     ub4              fetch_size;    <span class="comment">/* internal array size */</span>
<a name="l00363"></a>00363     sword            fetch_status;  <span class="comment">/* internal fetch status */</span>
<a name="l00364"></a>00364 
<a name="l00365"></a>00365 };
<a name="l00366"></a>00366 
<a name="l00367"></a>00367 <span class="comment">/*</span>
<a name="l00368"></a>00368 <span class="comment"> * Statement object </span>
<a name="l00369"></a>00369 <span class="comment"> *</span>
<a name="l00370"></a>00370 <span class="comment"> */</span>
<a name="l00371"></a>00371 
<a name="l00372"></a><a class="code" href="struct_o_c_i___statement.html">00372</a> <span class="keyword">struct </span><a class="code" href="struct_o_c_i___statement.html" title="Oracle SQL or PL/SQL statement.">OCI_Statement</a> {
<a name="l00373"></a>00373     OCIStmt         *stmt;          <span class="comment">/* OCI statement handle */</span>
<a name="l00374"></a>00374     ub4              hstate;        <span class="comment">/* object variable state */</span>
<a name="l00375"></a>00375     <a class="code" href="struct_o_c_i___resultset.html" title="Collection of output columns from a select statement.">OCI_Resultset</a>  **rsts;          <span class="comment">/* pointer to resultset list */</span>
<a name="l00376"></a>00376     <a class="code" href="struct_o_c_i___connection.html" title="Oracle physical connection.">OCI_Connection</a>  *con;           <span class="comment">/* pointer to connection object */</span>
<a name="l00377"></a>00377     mtext           *sql;           <span class="comment">/* SQL statement */</span>
<a name="l00378"></a>00378     OCI_Bind       **binds;         <span class="comment">/* array of bind objects */</span>
<a name="l00379"></a>00379     ub2              nb_binds;      <span class="comment">/* number of elememts in the bind array */</span>
<a name="l00380"></a>00380     ub2              nb_outbinds;   <span class="comment">/* number of output binds */</span>
<a name="l00381"></a>00381     <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span>     bind_mode;     <span class="comment">/* type of binding */</span>
<a name="l00382"></a>00382     ub4              exec_mode;     <span class="comment">/* type of execution */</span>
<a name="l00383"></a>00383     ub4              fetch_size;    <span class="comment">/* fetch array size */</span>
<a name="l00384"></a>00384     ub4              prefetch_size; <span class="comment">/* prefetch size */</span>
<a name="l00385"></a>00385     ub4              prefetch_mem;  <span class="comment">/* prefetch memory */</span>
<a name="l00386"></a>00386     ub4              long_size;     <span class="comment">/* default size for LONG columns */</span>
<a name="l00387"></a>00387     ub1              long_mode;     <span class="comment">/* LONG datatype handling mode */</span>
<a name="l00388"></a>00388     ub1              status;        <span class="comment">/* statement status */</span>
<a name="l00389"></a>00389     ub2              type;          <span class="comment">/* type of SQL statement */</span>
<a name="l00390"></a>00390     ub4              nb_iters;      <span class="comment">/* number of iterations for execution */</span>
<a name="l00391"></a>00391     ub4              nb_rs;         <span class="comment">/* number of resulsets */</span>
<a name="l00392"></a>00392     ub2              cur_rs;        <span class="comment">/* index of the current resulset */</span>
<a name="l00393"></a>00393     ub2              dynidx;        <span class="comment">/* bind index counter for dynamic exec */</span>
<a name="l00394"></a>00394     ub2              err_pos;       <span class="comment">/* error position in sql statement */</span>
<a name="l00395"></a>00395 };
<a name="l00396"></a>00396 
<a name="l00397"></a>00397 <span class="comment">/*</span>
<a name="l00398"></a>00398 <span class="comment"> * Internal Large object </span>
<a name="l00399"></a>00399 <span class="comment"> *</span>
<a name="l00400"></a>00400 <span class="comment"> */</span>
<a name="l00401"></a>00401 
<a name="l00402"></a><a class="code" href="struct_o_c_i___lob.html">00402</a> <span class="keyword">struct </span><a class="code" href="struct_o_c_i___lob.html" title="Oracle Internal Large objects :.">OCI_Lob</a> {
<a name="l00403"></a>00403     OCILobLocator   *handle;    <span class="comment">/* OCI handle */</span>
<a name="l00404"></a>00404     ub4              hstate;    <span class="comment">/* object variable state */</span>
<a name="l00405"></a>00405     <a class="code" href="struct_o_c_i___connection.html" title="Oracle physical connection.">OCI_Connection</a>  *con;       <span class="comment">/* pointer to connection object */</span>
<a name="l00406"></a>00406     ub4              type;      <span class="comment">/* type of lob */</span>
<a name="l00407"></a>00407     big_uint         offset;    <span class="comment">/* current offset for R/W */</span>
<a name="l00408"></a>00408 };
<a name="l00409"></a>00409 
<a name="l00410"></a>00410 <span class="comment">/* </span>
<a name="l00411"></a>00411 <span class="comment"> * External Large object </span>
<a name="l00412"></a>00412 <span class="comment"> *</span>
<a name="l00413"></a>00413 <span class="comment"> */</span>
<a name="l00414"></a>00414 
<a name="l00415"></a><a class="code" href="struct_o_c_i___file.html">00415</a> <span class="keyword">struct </span><a class="code" href="struct_o_c_i___file.html" title="Oracle External Large objects :.">OCI_File</a> {
<a name="l00416"></a>00416     OCILobLocator   *handle;    <span class="comment">/* OCI handle */</span>
<a name="l00417"></a>00417     ub4              hstate;    <span class="comment">/* object variable state */</span>
<a name="l00418"></a>00418     <a class="code" href="struct_o_c_i___connection.html" title="Oracle physical connection.">OCI_Connection</a>  *con;       <span class="comment">/* pointer to connection object */</span>
<a name="l00419"></a>00419     mtext           *dir;       <span class="comment">/* directory name */</span>
<a name="l00420"></a>00420     mtext           *name;      <span class="comment">/* file name */</span>
<a name="l00421"></a>00421     ub4              type;      <span class="comment">/* type of file */</span>
<a name="l00422"></a>00422     big_uint         offset;    <span class="comment">/* current offset for read */</span>
<a name="l00423"></a>00423 };
<a name="l00424"></a>00424 
<a name="l00425"></a>00425 <span class="comment">/* </span>
<a name="l00426"></a>00426 <span class="comment"> * Long object </span>
<a name="l00427"></a>00427 <span class="comment"> *</span>
<a name="l00428"></a>00428 <span class="comment"> */</span> 
<a name="l00429"></a>00429 
<a name="l00430"></a><a class="code" href="struct_o_c_i___long.html">00430</a> <span class="keyword">struct </span><a class="code" href="struct_o_c_i___long.html" title="Oracle Long datatype.">OCI_Long</a> {
<a name="l00431"></a>00431     <a class="code" href="struct_o_c_i___statement.html" title="Oracle SQL or PL/SQL statement.">OCI_Statement</a>   *stmt;      <span class="comment">/* pointer to statement object */</span>
<a name="l00432"></a>00432     ub4              hstate;    <span class="comment">/* object variable state */</span>
<a name="l00433"></a>00433     OCI_Define      *def;       <span class="comment">/* pointer to resultset define object */</span>
<a name="l00434"></a>00434     ub4              size;      <span class="comment">/* size of the buffer read / written */</span>
<a name="l00435"></a>00435     <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span>     type;      <span class="comment">/* type of long */</span>
<a name="l00436"></a>00436     ub4              offset;    <span class="comment">/* current offset for R/W */</span>
<a name="l00437"></a>00437     ub4              piecesize; <span class="comment">/* size of current fetched piece */</span>
<a name="l00438"></a>00438     ub4              maxsize;   <span class="comment">/* current offset for R/W */</span>
<a name="l00439"></a>00439     ub1             *buffer;    <span class="comment">/* fetched buffer */</span>
<a name="l00440"></a>00440 };
<a name="l00441"></a>00441 
<a name="l00442"></a>00442 <span class="comment">/*</span>
<a name="l00443"></a>00443 <span class="comment"> * Date object </span>
<a name="l00444"></a>00444 <span class="comment"> *</span>
<a name="l00445"></a>00445 <span class="comment"> */</span>
<a name="l00446"></a>00446 
<a name="l00447"></a><a class="code" href="struct_o_c_i___date.html">00447</a> <span class="keyword">struct </span><a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> {
<a name="l00448"></a>00448     OCIDate         *handle;    <span class="comment">/* OCI handle */</span>
<a name="l00449"></a>00449     ub4              hstate;    <span class="comment">/* object variable state */</span>
<a name="l00450"></a>00450     <a class="code" href="struct_o_c_i___connection.html" title="Oracle physical connection.">OCI_Connection</a>  *con;       <span class="comment">/* pointer to connection object */</span>
<a name="l00451"></a>00451     OCIError        *err;       <span class="comment">/* OCI context handle */</span>
<a name="l00452"></a>00452     ub4              allocated; <span class="comment">/* is handle allocated ? */</span> 
<a name="l00453"></a>00453 };
<a name="l00454"></a>00454 
<a name="l00455"></a>00455 <span class="comment">/* </span>
<a name="l00456"></a>00456 <span class="comment"> * Timestamp object </span>
<a name="l00457"></a>00457 <span class="comment"> *</span>
<a name="l00458"></a>00458 <span class="comment"> */</span>
<a name="l00459"></a>00459 
<a name="l00460"></a><a class="code" href="struct_o_c_i___timestamp.html">00460</a> <span class="keyword">struct </span><a class="code" href="struct_o_c_i___timestamp.html" title="Oracle internal timespamp representation.">OCI_Timestamp</a> {
<a name="l00461"></a>00461 <span class="preprocessor">#if OCI_VERSION_COMPILE &gt;= OCI_9</span>
<a name="l00462"></a>00462 <span class="preprocessor"></span>    OCIDateTime     *handle;    <span class="comment">/* OCI handle */</span>
<a name="l00463"></a>00463 <span class="preprocessor">#else</span>
<a name="l00464"></a>00464 <span class="preprocessor"></span>    <span class="keywordtype">void</span>            *handle;    <span class="comment">/* fake handle for alignment */</span>
<a name="l00465"></a>00465 <span class="preprocessor">#endif</span>
<a name="l00466"></a>00466 <span class="preprocessor"></span>    ub4              hstate;    <span class="comment">/* object variable state */</span>
<a name="l00467"></a>00467     <a class="code" href="struct_o_c_i___connection.html" title="Oracle physical connection.">OCI_Connection</a>  *con;       <span class="comment">/* pointer to connection object */</span>
<a name="l00468"></a>00468     OCIError        *err;       <span class="comment">/* OCI context handle */</span>
<a name="l00469"></a>00469     ub4              type;      <span class="comment">/* sub type */</span>
<a name="l00470"></a>00470 };
<a name="l00471"></a>00471 
<a name="l00472"></a>00472 <span class="comment">/* </span>
<a name="l00473"></a>00473 <span class="comment"> * Interval object </span>
<a name="l00474"></a>00474 <span class="comment"> *</span>
<a name="l00475"></a>00475 <span class="comment"> */</span>
<a name="l00476"></a>00476 
<a name="l00477"></a><a class="code" href="struct_o_c_i___interval.html">00477</a> <span class="keyword">struct </span><a class="code" href="struct_o_c_i___interval.html" title="Oracle internal interval representation.">OCI_Interval</a> {