ocilib__types_8h-source.html

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

<a name="l00232"></a>00232     <a class="code" href="struct_o_c_i___conn_pool.html" title="Oracle Connection Pool.">OCI_ConnPool</a>       *pool;      <span class="comment">/* pointer to connection pool parent */</span>
<a name="l00233"></a>00233     OCI_ServerOutput   *svopt;     <span class="comment">/* Pointer to server output object */</span>
<a name="l00234"></a>00234     OCIServer          *svr;       <span class="comment">/* OCI server  handle */</span>
<a name="l00235"></a>00235     OCIError           *err;       <span class="comment">/* OCI context handle */</span>
<a name="l00236"></a>00236     OCISession         *ses;       <span class="comment">/* OCI session handle */</span>
<a name="l00237"></a>00237     OCISvcCtx          *cxt;       <span class="comment">/* OCI context handle */</span>
<a name="l00238"></a>00238     <span class="keywordtype">boolean</span>             autocom;   <span class="comment">/* auto commit mode */</span>
<a name="l00239"></a>00239     <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span>        nb_files;  <span class="comment">/* number of OCI_File opened by the connection */</span>
<a name="l00240"></a>00240     <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span>        mode;      <span class="comment">/* session mode */</span>
<a name="l00241"></a>00241     <span class="keywordtype">int</span>                 cstate;    <span class="comment">/* connection state */</span>
<a name="l00242"></a>00242     <span class="keywordtype">void</span>               *usrdata;   <span class="comment">/* user data */</span>
<a name="l00243"></a>00243     mtext              *fmt_date;  <span class="comment">/* date string format for conversion */</span>
<a name="l00244"></a>00244     mtext              *fmt_num;   <span class="comment">/* numeric string format for conversion */</span>
<a name="l00245"></a>00245     <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span>        ver_maj;   <span class="comment">/* server version major number */</span>
<a name="l00246"></a>00246     <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span>        ver_min;   <span class="comment">/* server version minor number */</span>
<a name="l00247"></a>00247     <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span>        ver_rev;   <span class="comment">/* server version revision number */</span>
<a name="l00248"></a>00248 };
<a name="l00249"></a>00249 
<a name="l00250"></a>00250 <span class="comment">/* </span>
<a name="l00251"></a>00251 <span class="comment"> * Transaction object</span>
<a name="l00252"></a>00252 <span class="comment"> *</span>
<a name="l00253"></a>00253 <span class="comment"> */</span>
<a name="l00254"></a>00254 
<a name="l00255"></a><a class="code" href="struct_o_c_i___transaction.html">00255</a> <span class="keyword">struct </span><a class="code" href="struct_o_c_i___transaction.html" title="Oracle Transaction.">OCI_Transaction</a>
<a name="l00256"></a>00256 {
<a name="l00257"></a>00257     <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="l00258"></a>00258     OCITrans        *htr;       <span class="comment">/* OCI transaction handle */</span>
<a name="l00259"></a>00259     <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span>     timeout;   <span class="comment">/* timeout */</span>
<a name="l00260"></a>00260     <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span>     mode;      <span class="comment">/* transaction mode */</span>
<a name="l00261"></a>00261     <span class="keywordtype">boolean</span>          local;     <span class="comment">/* is local transaction ? */</span>
<a name="l00262"></a>00262     <a class="code" href="struct_o_c_i___x_i_d.html" title="Global transaction identifier.">OCI_XID</a>          xid;       <span class="comment">/* global transaction identitifer */</span>
<a name="l00263"></a>00263 };
<a name="l00264"></a>00264 
<a name="l00265"></a>00265 <span class="comment">/* </span>
<a name="l00266"></a>00266 <span class="comment"> * Column object</span>
<a name="l00267"></a>00267 <span class="comment"> *</span>
<a name="l00268"></a>00268 <span class="comment"> */</span>
<a name="l00269"></a>00269 
<a name="l00270"></a><a class="code" href="struct_o_c_i___column.html">00270</a> <span class="keyword">struct </span><a class="code" href="struct_o_c_i___column.html" title="Oracle SQL Column and Type member representation.">OCI_Column</a> {
<a name="l00271"></a>00271 
<a name="l00272"></a>00272     <span class="comment">/* 0racle infos */</span> 
<a name="l00273"></a>00273     ub2              ocode;     <span class="comment">/* Oracle SQL code */</span>
<a name="l00274"></a>00274     ub2              tcode;     <span class="comment">/* Oracle type code */</span>
<a name="l00275"></a>00275     ub2              icode;     <span class="comment">/* Internal translated Oracle SQL code */</span>
<a name="l00276"></a>00276     ub2              size;      <span class="comment">/* SQL Size */</span>
<a name="l00277"></a>00277     sb2              prec;      <span class="comment">/* SQL precision 1 (number prec, leading prec) */</span>
<a name="l00278"></a>00278     sb2              prec2;     <span class="comment">/* SQL precision 2 (fractionnal prec) */</span>
<a name="l00279"></a>00279     sb1              scale;     <span class="comment">/* SQL scale */</span>
<a name="l00280"></a>00280     ub1              type;      <span class="comment">/* internal datatype */</span>
<a name="l00281"></a>00281     ub1              null;      <span class="comment">/* is nullable */</span>
<a name="l00282"></a>00282     ub1              charused;  <span class="comment">/* is column size expressed in characters */</span>
<a name="l00283"></a>00283     mtext           *name;      <span class="comment">/* column name */</span>
<a name="l00284"></a>00284     ub2              charsize;  <span class="comment">/* SQL Size in character */</span>
<a name="l00285"></a>00285     ub1              csfrm;     <span class="comment">/* charset form */</span>
<a name="l00286"></a>00286     ub1              dtype;     <span class="comment">/* oracle handle type */</span>
<a name="l00287"></a>00287 
<a name="l00288"></a>00288     <span class="comment">/* OCILIB infos */</span> 
<a name="l00289"></a>00289     ub4              bufsize;   <span class="comment">/* element size */</span>
<a name="l00290"></a>00290     <a class="code" href="struct_o_c_i___schema.html" title="Schema metadata handle.">OCI_Schema</a>      *nty;       <span class="comment">/* user type descriptor */</span> 
<a name="l00291"></a>00291     ub4              subtype;   <span class="comment">/* object type */</span>
<a name="l00292"></a>00292 };
<a name="l00293"></a>00293 
<a name="l00294"></a>00294 <span class="comment">/* </span>
<a name="l00295"></a>00295 <span class="comment"> * OCI_Buffer : Internal input/output buffer</span>
<a name="l00296"></a>00296 <span class="comment"> *</span>
<a name="l00297"></a>00297 <span class="comment"> */</span>
<a name="l00298"></a>00298 
<a name="l00299"></a>00299 <span class="keyword">typedef</span> <span class="keyword">struct </span>OCI_Buffer {
<a name="l00300"></a>00300     <span class="keywordtype">void</span>            *handle;   <span class="comment">/* OCI handle (bind or define) */</span>
<a name="l00301"></a>00301     <span class="keywordtype">void</span>           **data;     <span class="comment">/* data / array of data */</span>
<a name="l00302"></a>00302     <span class="keywordtype">void</span>            *inds;     <span class="comment">/* array of indicators */</span>
<a name="l00303"></a>00303     <span class="keywordtype">void</span>            *lens;     <span class="comment">/* array of lengths */</span>
<a name="l00304"></a>00304     dtext           *temp;     <span class="comment">/* temporary buffer for string conversion */</span>
<a name="l00305"></a>00305     ub4              count;    <span class="comment">/* number of elements in the buffer */</span>
<a name="l00306"></a>00306     <span class="keywordtype">int</span>              sizelen;  <span class="comment">/* size of an element in the lens array */</span>
<a name="l00307"></a>00307 } OCI_Buffer;
<a name="l00308"></a>00308 
<a name="l00309"></a>00309 <span class="comment">/* </span>
<a name="l00310"></a>00310 <span class="comment"> * OCI_Bind : Internal bind representation.</span>
<a name="l00311"></a>00311 <span class="comment"> *</span>
<a name="l00312"></a>00312 <span class="comment"> * A bind object is an object that holds all information about an Oracle</span>
<a name="l00313"></a>00313 <span class="comment"> * statement binding operation</span>
<a name="l00314"></a>00314 <span class="comment"> *</span>
<a name="l00315"></a>00315 <span class="comment"> */</span>
<a name="l00316"></a>00316 
<a name="l00317"></a>00317 <span class="keyword">typedef</span> <span class="keyword">struct </span>OCI_Bind {
<a name="l00318"></a>00318     <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="l00319"></a>00319     <span class="keywordtype">void</span>           **input;     <span class="comment">/* input values */</span>
<a name="l00320"></a>00320     mtext           *name;      <span class="comment">/* name of the bind */</span>
<a name="l00321"></a>00321     ub1              mode;      <span class="comment">/* in / out mode */</span>
<a name="l00322"></a>00322     ub1              type;      <span class="comment">/* internal datatype */</span>
<a name="l00323"></a>00323     ub1              subtype;   <span class="comment">/* internal subtype */</span>
<a name="l00324"></a>00324     ub1              alloc;     <span class="comment">/* is buffer allocated or mapped to input */</span>
<a name="l00325"></a>00325     sb4              size;      <span class="comment">/* data size */</span>
<a name="l00326"></a>00326     OCI_Buffer       buf;       <span class="comment">/* place holder */</span>
<a name="l00327"></a>00327     ub2              code;      <span class="comment">/* SQL datatype code */</span>
<a name="l00328"></a>00328     ub2              dynpos;    <span class="comment">/* index of the bind for dynamic binds */</span>
<a name="l00329"></a>00329     ub2             *plsizes;   <span class="comment">/* PL/SQL tables element sizes */</span>
<a name="l00330"></a>00330     ub2             *plrcds;    <span class="comment">/* PL/SQL tables return codes */</span>
<a name="l00331"></a>00331     ub4              nbelem;    <span class="comment">/* PL/SQL tables nb elements */</span>
<a name="l00332"></a>00332 } OCI_Bind;
<a name="l00333"></a>00333 
<a name="l00334"></a>00334 <span class="comment">/*</span>
<a name="l00335"></a>00335 <span class="comment"> * OCI_Define : Internal Resultset column data implementation</span>
<a name="l00336"></a>00336 <span class="comment"> *</span>
<a name="l00337"></a>00337 <span class="comment"> */</span>
<a name="l00338"></a>00338 
<a name="l00339"></a>00339 <span class="keyword">typedef</span> <span class="keyword">struct </span>OCI_Define {
<a name="l00340"></a>00340     <a class="code" href="struct_o_c_i___resultset.html" title="Collection of output columns from a select statement.">OCI_Resultset</a>   *rs;           <span class="comment">/* pointer to resultset object */</span>
<a name="l00341"></a>00341     <span class="keywordtype">void</span>            *obj;          <span class="comment">/* current OCILIB object instance */</span>
<a name="l00342"></a>00342     <a class="code" href="struct_o_c_i___column.html" title="Oracle SQL Column and Type member representation.">OCI_Column</a>       col;          <span class="comment">/* column object */</span>
<a name="l00343"></a>00343     OCI_Buffer       buf;          <span class="comment">/* placeholder */</span>
<a name="l00344"></a>00344 } OCI_Define;
<a name="l00345"></a>00345 
<a name="l00346"></a>00346 <span class="comment">/* </span>
<a name="l00347"></a>00347 <span class="comment"> * Resultset object</span>
<a name="l00348"></a>00348 <span class="comment"> *</span>
<a name="l00349"></a>00349 <span class="comment"> */</span>
<a name="l00350"></a>00350 
<a name="l00351"></a><a class="code" href="struct_o_c_i___resultset.html">00351</a> <span class="keyword">struct </span><a class="code" href="struct_o_c_i___resultset.html" title="Collection of output columns from a select statement.">OCI_Resultset</a> {
<a name="l00352"></a>00352     <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="l00353"></a>00353     <a class="code" href="struct_o_c_i___hash_table.html" title="OCILIB implementation of hash tables.">OCI_HashTable</a>   *map;           <span class="comment">/* hash table handle for mapping name/index */</span>
<a name="l00354"></a>00354     OCI_Define      *defs;          <span class="comment">/* array of define objects */</span>