📄 column_8c-source.html
字号:
<a name="l00421"></a>00421 col-><a class="code" href="struct_o_c_i___column.html#4e4d9b8118c5d80364adfedcc97c0640">dtype</a> = OCI_DTYPE_LOB;<a name="l00422"></a>00422 col-><a class="code" href="struct_o_c_i___column.html#e0216bd7ecc0517de0fa5dc56980bf1e">bufsize</a> = <span class="keyword">sizeof</span>(OCILobLocator *);<a name="l00423"></a>00423 <span class="keywordflow">break</span>;<a name="l00424"></a>00424 <a name="l00425"></a>00425 <span class="keywordflow">case</span> SQLT_CFILE:<a name="l00426"></a>00426 <a name="l00427"></a>00427 col-><a class="code" href="struct_o_c_i___column.html#93bfdf4f9926d4680f93356402177110">type</a> = OCI_CDT_FILE;<a name="l00428"></a>00428 col-><a class="code" href="struct_o_c_i___column.html#e1fb2448942e7ee1c3fa23662612f1e6">subtype</a> = OCI_CFILE;<a name="l00429"></a>00429 col-><a class="code" href="struct_o_c_i___column.html#e0216bd7ecc0517de0fa5dc56980bf1e">bufsize</a> = <span class="keyword">sizeof</span>(OCILobLocator *);<a name="l00430"></a>00430 col-><a class="code" href="struct_o_c_i___column.html#4e4d9b8118c5d80364adfedcc97c0640">dtype</a> = OCI_DTYPE_LOB;<a name="l00431"></a>00431 <span class="keywordflow">break</span>;<a name="l00432"></a>00432 <a name="l00433"></a>00433 <span class="keywordflow">case</span> SQLT_LNG:<a name="l00434"></a>00434 <span class="keywordflow">case</span> SQLT_LVC:<a name="l00435"></a>00435 <span class="keywordflow">case</span> SQLT_LBI:<a name="l00436"></a>00436 <span class="keywordflow">case</span> SQLT_LVB:<a name="l00437"></a>00437 <span class="keywordflow">case</span> SQLT_VBI:<a name="l00438"></a>00438 <a name="l00439"></a>00439 <span class="keywordflow">if</span> ((col-><a class="code" href="struct_o_c_i___column.html#ad9396e5095db31c838023313a41569e">icode</a> == SQLT_LNG || col-><a class="code" href="struct_o_c_i___column.html#ad9396e5095db31c838023313a41569e">icode</a> == SQLT_LVC) &&<a name="l00440"></a>00440 (stmt != NULL && stmt-><a class="code" href="struct_o_c_i___statement.html#fa936eb0965544887f062e79bdc8e52c">long_mode</a> == OCI_LONG_IMPLICIT))<a name="l00441"></a>00441 {<a name="l00442"></a>00442 col-><a class="code" href="struct_o_c_i___column.html#93bfdf4f9926d4680f93356402177110">type</a> = OCI_CDT_TEXT;<a name="l00443"></a>00443 col-><a class="code" href="struct_o_c_i___column.html#e0216bd7ecc0517de0fa5dc56980bf1e">bufsize</a> = (OCI_SIZE_LONG+1);<a name="l00444"></a>00444 col-><a class="code" href="struct_o_c_i___column.html#e1fb2448942e7ee1c3fa23662612f1e6">subtype</a> = OCI_CLONG;<a name="l00445"></a>00445 }<a name="l00446"></a>00446 <span class="keywordflow">else</span><a name="l00447"></a>00447 {<a name="l00448"></a>00448 col-><a class="code" href="struct_o_c_i___column.html#93bfdf4f9926d4680f93356402177110">type</a> = OCI_CDT_LONG;<a name="l00449"></a>00449 col-><a class="code" href="struct_o_c_i___column.html#e0216bd7ecc0517de0fa5dc56980bf1e">bufsize</a> = INT_MAX;<a name="l00450"></a>00450 <a name="l00451"></a>00451 <span class="keywordflow">if</span> (col-><a class="code" href="struct_o_c_i___column.html#ad9396e5095db31c838023313a41569e">icode</a> == SQLT_LBI ||<a name="l00452"></a>00452 col-><a class="code" href="struct_o_c_i___column.html#ad9396e5095db31c838023313a41569e">icode</a> == SQLT_LVB ||<a name="l00453"></a>00453 col-><a class="code" href="struct_o_c_i___column.html#ad9396e5095db31c838023313a41569e">icode</a> == SQLT_VBI)<a name="l00454"></a>00454 {<a name="l00455"></a>00455 col-><a class="code" href="struct_o_c_i___column.html#e1fb2448942e7ee1c3fa23662612f1e6">subtype</a> = OCI_BLONG;<a name="l00456"></a>00456 }<a name="l00457"></a>00457 <span class="keywordflow">else</span><a name="l00458"></a>00458 {<a name="l00459"></a>00459 col-><a class="code" href="struct_o_c_i___column.html#e1fb2448942e7ee1c3fa23662612f1e6">subtype</a> = OCI_CLONG;<a name="l00460"></a>00460 }<a name="l00461"></a>00461 <a name="l00462"></a>00462 }<a name="l00463"></a>00463 <a name="l00464"></a>00464 <span class="keywordflow">break</span>;<a name="l00465"></a>00465 <a name="l00466"></a>00466 <span class="preprocessor">#if OCI_VERSION_COMPILE >= OCI_9</span><a name="l00467"></a>00467 <span class="preprocessor"></span><a name="l00468"></a>00468 <span class="keywordflow">case</span> SQLT_TIMESTAMP:<a name="l00469"></a>00469 <a name="l00470"></a>00470 col-><a class="code" href="struct_o_c_i___column.html#93bfdf4f9926d4680f93356402177110">type</a> = OCI_CDT_TIMESTAMP;<a name="l00471"></a>00471 col-><a class="code" href="struct_o_c_i___column.html#e1fb2448942e7ee1c3fa23662612f1e6">subtype</a> = OCI_TIMESTAMP;<a name="l00472"></a>00472 col-><a class="code" href="struct_o_c_i___column.html#4e4d9b8118c5d80364adfedcc97c0640">dtype</a> = OCI_DTYPE_TIMESTAMP;<a name="l00473"></a>00473 col-><a class="code" href="struct_o_c_i___column.html#e0216bd7ecc0517de0fa5dc56980bf1e">bufsize</a> = <span class="keyword">sizeof</span>(OCIDateTime *);<a name="l00474"></a>00474 <span class="keywordflow">break</span>;<a name="l00475"></a>00475 <a name="l00476"></a>00476 <span class="keywordflow">case</span> SQLT_TIMESTAMP_TZ:<a name="l00477"></a>00477 <a name="l00478"></a>00478 col-><a class="code" href="struct_o_c_i___column.html#93bfdf4f9926d4680f93356402177110">type</a> = OCI_CDT_TIMESTAMP;<a name="l00479"></a>00479 col-><a class="code" href="struct_o_c_i___column.html#e1fb2448942e7ee1c3fa23662612f1e6">subtype</a> = OCI_TIMESTAMP_TZ;<a name="l00480"></a>00480 col-><a class="code" href="struct_o_c_i___column.html#4e4d9b8118c5d80364adfedcc97c0640">dtype</a> = OCI_DTYPE_TIMESTAMP_TZ;<a name="l00481"></a>00481 col-><a class="code" href="struct_o_c_i___column.html#e0216bd7ecc0517de0fa5dc56980bf1e">bufsize</a> = <span class="keyword">sizeof</span>(OCIDateTime *);<a name="l00482"></a>00482 <span class="keywordflow">break</span>;<a name="l00483"></a>00483 <a name="l00484"></a>00484 <span class="keywordflow">case</span> SQLT_TIMESTAMP_LTZ:<a name="l00485"></a>00485 <a name="l00486"></a>00486 col-><a class="code" href="struct_o_c_i___column.html#93bfdf4f9926d4680f93356402177110">type</a> = OCI_CDT_TIMESTAMP;<a name="l00487"></a>00487 col-><a class="code" href="struct_o_c_i___column.html#e1fb2448942e7ee1c3fa23662612f1e6">subtype</a> = OCI_TIMESTAMP_LTZ;<a name="l00488"></a>00488 col-><a class="code" href="struct_o_c_i___column.html#4e4d9b8118c5d80364adfedcc97c0640">dtype</a> = OCI_DTYPE_TIMESTAMP_LTZ;<a name="l00489"></a>00489 col-><a class="code" href="struct_o_c_i___column.html#e0216bd7ecc0517de0fa5dc56980bf1e">bufsize</a> = <span class="keyword">sizeof</span>(OCIDateTime *);<a name="l00490"></a>00490 <span class="keywordflow">break</span>;<a name="l00491"></a>00491 <a name="l00492"></a>00492 <span class="keywordflow">case</span> SQLT_INTERVAL_YM:<a name="l00493"></a>00493 <a name="l00494"></a>00494 col-><a class="code" href="struct_o_c_i___column.html#93bfdf4f9926d4680f93356402177110">type</a> = OCI_CDT_INTERVAL;<a name="l00495"></a>00495 col-><a class="code" href="struct_o_c_i___column.html#e1fb2448942e7ee1c3fa23662612f1e6">subtype</a> = OCI_INTERVAL_YM;<a name="l00496"></a>00496 col-><a class="code" href="struct_o_c_i___column.html#4e4d9b8118c5d80364adfedcc97c0640">dtype</a> = OCI_DTYPE_INTERVAL_YM;<a name="l00497"></a>00497 col-><a class="code" href="struct_o_c_i___column.html#e0216bd7ecc0517de0fa5dc56980bf1e">bufsize</a> = <span class="keyword">sizeof</span>(OCIInterval *);<a name="l00498"></a>00498 <span class="keywordflow">break</span>;<a name="l00499"></a>00499 <a name="l00500"></a>00500 <span class="keywordflow">case</span> SQLT_INTERVAL_DS:<a name="l00501"></a>00501 <a name="l00502"></a>00502 col-><a class="code" href="struct_o_c_i___column.html#93bfdf4f9926d4680f93356402177110">type</a> = OCI_CDT_INTERVAL;<a name="l00503"></a>00503 col-><a class="code" href="struct_o_c_i___column.html#e1fb2448942e7ee1c3fa23662612f1e6">subtype</a> = OCI_INTERVAL_DS;<a name="l00504"></a>00504 col-><a class="code" href="struct_o_c_i___column.html#4e4d9b8118c5d80364adfedcc97c0640">dtype</a> = OCI_DTYPE_INTERVAL_DS;<a name="l00505"></a>00505 col-><a class="code" href="struct_o_c_i___column.html#e0216bd7ecc0517de0fa5dc56980bf1e">bufsize</a> = <span class="keyword">sizeof</span>(OCIInterval *);<a name="l00506"></a>00506 <span class="keywordflow">break</span>;<a name="l00507"></a>00507 <a name="l00508"></a>00508 <span class="preprocessor">#endif</span><a name="l00509"></a>00509 <span class="preprocessor"></span><a name="l00510"></a>00510 <span class="preprocessor">#if OCI_VERSION_COMPILE >= OCI_9</span><a name="l00511"></a>00511 <span class="preprocessor"></span><a name="l00512"></a>00512 <span class="keywordflow">case</span> SQLT_PNTY:<a name="l00513"></a>00513 <a name="l00514"></a>00514 <span class="preprocessor">#endif</span><a name="l00515"></a>00515 <span class="preprocessor"></span><a name="l00516"></a>00516 <span class="keywordflow">case</span> SQLT_NTY:<a name="l00517"></a>00517 {<a name="l00518"></a>00518 col-><a class="code" href="struct_o_c_i___column.html#ad9396e5095db31c838023313a41569e">icode</a> = SQLT_NTY;<a name="l00519"></a>00519 col-><a class="code" href="struct_o_c_i___column.html#e0216bd7ecc0517de0fa5dc56980bf1e">bufsize</a> = <span class="keyword">sizeof</span>(<span class="keywordtype">void</span> *);<a name="l00520"></a>00520 <a name="l00521"></a>00521 <span class="keywordflow">if</span> (col-><a class="code" href="struct_o_c_i___column.html#a01d51754a48d80bf033b589b6127781">nty</a>-><a class="code" href="struct_o_c_i___schema.html#5a708cca27609216634362d790e44791">tcode</a> == SQLT_NCO)<a name="l00522"></a>00522 col-><a class="code" href="struct_o_c_i___column.html#93bfdf4f9926d4680f93356402177110">type</a> = OCI_CDT_COLLECTION; <a name="l00523"></a>00523 <span class="keywordflow">else</span><a name="l00524"></a>00524 col-><a class="code" href="struct_o_c_i___column.html#93bfdf4f9926d4680f93356402177110">type</a> = OCI_CDT_OBJECT; <a name="l00525"></a>00525 <a name="l00526"></a>00526 <span class="keywordflow">break</span>;<a name="l00527"></a>00527 }<a name="l00528"></a>00528 <span class="keywordflow">case</span> SQLT_REF:<a name="l00529"></a>00529 <a name="l00530"></a>00530 <span class="comment">/* not supported datatypes */</span><a name="l00531"></a>00531 <a name="l00532"></a>00532 OCI_ExceptionNotSupported(stmt-><a class="code" href="struct_o_c_i___statement.html#338ddf58debd7de6ab9355f1e75d78f6">con</a>, stmt, col-><a class="code" href="struct_o_c_i___column.html#ecb72443546a3c89b21c3cde379210a9">ocode</a>);<a name="l00533"></a>00533 <a name="l00534"></a>00534 res = FALSE;<a name="l00535"></a>00535 <a name="l00536"></a>00536 <span class="keywordflow">case</span> SQLT_CHR:<a name="l00537"></a>00537 <span class="keywordflow">case</span> SQLT_STR:<a name="l00538"></a>00538 <span class="keywordflow">case</span> SQLT_VCS:<a name="l00539"></a>00539 <span class="keywordflow">case</span> SQLT_AFC:<a name="l00540"></a>00540 <span class="keywordflow">case</span> SQLT_AVC:<a name="l00541"></a>00541 <span class="keywordflow">case</span> SQLT_VST:<a name="l00542"></a>00542 <span class="keywordflow">case</span> SQLT_LAB:<a name="l00543"></a>00543 <span class="keywordflow">case</span> SQLT_OSL:<a name="l00544"></a>00544 <span class="keywordflow">case</span> SQLT_SLS:<a name="l00545"></a>00545 <span class="keywordflow">default</span>:<a name="l00546"></a>00546 <a name="l00547"></a>00547 col-><a class="code" href="struct_o_c_i___column.html#ad9396e5095db31c838023313a41569e">icode</a> = SQLT_STR;<a name="l00548"></a>00548 col-><a class="code" href="struct_o_c_i___column.html#93bfdf4f9926d4680f93356402177110">type</a> = OCI_CDT_TEXT;<a name="l00549"></a>00549 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> + 1) * <span class="keyword">sizeof</span>(dtext);<a name="l00550"></a>00550 <span class="keywordflow">break</span>;<a name="l00551"></a>00551 }<a name="l00552"></a>00552 <a name="l00553"></a>00553 <span class="keywordflow">return</span> res;<a name="l00554"></a>00554 }<a name="l00555"></a>00555 <a name="l00556"></a>00556 <span class="comment">/* ************************************************************************ *</span><a name="l00557"></a>00557 <span class="comment"> * PUBLIC FUNCTIONS</span><a name="l00558"></a>00558 <span class="comment"> * ************************************************************************ */</span><a name="l00559"></a>00559 <a name="l00560"></a>00560 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00561"></a>00561 <span class="comment"> * OCI_ColumnGetName</span><a name="l00562"></a>00562 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00563"></a>00563 <a name="l00564"></a><a class="code" href="group__g__fetch.html#gd22f87322cdb788a03a0c259ab126a94">00564</a> <span class="keyword">const</span> mtext * OCI_API <a class="code" href="group__g__fetch.html#gd22f87322cdb788a03a0c259ab126a94" title="Return the name of the given column.">OCI_ColumnGetName</a>(<a class="code" href="struct_o_c_i___column.html" title="Oracle SQL Column and Type member representation.">OCI_Column</a> *col)<a name="l00565"></a>00565 {⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -