📄 column_8c-source.html
字号:
<a name="l00276"></a>00276 <a name="l00277"></a>00277 <span class="keywordflow">if</span> (tmp != NULL)<a name="l00278"></a>00278 {<a name="l00279"></a>00279 OCI_CopyString(ostr, tmp, &osize, <span class="keyword">sizeof</span>(omtext), <span class="keyword">sizeof</span>(mtext));<a name="l00280"></a>00280 col-><a class="code" href="struct_o_c_i___column.html#a01d51754a48d80bf033b589b6127781">nty</a> = <a class="code" href="group__g__desc.html#gba23217d4a9477dc1c373b7392bd15de" title="Retrieve the available schema information.">OCI_SchemaGet</a>(con, tmp, OCI_SCHEMA_TYPE);<a name="l00281"></a>00281 }<a name="l00282"></a>00282 <a name="l00283"></a>00283 res = (col-><a class="code" href="struct_o_c_i___column.html#a01d51754a48d80bf033b589b6127781">nty</a> != NULL);<a name="l00284"></a>00284 <a name="l00285"></a>00285 OCI_FREE(tmp);<a name="l00286"></a>00286 }<a name="l00287"></a>00287 }<a name="l00288"></a>00288 <a name="l00289"></a>00289 <span class="keywordflow">return</span> res;<a name="l00290"></a>00290 }<a name="l00291"></a>00291 <a name="l00292"></a>00292 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00293"></a>00293 <span class="comment"> * OCI_ColumnMap</span><a name="l00294"></a>00294 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00295"></a>00295 <a name="l00296"></a>00296 <span class="keywordtype">boolean</span> OCI_ColumnMap(<a class="code" href="struct_o_c_i___column.html" title="Oracle SQL Column and Type member representation.">OCI_Column</a> *col, <a class="code" href="struct_o_c_i___statement.html" title="Oracle SQL or PL/SQL statement.">OCI_Statement</a> *stmt)<a name="l00297"></a>00297 {<a name="l00298"></a>00298 <span class="keywordtype">boolean</span> res = TRUE;<a name="l00299"></a>00299 <a name="l00300"></a>00300 OCI_CHECK(col == NULL, FALSE);<a name="l00301"></a>00301 <a name="l00302"></a>00302 <span class="comment">/* map Oracle SQL code to OCILIB types and setup of internal buffer size */</span><a name="l00303"></a>00303 <a name="l00304"></a>00304 col-><a class="code" href="struct_o_c_i___column.html#ad9396e5095db31c838023313a41569e">icode</a> = col-><a class="code" href="struct_o_c_i___column.html#ecb72443546a3c89b21c3cde379210a9">ocode</a>;<a name="l00305"></a>00305 <a name="l00306"></a>00306 <span class="keywordflow">switch</span> (col-><a class="code" href="struct_o_c_i___column.html#ad9396e5095db31c838023313a41569e">icode</a>)<a name="l00307"></a>00307 {<a name="l00308"></a>00308 <span class="keywordflow">case</span> SQLT_INT:<a name="l00309"></a>00309 <a name="l00310"></a>00310 col-><a class="code" href="struct_o_c_i___column.html#93bfdf4f9926d4680f93356402177110">type</a> = OCI_CDT_NUMERIC;<a name="l00311"></a>00311 <a name="l00312"></a>00312 <span class="comment">/* set bufsize only if it's not a "returning into" placeholder */</span><a name="l00313"></a>00313 <a name="l00314"></a>00314 <span class="keywordflow">if</span> (col-><a class="code" href="struct_o_c_i___column.html#e0216bd7ecc0517de0fa5dc56980bf1e">bufsize</a> == 0) <a name="l00315"></a>00315 {<a name="l00316"></a>00316 col-><a class="code" href="struct_o_c_i___column.html#e1fb2448942e7ee1c3fa23662612f1e6">subtype</a> = OCI_NUM_INT;<a name="l00317"></a>00317 col-><a class="code" href="struct_o_c_i___column.html#e0216bd7ecc0517de0fa5dc56980bf1e">bufsize</a> = <span class="keyword">sizeof</span>(int);<a name="l00318"></a>00318 }<a name="l00319"></a>00319 <a name="l00320"></a>00320 <span class="keywordflow">break</span>;<a name="l00321"></a>00321 <a name="l00322"></a>00322 <span class="keywordflow">case</span> SQLT_UIN:<a name="l00323"></a>00323 <a name="l00324"></a>00324 col-><a class="code" href="struct_o_c_i___column.html#93bfdf4f9926d4680f93356402177110">type</a> = OCI_CDT_NUMERIC;<a name="l00325"></a>00325 <a name="l00326"></a>00326 <span class="comment">/* set bufsize only if it's not a "returning into" placeholder */</span><a name="l00327"></a>00327 <a name="l00328"></a>00328 <span class="keywordflow">if</span> (col-><a class="code" href="struct_o_c_i___column.html#e0216bd7ecc0517de0fa5dc56980bf1e">bufsize</a> == 0) <a name="l00329"></a>00329 {<a name="l00330"></a>00330 col-><a class="code" href="struct_o_c_i___column.html#e1fb2448942e7ee1c3fa23662612f1e6">subtype</a> = OCI_NUM_UINT;<a name="l00331"></a>00331 col-><a class="code" href="struct_o_c_i___column.html#e0216bd7ecc0517de0fa5dc56980bf1e">bufsize</a> = <span class="keyword">sizeof</span>(<span class="keywordtype">unsigned</span> int);<a name="l00332"></a>00332 }<a name="l00333"></a>00333 <a name="l00334"></a>00334 <span class="keywordflow">break</span>;<a name="l00335"></a>00335 <a name="l00336"></a>00336 <span class="keywordflow">case</span> SQLT_FLT:<a name="l00337"></a>00337 <span class="keywordflow">case</span> SQLT_VNU:<a name="l00338"></a>00338 <span class="keywordflow">case</span> SQLT_PDN:<a name="l00339"></a>00339 <span class="keywordflow">case</span> SQLT_NUM:<a name="l00340"></a>00340 <a name="l00341"></a>00341 <span class="preprocessor">#if OCI_VERSION_COMPILE >= OCI_10</span><a name="l00342"></a>00342 <span class="preprocessor"></span><a name="l00343"></a>00343 <span class="keywordflow">case</span> SQLT_BFLOAT:<a name="l00344"></a>00344 <span class="keywordflow">case</span> SQLT_BDOUBLE:<a name="l00345"></a>00345 <span class="keywordflow">case</span> SQLT_IBFLOAT:<a name="l00346"></a>00346 <span class="keywordflow">case</span> SQLT_IBDOUBLE:<a name="l00347"></a>00347 <a name="l00348"></a>00348 <span class="preprocessor">#endif </span><a name="l00349"></a>00349 <span class="preprocessor"></span> col-><a class="code" href="struct_o_c_i___column.html#93bfdf4f9926d4680f93356402177110">type</a> = OCI_CDT_NUMERIC;<a name="l00350"></a>00350 col-><a class="code" href="struct_o_c_i___column.html#e1fb2448942e7ee1c3fa23662612f1e6">subtype</a> = OCI_NUM_NUMBER;<a name="l00351"></a>00351 col-><a class="code" href="struct_o_c_i___column.html#ad9396e5095db31c838023313a41569e">icode</a> = SQLT_VNU;<a name="l00352"></a>00352 col-><a class="code" href="struct_o_c_i___column.html#e0216bd7ecc0517de0fa5dc56980bf1e">bufsize</a> = <span class="keyword">sizeof</span>(OCINumber);<a name="l00353"></a>00353 <a name="l00354"></a>00354 <span class="keywordflow">break</span>;<a name="l00355"></a>00355 <a name="l00356"></a>00356 <span class="keywordflow">case</span> SQLT_DAT:<a name="l00357"></a>00357 <span class="keywordflow">case</span> SQLT_ODT:<a name="l00358"></a>00358 <a name="l00359"></a>00359 col-><a class="code" href="struct_o_c_i___column.html#93bfdf4f9926d4680f93356402177110">type</a> = OCI_CDT_DATETIME;<a name="l00360"></a>00360 <a name="l00361"></a>00361 <span class="comment">/* We map to SQLT_ODT only it the column is not part of a </span><a name="l00362"></a>00362 <span class="comment"> "returning into" clause (workaround for Oracle </span><a name="l00363"></a>00363 <span class="comment"> known bug #3269146 </span><a name="l00364"></a>00364 <span class="comment"> */</span><a name="l00365"></a>00365 <a name="l00366"></a>00366 <span class="keywordflow">if</span> (col-><a class="code" href="struct_o_c_i___column.html#e0216bd7ecc0517de0fa5dc56980bf1e">bufsize</a> == 0)<a name="l00367"></a>00367 {<a name="l00368"></a>00368 col-><a class="code" href="struct_o_c_i___column.html#ad9396e5095db31c838023313a41569e">icode</a> = SQLT_ODT;<a name="l00369"></a>00369 col-><a class="code" href="struct_o_c_i___column.html#e0216bd7ecc0517de0fa5dc56980bf1e">bufsize</a> = <span class="keyword">sizeof</span>(OCIDate);<a name="l00370"></a>00370 }<a name="l00371"></a>00371 <a name="l00372"></a>00372 <span class="keywordflow">break</span>;<a name="l00373"></a>00373 <a name="l00374"></a>00374 <span class="keywordflow">case</span> SQLT_CUR:<a name="l00375"></a>00375 <span class="keywordflow">case</span> SQLT_RSET:<a name="l00376"></a>00376 <a name="l00377"></a>00377 col-><a class="code" href="struct_o_c_i___column.html#93bfdf4f9926d4680f93356402177110">type</a> = OCI_CDT_CURSOR;<a name="l00378"></a>00378 col-><a class="code" href="struct_o_c_i___column.html#e0216bd7ecc0517de0fa5dc56980bf1e">bufsize</a> = <span class="keyword">sizeof</span>(OCIStmt *);<a name="l00379"></a>00379 col-><a class="code" href="struct_o_c_i___column.html#4e4d9b8118c5d80364adfedcc97c0640">dtype</a> = OCI_HTYPE_STMT;<a name="l00380"></a>00380 <span class="keywordflow">break</span>;<a name="l00381"></a>00381 <a name="l00382"></a>00382 <span class="keywordflow">case</span> SQLT_RDD:<a name="l00383"></a>00383 <span class="keywordflow">case</span> SQLT_RID:<a name="l00384"></a>00384 <a name="l00385"></a>00385 col-><a class="code" href="struct_o_c_i___column.html#ad9396e5095db31c838023313a41569e">icode</a> = SQLT_STR;<a name="l00386"></a>00386 col-><a class="code" href="struct_o_c_i___column.html#93bfdf4f9926d4680f93356402177110">type</a> = OCI_CDT_TEXT;<a name="l00387"></a>00387 col-><a class="code" href="struct_o_c_i___column.html#e0216bd7ecc0517de0fa5dc56980bf1e">bufsize</a> = (OCI_SIZE_ROWID+1) * <span class="keyword">sizeof</span>(dtext);<a name="l00388"></a>00388 <span class="keywordflow">break</span>;<a name="l00389"></a>00389 <a name="l00390"></a>00390 <span class="keywordflow">case</span> SQLT_BIN:<a name="l00391"></a>00391 <a name="l00392"></a>00392 col-><a class="code" href="struct_o_c_i___column.html#93bfdf4f9926d4680f93356402177110">type</a> = OCI_CDT_RAW;<a name="l00393"></a>00393 col-><a class="code" href="struct_o_c_i___column.html#e0216bd7ecc0517de0fa5dc56980bf1e">bufsize</a> = col-><a class="code" href="struct_o_c_i___column.html#e9713aae44e3fcf85987ffe8732bd72e">size</a> + <span class="keyword">sizeof</span>(dtext); <span class="comment">/* for string conversion */</span><a name="l00394"></a>00394 <span class="keywordflow">break</span>;<a name="l00395"></a>00395 <a name="l00396"></a>00396 <span class="keywordflow">case</span> SQLT_BLOB:<a name="l00397"></a>00397 <a name="l00398"></a>00398 col-><a class="code" href="struct_o_c_i___column.html#93bfdf4f9926d4680f93356402177110">type</a> = OCI_CDT_LOB;<a name="l00399"></a>00399 col-><a class="code" href="struct_o_c_i___column.html#e1fb2448942e7ee1c3fa23662612f1e6">subtype</a> = OCI_BLOB;<a name="l00400"></a>00400 col-><a class="code" href="struct_o_c_i___column.html#4e4d9b8118c5d80364adfedcc97c0640">dtype</a> = OCI_DTYPE_LOB;<a name="l00401"></a>00401 col-><a class="code" href="struct_o_c_i___column.html#e0216bd7ecc0517de0fa5dc56980bf1e">bufsize</a> = <span class="keyword">sizeof</span>(OCILobLocator *);<a name="l00402"></a>00402 <span class="keywordflow">break</span>;<a name="l00403"></a>00403 <a name="l00404"></a>00404 <span class="keywordflow">case</span> SQLT_CLOB:<a name="l00405"></a>00405 <a name="l00406"></a>00406 col-><a class="code" href="struct_o_c_i___column.html#93bfdf4f9926d4680f93356402177110">type</a> = OCI_CDT_LOB;<a name="l00407"></a>00407 col-><a class="code" href="struct_o_c_i___column.html#4e4d9b8118c5d80364adfedcc97c0640">dtype</a> = OCI_DTYPE_LOB;<a name="l00408"></a>00408 col-><a class="code" href="struct_o_c_i___column.html#e0216bd7ecc0517de0fa5dc56980bf1e">bufsize</a> = <span class="keyword">sizeof</span>(OCILobLocator *);<a name="l00409"></a>00409 <a name="l00410"></a>00410 <span class="keywordflow">if</span> (col-><a class="code" href="struct_o_c_i___column.html#2b00b782a51e4650747f053b6f75a591">csfrm</a> == SQLCS_NCHAR)<a name="l00411"></a>00411 col-><a class="code" href="struct_o_c_i___column.html#e1fb2448942e7ee1c3fa23662612f1e6">subtype</a> = OCI_NCLOB;<a name="l00412"></a>00412 <span class="keywordflow">else</span><a name="l00413"></a>00413 col-><a class="code" href="struct_o_c_i___column.html#e1fb2448942e7ee1c3fa23662612f1e6">subtype</a> = OCI_CLOB;<a name="l00414"></a>00414 <a name="l00415"></a>00415 <span class="keywordflow">break</span>;<a name="l00416"></a>00416 <a name="l00417"></a>00417 <span class="keywordflow">case</span> SQLT_BFILE:<a name="l00418"></a>00418 <a name="l00419"></a>00419 col-><a class="code" href="struct_o_c_i___column.html#93bfdf4f9926d4680f93356402177110">type</a> = OCI_CDT_FILE;<a name="l00420"></a>00420 col-><a class="code" href="struct_o_c_i___column.html#e1fb2448942e7ee1c3fa23662612f1e6">subtype</a> = OCI_BFILE;⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -