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

📄 column_8c-source.html

📁 ORACLE编程的好东西,纯C写的OCI封装.很好用,支持数据池.
💻 HTML
📖 第 1 页 / 共 5 页
字号:
<a name="l00131"></a>00131         OCIAttrGet((dvoid *) param, (ub4) OCI_DTYPE_PARAM, (dvoid *) &amp;col-&gt;csfrm, <a name="l00132"></a>00132                    (ub4 *) NULL, (ub4) OCI_ATTR_CHARSET_FORM, con-&gt;err)<a name="l00133"></a>00133     )<a name="l00134"></a>00134 <a name="l00135"></a>00135     <span class="comment">/* type of column length for string based column */</span><a name="l00136"></a>00136 <a name="l00137"></a>00137 <span class="preprocessor">#if OCI_VERSION_COMPILE &gt;= OCI_9 </span><a name="l00138"></a>00138 <span class="preprocessor"></span><a name="l00139"></a>00139     <span class="keywordflow">if</span> ((OCILib.ver_runtime &gt;= OCI_9) &amp;&amp; (con-&gt;ver_maj &gt;= OCI_9))<a name="l00140"></a>00140     {<a name="l00141"></a>00141         <span class="comment">/* char used - no error checking because the on Oracle 9.0, querying</span><a name="l00142"></a>00142 <span class="comment">                       this param that is not char/varchar based will cause an </span><a name="l00143"></a>00143 <span class="comment">                       error */</span><a name="l00144"></a>00144 <a name="l00145"></a>00145         OCI_CALL1<a name="l00146"></a>00146         (<a name="l00147"></a>00147             res, con, stmt,<a name="l00148"></a>00148             <a name="l00149"></a>00149             OCIAttrGet((dvoid *) param, (ub4) OCI_DTYPE_PARAM, <a name="l00150"></a>00150                        (dvoid *) &amp;col-&gt;<a class="code" href="struct_o_c_i___column.html#826cc6a4d1aca903a8ff253458f8be16">charused</a>, (ub4 *) NULL, <a name="l00151"></a>00151                        (ub4) OCI_ATTR_CHAR_USED, con-&gt;err)<a name="l00152"></a>00152         )<a name="l00153"></a>00153     }<a name="l00154"></a>00154 <a name="l00155"></a>00155     <span class="comment">/* char size */</span><a name="l00156"></a>00156     <a name="l00157"></a>00157     <span class="keywordflow">if</span> (col-&gt;<a class="code" href="struct_o_c_i___column.html#826cc6a4d1aca903a8ff253458f8be16">charused</a> == TRUE)<a name="l00158"></a>00158     {<a name="l00159"></a>00159         OCI_CALL1<a name="l00160"></a>00160         (<a name="l00161"></a>00161             res, con, stmt,<a name="l00162"></a>00162         <a name="l00163"></a>00163             OCIAttrGet((dvoid *) param, (ub4) OCI_DTYPE_PARAM, <a name="l00164"></a>00164                        (dvoid *) &amp;col-&gt;<a class="code" href="struct_o_c_i___column.html#6c9a6a724ee1b211e2088c21b494d0c4">charsize</a>, (ub4 *) NULL, <a name="l00165"></a>00165                        (ub4) OCI_ATTR_CHAR_SIZE, con-&gt;err)<a name="l00166"></a>00166         )<a name="l00167"></a>00167     }<a name="l00168"></a>00168 <a name="l00169"></a>00169     <span class="keywordflow">if</span> ((OCILib.ver_runtime &gt;= OCI_9) &amp;&amp; (con-&gt;ver_maj &gt;= OCI_9))<a name="l00170"></a>00170     {<a name="l00171"></a>00171         <span class="comment">/* fractionnal time precision for timestamps */</span><a name="l00172"></a>00172 <a name="l00173"></a>00173          <span class="keywordflow">if</span> (col-&gt;<a class="code" href="struct_o_c_i___column.html#ecb72443546a3c89b21c3cde379210a9">ocode</a> == SQLT_TIMESTAMP    ||<a name="l00174"></a>00174              col-&gt;<a class="code" href="struct_o_c_i___column.html#ecb72443546a3c89b21c3cde379210a9">ocode</a> == SQLT_TIMESTAMP_TZ ||<a name="l00175"></a>00175              col-&gt;<a class="code" href="struct_o_c_i___column.html#ecb72443546a3c89b21c3cde379210a9">ocode</a> == SQLT_TIMESTAMP_LTZ)<a name="l00176"></a>00176         {<a name="l00177"></a>00177             OCI_CALL1<a name="l00178"></a>00178             (<a name="l00179"></a>00179                 res, con, stmt,<a name="l00180"></a>00180         <a name="l00181"></a>00181                 OCIAttrGet((dvoid *) param, (ub4) OCI_DTYPE_PARAM,<a name="l00182"></a>00182                            (dvoid *) &amp;col-&gt;<a class="code" href="struct_o_c_i___column.html#c4994d12d5658ac0749a89eca1c1b1c3">prec</a>, (ub4 *) NULL, <a name="l00183"></a>00183                            (ub4) OCI_ATTR_FSPRECISION, con-&gt;err)<a name="l00184"></a>00184             )<a name="l00185"></a>00185         }<a name="l00186"></a>00186 <a name="l00187"></a>00187         <span class="comment">/* leading and fractionnal precision for interval */</span><a name="l00188"></a>00188 <a name="l00189"></a>00189         <span class="keywordflow">if</span> (col-&gt;<a class="code" href="struct_o_c_i___column.html#ecb72443546a3c89b21c3cde379210a9">ocode</a> == SQLT_INTERVAL_DS ||<a name="l00190"></a>00190             col-&gt;<a class="code" href="struct_o_c_i___column.html#ecb72443546a3c89b21c3cde379210a9">ocode</a> == SQLT_INTERVAL_YM)<a name="l00191"></a>00191         {<a name="l00192"></a>00192             OCI_CALL1<a name="l00193"></a>00193             (<a name="l00194"></a>00194                 res, con, stmt,<a name="l00195"></a>00195         <a name="l00196"></a>00196                 OCIAttrGet((dvoid *) param, (ub4) OCI_DTYPE_PARAM, <a name="l00197"></a>00197                            (dvoid *) &amp;col-&gt;<a class="code" href="struct_o_c_i___column.html#c4994d12d5658ac0749a89eca1c1b1c3">prec</a>, (ub4 *) NULL, <a name="l00198"></a>00198                            (ub4) OCI_ATTR_LFPRECISION, con-&gt;err)<a name="l00199"></a>00199             )<a name="l00200"></a>00200 <a name="l00201"></a>00201             OCI_CALL1<a name="l00202"></a>00202             (<a name="l00203"></a>00203                 res, con, stmt,<a name="l00204"></a>00204         <a name="l00205"></a>00205                 OCIAttrGet((dvoid *) param, (ub4) OCI_DTYPE_PARAM, <a name="l00206"></a>00206                            (dvoid *) &amp;col-&gt;prec2, (ub4 *) NULL, <a name="l00207"></a>00207                            (ub4) OCI_ATTR_FSPRECISION, con-&gt;err)<a name="l00208"></a>00208             )<a name="l00209"></a>00209         }<a name="l00210"></a>00210     }<a name="l00211"></a>00211 <a name="l00212"></a>00212 <span class="preprocessor">#endif</span><a name="l00213"></a>00213 <span class="preprocessor"></span><a name="l00214"></a>00214     <span class="comment">/* check nullable only for table based column */</span><a name="l00215"></a>00215 <a name="l00216"></a>00216     <span class="keywordflow">if</span> (ptype == OCI_DESC_RESULTSET)<a name="l00217"></a>00217     {<a name="l00218"></a>00218         OCI_CALL1<a name="l00219"></a>00219         (<a name="l00220"></a>00220             res, con, stmt,<a name="l00221"></a>00221         <a name="l00222"></a>00222             OCIAttrGet((dvoid *) param, (ub4) OCI_DTYPE_PARAM, <a name="l00223"></a>00223                        (dvoid *) &amp;col-&gt;<a class="code" href="struct_o_c_i___column.html#ab0b6dbf7fde1fd08f504888dcc74517">null</a>, (ub4 *) NULL, <a name="l00224"></a>00224                        (ub4) OCI_ATTR_IS_NULL, con-&gt;err)<a name="l00225"></a>00225         )<a name="l00226"></a>00226    }<a name="l00227"></a>00227    <span class="keywordflow">else</span><a name="l00228"></a>00228        col-&gt;<a class="code" href="struct_o_c_i___column.html#ab0b6dbf7fde1fd08f504888dcc74517">null</a> = TRUE;<a name="l00229"></a>00229 <a name="l00230"></a>00230     <span class="comment">/* name */</span><a name="l00231"></a>00231 <a name="l00232"></a>00232     <span class="keywordflow">if</span> (ptype == OCI_DESC_COLLECTION) <a name="l00233"></a>00233         attrname = OCI_ATTR_TYPE_NAME;<a name="l00234"></a>00234     <span class="keywordflow">else</span><a name="l00235"></a>00235         attrname = OCI_ATTR_NAME;<a name="l00236"></a>00236 <a name="l00237"></a>00237     OCI_CALL1<a name="l00238"></a>00238     (<a name="l00239"></a>00239         res, con, stmt,<a name="l00240"></a>00240         <a name="l00241"></a>00241         OCIAttrGet((dvoid *) param, (ub4) OCI_DTYPE_PARAM, (dvoid *) &amp;ostr,<a name="l00242"></a>00242                    (ub4 *) &amp;osize, (ub4) attrname, con-&gt;err)<a name="l00243"></a>00243     )<a name="l00244"></a>00244 <a name="l00245"></a>00245     if ((res == TRUE) &amp;&amp; (ostr != NULL))<a name="l00246"></a>00246     {<a name="l00247"></a>00247         col-&gt;<a class="code" href="struct_o_c_i___column.html#78b329664d213d666619d5130098f309">name</a> = (mtext *) OCI_MemAlloc(OCI_IPC_STRING, <span class="keyword">sizeof</span>(mtext),<a name="l00248"></a>00248                                            ((osize/<span class="keyword">sizeof</span>(omtext))+ 1), TRUE);<a name="l00249"></a>00249   <a name="l00250"></a>00250         <span class="keywordflow">if</span> (col-&gt;<a class="code" href="struct_o_c_i___column.html#78b329664d213d666619d5130098f309">name</a> != NULL)<a name="l00251"></a>00251         {<a name="l00252"></a>00252             OCI_CopyString(ostr, col-&gt;<a class="code" href="struct_o_c_i___column.html#78b329664d213d666619d5130098f309">name</a>, &amp;osize, <a name="l00253"></a>00253                            <span class="keyword">sizeof</span>(omtext), <span class="keyword">sizeof</span>(mtext));<a name="l00254"></a>00254         }<a name="l00255"></a>00255         <span class="keywordflow">else</span><a name="l00256"></a>00256             res = FALSE;<a name="l00257"></a>00257     }<a name="l00258"></a>00258 <a name="l00259"></a>00259     <span class="comment">/* user type descriptor */</span><a name="l00260"></a>00260 <a name="l00261"></a>00261     <span class="keywordflow">if</span> (col-&gt;<a class="code" href="struct_o_c_i___column.html#ecb72443546a3c89b21c3cde379210a9">ocode</a> == SQLT_NTY)<a name="l00262"></a>00262     {<a name="l00263"></a>00263         OCI_CALL1<a name="l00264"></a>00264         (<a name="l00265"></a>00265             res, con, stmt,<a name="l00266"></a>00266         <a name="l00267"></a>00267             OCIAttrGet((dvoid *) param, (ub4) OCI_DTYPE_PARAM, <a name="l00268"></a>00268                        (dvoid *) &amp;ostr, (ub4 *) &amp;osize, <a name="l00269"></a>00269                        (ub4) OCI_ATTR_TYPE_NAME, con-&gt;err)<a name="l00270"></a>00270         )<a name="l00271"></a>00271       <a name="l00272"></a>00272         if ((res == TRUE) &amp;&amp; (ostr != NULL))<a name="l00273"></a>00273         {   <a name="l00274"></a>00274             mtext *tmp = (mtext *) OCI_MemAlloc(OCI_IPC_STRING, <span class="keyword">sizeof</span>(mtext),<a name="l00275"></a>00275                                                ((osize/<span class="keyword">sizeof</span>(omtext))+ 1), TRUE);

⌨️ 快捷键说明

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