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

📄 lob_8c-source.html

📁 ORACLE编程的好东西,纯C写的OCI封装.很好用,支持数据池.
💻 HTML
📖 第 1 页 / 共 5 页
字号:
<a name="l00284"></a>00284             res, lob-&gt;<a class="code" href="struct_o_c_i___lob.html#17646b1cc70c0c914ecb28849333fa65">con</a>, <a name="l00285"></a>00285             <a name="l00286"></a>00286             OCILobRead2(lob-&gt;<a class="code" href="struct_o_c_i___lob.html#17646b1cc70c0c914ecb28849333fa65">con</a>-&gt;<a class="code" href="struct_o_c_i___connection.html#f20d1bea40e79481aeece933a4c70898">cxt</a>, lob-&gt;<a class="code" href="struct_o_c_i___lob.html#17646b1cc70c0c914ecb28849333fa65">con</a>-&gt;<a class="code" href="struct_o_c_i___connection.html#573a359867139990b1b0f50aa7a86175">err</a>,<a name="l00287"></a>00287                         lob-&gt;<a class="code" href="struct_o_c_i___lob.html#bd1e86de291b7773f17282a1e9f79bd6">handle</a>, &amp;size_byte,<a name="l00288"></a>00288                         &amp;size_char,  (ub8) lob-&gt;<a class="code" href="struct_o_c_i___lob.html#a2b896dd50cda4d2b8952deccacdc030">offset</a>, <a name="l00289"></a>00289                         buffer,(ub8) size_in, <a name="l00290"></a>00290                         (ub1) OCI_ONE_PIECE,  (<span class="keywordtype">void</span> *) NULL, <a name="l00291"></a>00291                         NULL, csid, csfrm)<a name="l00292"></a>00292         )<a name="l00293"></a>00293 <a name="l00294"></a>00294         <span class="keywordflow">if</span> (lob-&gt;<a class="code" href="struct_o_c_i___lob.html#f9e973d2ab2c1ec747e9e219f5ca7ba6">type</a> == OCI_BLOB)<a name="l00295"></a>00295             size_out = (ub4) size_byte;<a name="l00296"></a>00296         <span class="keywordflow">else</span><a name="l00297"></a>00297             size_out = (ub4) size_char;<a name="l00298"></a>00298     }<a name="l00299"></a>00299 <a name="l00300"></a>00300     <span class="keywordflow">else</span><a name="l00301"></a>00301 <a name="l00302"></a>00302 <span class="preprocessor">#endif</span><a name="l00303"></a>00303 <span class="preprocessor"></span><a name="l00304"></a>00304     {<a name="l00305"></a>00305         ub4 offset = (ub4) lob-&gt;<a class="code" href="struct_o_c_i___lob.html#a2b896dd50cda4d2b8952deccacdc030">offset</a>;<a name="l00306"></a>00306 <a name="l00307"></a>00307         OCI_CALL2<a name="l00308"></a>00308         (<a name="l00309"></a>00309             res, lob-&gt;<a class="code" href="struct_o_c_i___lob.html#17646b1cc70c0c914ecb28849333fa65">con</a>, <a name="l00310"></a>00310             <a name="l00311"></a>00311             OCILobRead(lob-&gt;<a class="code" href="struct_o_c_i___lob.html#17646b1cc70c0c914ecb28849333fa65">con</a>-&gt;<a class="code" href="struct_o_c_i___connection.html#f20d1bea40e79481aeece933a4c70898">cxt</a>, lob-&gt;<a class="code" href="struct_o_c_i___lob.html#17646b1cc70c0c914ecb28849333fa65">con</a>-&gt;<a class="code" href="struct_o_c_i___connection.html#573a359867139990b1b0f50aa7a86175">err</a>,<a name="l00312"></a>00312                        lob-&gt;<a class="code" href="struct_o_c_i___lob.html#bd1e86de291b7773f17282a1e9f79bd6">handle</a>,  &amp;size_out, offset,<a name="l00313"></a>00313                        buffer, size_in, (<span class="keywordtype">void</span> *) NULL,<a name="l00314"></a>00314                        NULL, csid, csfrm)<a name="l00315"></a>00315         )<a name="l00316"></a>00316     }<a name="l00317"></a>00317 <a name="l00318"></a>00318     <span class="keywordflow">if</span> (res == TRUE)<a name="l00319"></a>00319     {<a name="l00320"></a>00320         <span class="keywordflow">if</span> (lob-&gt;<a class="code" href="struct_o_c_i___lob.html#f9e973d2ab2c1ec747e9e219f5ca7ba6">type</a> != OCI_BLOB)<a name="l00321"></a>00321             OCI_ConvertString(buffer, (<span class="keywordtype">int</span>) size_out, <span class="keyword">sizeof</span>(odtext), <span class="keyword">sizeof</span>(dtext));<a name="l00322"></a>00322         <a name="l00323"></a>00323         lob-&gt;<a class="code" href="struct_o_c_i___lob.html#a2b896dd50cda4d2b8952deccacdc030">offset</a> += (big_uint) size_out;<a name="l00324"></a>00324     }<a name="l00325"></a>00325 <a name="l00326"></a>00326     OCI_RESULT(res);<a name="l00327"></a>00327 <a name="l00328"></a>00328     <span class="keywordflow">return</span> size_out;<a name="l00329"></a>00329 }<a name="l00330"></a>00330 <a name="l00331"></a>00331 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00332"></a>00332 <span class="comment"> * OCI_LobWrite</span><a name="l00333"></a>00333 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00334"></a>00334 <a name="l00335"></a><a class="code" href="group__g__lob.html#g949f7050609430486c9ef0f3c488d38a">00335</a> <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> OCI_API <a class="code" href="group__g__lob.html#g949f7050609430486c9ef0f3c488d38a" title="Write a buffer into a LOB.">OCI_LobWrite</a>(<a class="code" href="struct_o_c_i___lob.html" title="Oracle Internal Large objects :.">OCI_Lob</a> *lob, <span class="keywordtype">void</span> *buffer, <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> len)<a name="l00336"></a>00336 {<a name="l00337"></a>00337     <span class="keywordtype">boolean</span> res  = TRUE;<a name="l00338"></a>00338     ub4 size_in  = 0;<a name="l00339"></a>00339     ub4 size_out = 0;<a name="l00340"></a>00340     ub2 csid     = 0;<a name="l00341"></a>00341     ub1 csfrm    = 0;<a name="l00342"></a>00342     <span class="keywordtype">void</span> *obuf   = NULL;<a name="l00343"></a>00343 <a name="l00344"></a>00344     OCI_CHECK_PTR(OCI_IPC_LOB, lob, 0);<a name="l00345"></a>00345 <a name="l00346"></a>00346     size_out = size_in = len;<a name="l00347"></a>00347     <a name="l00348"></a>00348     <span class="keywordflow">if</span> (lob-&gt;<a class="code" href="struct_o_c_i___lob.html#f9e973d2ab2c1ec747e9e219f5ca7ba6">type</a> != OCI_BLOB)<a name="l00349"></a>00349     {<a name="l00350"></a>00350 <a name="l00351"></a>00351 <span class="preprocessor">#ifndef OCI_CHARSET_ANSI</span><a name="l00352"></a>00352 <span class="preprocessor"></span><a name="l00353"></a>00353         csid = OCI_UTF16ID;<a name="l00354"></a>00354 <a name="l00355"></a>00355 <span class="preprocessor">#endif</span><a name="l00356"></a>00356 <span class="preprocessor"></span><a name="l00357"></a>00357         size_in *= <span class="keyword">sizeof</span>(dtext);<a name="l00358"></a>00358         obuf     = OCI_GetInputDataString(buffer, (<span class="keywordtype">int</span> *) &amp;size_in);<a name="l00359"></a>00359     }<a name="l00360"></a>00360     <span class="keywordflow">else</span><a name="l00361"></a>00361         obuf = buffer;<a name="l00362"></a>00362 <a name="l00363"></a>00363     <span class="keywordflow">if</span> (lob-&gt;<a class="code" href="struct_o_c_i___lob.html#f9e973d2ab2c1ec747e9e219f5ca7ba6">type</a> == OCI_NCLOB)<a name="l00364"></a>00364         csfrm = SQLCS_NCHAR;<a name="l00365"></a>00365     <span class="keywordflow">else</span><a name="l00366"></a>00366         csfrm = SQLCS_IMPLICIT;<a name="l00367"></a>00367 <a name="l00368"></a>00368 <span class="preprocessor">#ifdef OCI_LOB2_API_ENABLED</span><a name="l00369"></a>00369 <span class="preprocessor"></span><a name="l00370"></a>00370     <span class="keywordflow">if</span> (OCILib.use_lob_ub8)<a name="l00371"></a>00371     {<a name="l00372"></a>00372         ub8 size_char = (ub8) len;<a name="l00373"></a>00373         ub8 size_byte = (ub8) size_in;<a name="l00374"></a>00374         <a name="l00375"></a>00375         OCI_CALL2<a name="l00376"></a>00376         (<a name="l00377"></a>00377             res, lob-&gt;<a class="code" href="struct_o_c_i___lob.html#17646b1cc70c0c914ecb28849333fa65">con</a>, <a name="l00378"></a>00378             <a name="l00379"></a>00379             OCILobWrite2(lob-&gt;<a class="code" href="struct_o_c_i___lob.html#17646b1cc70c0c914ecb28849333fa65">con</a>-&gt;<a class="code" href="struct_o_c_i___connection.html#f20d1bea40e79481aeece933a4c70898">cxt</a>, lob-&gt;<a class="code" href="struct_o_c_i___lob.html#17646b1cc70c0c914ecb28849333fa65">con</a>-&gt;<a class="code" href="struct_o_c_i___connection.html#573a359867139990b1b0f50aa7a86175">err</a>, <a name="l00380"></a>00380                          lob-&gt;<a class="code" href="struct_o_c_i___lob.html#bd1e86de291b7773f17282a1e9f79bd6">handle</a>, &amp;size_byte,<a name="l00381"></a>00381                          &amp;size_char, (ub8) lob-&gt;<a class="code" href="struct_o_c_i___lob.html#a2b896dd50cda4d2b8952deccacdc030">offset</a>, <a name="l00382"></a>00382                          obuf, (ub8) size_in,<a name="l00383"></a>00383                          (ub1) OCI_ONE_PIECE, (<span class="keywordtype">void</span> *) NULL,<a name="l00384"></a>00384                          NULL , csid, csfrm)<a name="l00385"></a>00385         )<a name="l00386"></a>00386 <a name="l00387"></a>00387         <span class="keywordflow">if</span> (lob-&gt;<a class="code" href="struct_o_c_i___lob.html#f9e973d2ab2c1ec747e9e219f5ca7ba6">type</a> == OCI_BLOB)<a name="l00388"></a>00388             size_out = (ub4) size_byte;<a name="l00389"></a>00389         <span class="keywordflow">else</span><a name="l00390"></a>00390             size_out = (ub4) size_char;<a name="l00391"></a>00391     }<a name="l00392"></a>00392 <a name="l00393"></a>00393     <span class="keywordflow">else</span><a name="l00394"></a>00394 <a name="l00395"></a>00395 <span class="preprocessor">#endif</span><a name="l00396"></a>00396 <span class="preprocessor"></span><a name="l00397"></a>00397     {<a name="l00398"></a>00398         ub4 offset = (ub4) lob-&gt;<a class="code" href="struct_o_c_i___lob.html#a2b896dd50cda4d2b8952deccacdc030">offset</a>;<a name="l00399"></a>00399    <a name="l00400"></a>00400         OCI_CALL2<a name="l00401"></a>00401         (<a name="l00402"></a>00402             res, lob-&gt;<a class="code" href="struct_o_c_i___lob.html#17646b1cc70c0c914ecb28849333fa65">con</a>, <a name="l00403"></a>00403             <a name="l00404"></a>00404             OCILobWrite(lob-&gt;<a class="code" href="struct_o_c_i___lob.html#17646b1cc70c0c914ecb28849333fa65">con</a>-&gt;<a class="code" href="struct_o_c_i___connection.html#f20d1bea40e79481aeece933a4c70898">cxt</a>, lob-&gt;<a class="code" href="struct_o_c_i___lob.html#17646b1cc70c0c914ecb28849333fa65">con</a>-&gt;<a class="code" href="struct_o_c_i___connection.html#573a359867139990b1b0f50aa7a86175">err</a>,<a name="l00405"></a>00405                         lob-&gt;<a class="code" href="struct_o_c_i___lob.html#bd1e86de291b7773f17282a1e9f79bd6">handle</a>, &amp;size_out,<a name="l00406"></a>00406                         offset, obuf, size_in, <a name="l00407"></a>00407                         (ub1) OCI_ONE_PIECE, (<span class="keywordtype">void</span> *) NULL, <a name="l00408"></a>00408                         NULL, csid, csfrm)<a name="l00409"></a>00409         )<a name="l00410"></a>00410     }<a name="l00411"></a>00411 <a name="l00412"></a>00412     <span class="keywordflow">if</span> (lob-&gt;<a class="code" href="struct_o_c_i___lob.html#f9e973d2ab2c1ec747e9e219f5ca7ba6">type</a> != OCI_BLOB)<a name="l00413"></a>00413         OCI_ReleaseDataString(obuf);<a name="l00414"></a>00414 <a name="l00415"></a>00415     <span class="keywordflow">if</span> (res == TRUE)<a name="l00416"></a>00416         lob-&gt;<a class="code" href="struct_o_c_i___lob.html#a2b896dd50cda4d2b8952deccacdc030">offset</a> += (big_uint) size_out;<a name="l00417"></a>00417 <a name="l00418"></a>00418     OCI_RESULT(res);<a name="l00419"></a>00419 <a name="l00420"></a>00420     <span class="keywordflow">return</span> size_out;<a name="l00421"></a>00421 }<a name="l00422"></a>00422 <a name="l00423"></a>00423 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00424"></a>00424 <span class="comment"> * OCI_LobTruncate</span><a name="l00425"></a>00425 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00426"></a>00426 <a name="l00427"></a><a class="code" href="group__g__lob.html#g75a8049251e51665b3103789573a3a3b">00427</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__lob.html#g75a8049251e51665b3103789573a3a3b" title="Truncate the given lob to a shorter length.">OCI_LobTruncate</a>(<a class="code" href="struct_o_c_i___lob.html" title="Oracle Internal Large objects :.">OCI_Lob</a> *lob, big_uint size)<a name="l00428"></a>00428 {<a name="l00429"></a>00429     <span class="keywordtype">boolean</span> res = TRUE;<a name="l00430"></a>00430 <a name="l00431"></a>00431     OCI_CHECK_PTR(OCI_IPC_LOB, lob, FALSE);<a name="l00432"></a>00432 

⌨️ 快捷键说明

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