⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 callback_8c-source.html

📁 ORACLE编程的好东西,纯C写的OCI封装.很好用,支持数据池.
💻 HTML
📖 第 1 页 / 共 2 页
字号:
<a name="l00094"></a>00094     OCI_Bind * bnd    = (OCI_Bind *) octxp;<a name="l00095"></a>00095     OCI_Define *def   = NULL;<a name="l00096"></a>00096     <a class="code" href="struct_o_c_i___resultset.html" title="Collection of output columns from a select statement.">OCI_Resultset</a> *rs = NULL;<a name="l00097"></a>00097     <span class="keywordtype">boolean</span> res       = TRUE;<a name="l00098"></a>00098     ub4 rows          = 0;<a name="l00099"></a>00099 <a name="l00100"></a>00100     <span class="comment">/* those checks may be not necessary but they keep away compilers warning</span><a name="l00101"></a>00101 <span class="comment">       away if the warning level is set to maximum !</span><a name="l00102"></a>00102 <span class="comment">    */</span><a name="l00103"></a>00103 <a name="l00104"></a>00104     OCI_NOT_USED(bindp);<a name="l00105"></a>00105 <a name="l00106"></a>00106     <span class="comment">/* check objects and bounds */</span><a name="l00107"></a>00107 <a name="l00108"></a>00108     OCI_CHECK(bnd  == NULL, OCI_ERROR);<a name="l00109"></a>00109     OCI_CHECK(iter &gt;= bnd-&gt;buf.count, OCI_ERROR);<a name="l00110"></a>00110 <a name="l00111"></a>00111     <span class="comment">/* update statmement status */</span><a name="l00112"></a>00112 <a name="l00113"></a>00113     bnd-&gt;stmt-&gt;status = OCI_STMT_EXECUTED;<a name="l00114"></a>00114 <a name="l00115"></a>00115     <span class="comment">/* create resultset on the first row processed for each iteration */</span><a name="l00116"></a>00116 <a name="l00117"></a>00117     <span class="keywordflow">if</span> (index == 0)<a name="l00118"></a>00118     {<a name="l00119"></a>00119         bnd-&gt;stmt-&gt;nb_rs   = bnd-&gt;stmt-&gt;nb_iters;<a name="l00120"></a>00120         bnd-&gt;stmt-&gt;cur_rs  = 0;<a name="l00121"></a>00121 <a name="l00122"></a>00122         <span class="comment">/* allocate resultset handles array */</span><a name="l00123"></a>00123 <a name="l00124"></a>00124         <span class="keywordflow">if</span> (bnd-&gt;stmt-&gt;rsts == NULL)<a name="l00125"></a>00125         {<a name="l00126"></a>00126             bnd-&gt;stmt-&gt;rsts = (<a class="code" href="struct_o_c_i___resultset.html" title="Collection of output columns from a select statement.">OCI_Resultset</a> **) OCI_MemAlloc(OCI_IPC_RESULTSET_ARRAY, <a name="l00127"></a>00127                                                               <span class="keyword">sizeof</span>(*bnd-&gt;stmt-&gt;rsts),<a name="l00128"></a>00128                                                               bnd-&gt;stmt-&gt;nb_rs, TRUE);<a name="l00129"></a>00129  <a name="l00130"></a>00130             <span class="keywordflow">if</span> (bnd-&gt;stmt-&gt;rsts == NULL)<a name="l00131"></a>00131                 res = FALSE;<a name="l00132"></a>00132         }<a name="l00133"></a>00133         <a name="l00134"></a>00134         <span class="comment">/* create resultset as needed */</span><a name="l00135"></a>00135 <a name="l00136"></a>00136         <span class="keywordflow">if</span> (bnd-&gt;stmt-&gt;rsts[iter] == NULL)<a name="l00137"></a>00137         {<a name="l00138"></a>00138             OCI_CALL1<a name="l00139"></a>00139             (   <a name="l00140"></a>00140                 res, bnd-&gt;stmt-&gt;con, bnd-&gt;stmt,<a name="l00141"></a>00141                 <a name="l00142"></a>00142                 OCIAttrGet(bnd-&gt;buf.handle, (ub4) OCI_HTYPE_BIND, (<span class="keywordtype">void</span> *) &amp;rows, <a name="l00143"></a>00143                            (ub4 *) NULL, (ub4) OCI_ATTR_ROWS_RETURNED,<a name="l00144"></a>00144                            bnd-&gt;stmt-&gt;con-&gt;err)<a name="l00145"></a>00145             )<a name="l00146"></a>00146 <a name="l00147"></a>00147             if (res == TRUE)<a name="l00148"></a>00148             {<a name="l00149"></a>00149                 bnd-&gt;stmt-&gt;rsts[iter] = OCI_ResultsetCreate(bnd-&gt;stmt, rows);<a name="l00150"></a>00150 <a name="l00151"></a>00151                 <span class="keywordflow">if</span> (bnd-&gt;stmt-&gt;rsts[iter] != NULL)<a name="l00152"></a>00152                     bnd-&gt;stmt-&gt;rsts[iter]-&gt;row_count = rows;<a name="l00153"></a>00153             }<a name="l00154"></a>00154         }<a name="l00155"></a>00155     }<a name="l00156"></a>00156 <a name="l00157"></a>00157     OCI_CHECK(bnd-&gt;stmt-&gt;rsts == NULL, OCI_ERROR);<a name="l00158"></a>00158     <a name="l00159"></a>00159     rs = bnd-&gt;<a class="code" href="struct_o_c_i___resultset.html#c12ae7da6f8d20f00c6ad69cdb31373a">stmt</a>-&gt;<a class="code" href="struct_o_c_i___statement.html#aa888e80d16c06da0bca96b6bca6826d">rsts</a>[iter];<a name="l00160"></a>00160 <a name="l00161"></a>00161     OCI_CHECK(rs == NULL, OCI_ERROR);<a name="l00162"></a>00162  <a name="l00163"></a>00163     <span class="comment">/* ok.. let's Oracle update its buffers */</span><a name="l00164"></a>00164 <a name="l00165"></a>00165     <span class="keywordflow">if</span> (res == TRUE)<a name="l00166"></a>00166     {<a name="l00167"></a>00167         <span class="comment">/* update pointers contents */</span><a name="l00168"></a>00168 <a name="l00169"></a>00169         def = &amp;rs-&gt;<a class="code" href="struct_o_c_i___resultset.html#ca691fad2f84ecfb8956f5e1649c0a53">defs</a>[bnd-&gt;dynpos];<a name="l00170"></a>00170 <a name="l00171"></a>00171         <span class="keywordflow">switch</span> (def-&gt;col.type)<a name="l00172"></a>00172         {<a name="l00173"></a>00173 <a name="l00174"></a>00174             <span class="keywordflow">case</span> OCI_CDT_CURSOR:<a name="l00175"></a>00175             <span class="keywordflow">case</span> OCI_CDT_TIMESTAMP:<a name="l00176"></a>00176             <span class="keywordflow">case</span> OCI_CDT_INTERVAL:<a name="l00177"></a>00177             <span class="keywordflow">case</span> OCI_CDT_LOB:<a name="l00178"></a>00178             <span class="keywordflow">case</span> OCI_CDT_FILE:<a name="l00179"></a>00179 <a name="l00180"></a>00180                 *bufpp = def-&gt;buf.data[index];<a name="l00181"></a>00181                 <span class="keywordflow">break</span>;<a name="l00182"></a>00182 <a name="l00183"></a>00183             <span class="keywordflow">default</span>:<a name="l00184"></a>00184 <a name="l00185"></a>00185                 *bufpp = (((ub1*)def-&gt;buf.data) + (def-&gt;col.bufsize * index));<a name="l00186"></a>00186         }<a name="l00187"></a>00187 <a name="l00188"></a>00188         *alenp  = (ub4   *) (((ub1 *) def-&gt;buf.lens) + (def-&gt;buf.sizelen * index));<a name="l00189"></a>00189         *indp   = (dvoid *) (((ub1 *) def-&gt;buf.inds) + (<span class="keyword">sizeof</span>(sb2) * index));<a name="l00190"></a>00190         *piecep = (ub1    ) OCI_ONE_PIECE;<a name="l00191"></a>00191         *rcodep = (ub2   *) NULL;                <a name="l00192"></a>00192     }<a name="l00193"></a>00193 <a name="l00194"></a>00194     <span class="keywordflow">return</span> ((res == TRUE) ? OCI_CONTINUE : OCI_ERROR);<a name="l00195"></a>00195 }</pre></div><hr size="1"><address style="text-align: right;"><small>Generated on Thu Oct 9 10:07:42 2008 for OCILIB (C Driver for Oracle) by&nbsp;<a href="http://www.doxygen.org/index.html"><img src="doxygen.png" alt="doxygen" align="middle" border="0"></a> 1.5.4 </small></address></body></html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -