📄 dirpath_8c-source.html
字号:
<a name="l00290"></a>00290 <span class="keywordflow">break</span>;<a name="l00291"></a>00291 <a name="l00292"></a>00292 <span class="keywordflow">case</span> OCI_CDT_NUMERIC :<a name="l00293"></a>00293 <a name="l00294"></a>00294 <span class="keywordflow">if</span> ((format != NULL) && (format[0] != 0))<a name="l00295"></a>00295 {<a name="l00296"></a>00296 dpcol->format = mtsdup(format);<a name="l00297"></a>00297 dpcol->format_size = (ub4) mtslen(format);<a name="l00298"></a>00298 dpcol->type = OCI_DDT_NUMBER;<a name="l00299"></a>00299 dpcol->sqlcode = SQLT_NUM;<a name="l00300"></a>00300 dpcol->bufsize = <span class="keyword">sizeof</span>(OCINumber);<a name="l00301"></a>00301 dpcol->maxsize = <span class="keyword">sizeof</span>(OCINumber);<a name="l00302"></a>00302 }<a name="l00303"></a>00303 <span class="keywordflow">else</span><a name="l00304"></a>00304 {<a name="l00305"></a>00305 dpcol->type = OCI_DDT_OTHERS;<a name="l00306"></a>00306 }<a name="l00307"></a>00307 <a name="l00308"></a>00308 <span class="keywordflow">break</span>;<a name="l00309"></a>00309 <a name="l00310"></a>00310 <span class="keywordflow">case</span> OCI_CDT_DATETIME :<a name="l00311"></a>00311 <span class="keywordflow">case</span> OCI_CDT_TIMESTAMP :<a name="l00312"></a>00312 <span class="keywordflow">case</span> OCI_CDT_INTERVAL :<a name="l00313"></a>00313 <a name="l00314"></a>00314 dpcol->type = OCI_DDT_OTHERS;<a name="l00315"></a>00315 <a name="l00316"></a>00316 <span class="keywordflow">if</span> ((format != NULL) && (format[0] != 0))<a name="l00317"></a>00317 {<a name="l00318"></a>00318 dpcol->format = mtsdup(format);<a name="l00319"></a>00319 dpcol->format_size = (ub4) mtslen(format);<a name="l00320"></a>00320 dpcol->maxsize = (ub2) dpcol->format_size;<a name="l00321"></a>00321 dpcol->bufsize *= <span class="keyword">sizeof</span>(dtext);<a name="l00322"></a>00322 }<a name="l00323"></a>00323 <a name="l00324"></a>00324 <span class="keywordflow">break</span>;<a name="l00325"></a>00325 <a name="l00326"></a>00326 <span class="keywordflow">case</span> OCI_CDT_LOB :<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#e1fb2448942e7ee1c3fa23662612f1e6">subtype</a> == OCI_BLOB)<a name="l00329"></a>00329 {<a name="l00330"></a>00330 dpcol->type = OCI_DDT_BINARY;<a name="l00331"></a>00331 dpcol->sqlcode = SQLT_BIN;<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> OCI_CDT_LONG :<a name="l00337"></a>00337 <a name="l00338"></a>00338 <span class="keywordflow">if</span> (col-><a class="code" href="struct_o_c_i___column.html#e1fb2448942e7ee1c3fa23662612f1e6">subtype</a> == OCI_BLONG)<a name="l00339"></a>00339 {<a name="l00340"></a>00340 dpcol->type = OCI_DDT_BINARY;<a name="l00341"></a>00341 dpcol->sqlcode = SQLT_BIN;<a name="l00342"></a>00342 }<a name="l00343"></a>00343 <a name="l00344"></a>00344 <span class="keywordflow">break</span>;<a name="l00345"></a>00345 <a name="l00346"></a>00346 <span class="keywordflow">case</span> OCI_CDT_RAW :<a name="l00347"></a>00347 <a name="l00348"></a>00348 dpcol->type = OCI_DDT_BINARY;<a name="l00349"></a>00349 dpcol->sqlcode = SQLT_BIN;<a name="l00350"></a>00350 <a name="l00351"></a>00351 <span class="keywordflow">break</span>;<a name="l00352"></a>00352 <a name="l00353"></a>00353 <span class="keywordflow">default</span> :<a name="l00354"></a>00354 <a name="l00355"></a>00355 res = FALSE;<a name="l00356"></a>00356 OCI_ExceptionDatatypeNotSupported(dp-><a class="code" href="struct_o_c_i___dir_path.html#52410868a337ad04434b1e11859a471b">con</a>, NULL, col-><a class="code" href="struct_o_c_i___column.html#ecb72443546a3c89b21c3cde379210a9">ocode</a>);<a name="l00357"></a>00357 <a name="l00358"></a>00358 <span class="keywordflow">break</span>;<a name="l00359"></a>00359 }<a name="l00360"></a>00360 }<a name="l00361"></a>00361 <a name="l00362"></a>00362 <span class="comment">/* if supported datatype, set direct path column attributes */</span><a name="l00363"></a>00363 <a name="l00364"></a>00364 <span class="keywordflow">if</span> (res == TRUE)<a name="l00365"></a>00365 {<a name="l00366"></a>00366 <span class="comment">/* get column parameter list handle */</span><a name="l00367"></a>00367 <a name="l00368"></a>00368 OCI_CALL2<a name="l00369"></a>00369 (<a name="l00370"></a>00370 res, dp-><a class="code" href="struct_o_c_i___dir_path.html#52410868a337ad04434b1e11859a471b">con</a>,<a name="l00371"></a>00371 <a name="l00372"></a>00372 OCIAttrGet(dp-><a class="code" href="struct_o_c_i___dir_path.html#18e800f3228194e47969ad7d6da19c32">ctx</a>, OCI_HTYPE_DIRPATH_CTX, &hlist,<a name="l00373"></a>00373 NULL, OCI_ATTR_LIST_COLUMNS, dp-><a class="code" href="struct_o_c_i___dir_path.html#52410868a337ad04434b1e11859a471b">con</a>-><a class="code" href="struct_o_c_i___connection.html#573a359867139990b1b0f50aa7a86175">err</a>)<a name="l00374"></a>00374 )<a name="l00375"></a>00375 <a name="l00376"></a>00376 <span class="comment">/* get colum attribute handle */</span><a name="l00377"></a>00377 <a name="l00378"></a>00378 OCI_CALL2<a name="l00379"></a>00379 (<a name="l00380"></a>00380 res, dp-><a class="code" href="struct_o_c_i___dir_path.html#52410868a337ad04434b1e11859a471b">con</a>,<a name="l00381"></a>00381 <a name="l00382"></a>00382 OCIParamGet((dvoid *) hlist, OCI_DTYPE_PARAM, dp-><a class="code" href="struct_o_c_i___dir_path.html#52410868a337ad04434b1e11859a471b">con</a>-><a class="code" href="struct_o_c_i___connection.html#573a359867139990b1b0f50aa7a86175">err</a>,<a name="l00383"></a>00383 (dvoid** ) (dvoid *) &hattr, (ub4) index)<a name="l00384"></a>00384 )<a name="l00385"></a>00385 <a name="l00386"></a>00386 <span class="comment">/* set column name */</span><a name="l00387"></a>00387 <a name="l00388"></a>00388 <span class="keywordflow">if</span> (res == TRUE)<a name="l00389"></a>00389 {<a name="l00390"></a>00390 osize = -1;<a name="l00391"></a>00391 ostr = OCI_GetInputMetaString(name, &osize);<a name="l00392"></a>00392 <a name="l00393"></a>00393 OCI_CALL2<a name="l00394"></a>00394 (<a name="l00395"></a>00395 res, dp-><a class="code" href="struct_o_c_i___dir_path.html#52410868a337ad04434b1e11859a471b">con</a>,<a name="l00396"></a>00396 <a name="l00397"></a>00397 OCIAttrSet((dvoid *) hattr, (ub4) OCI_DTYPE_PARAM,<a name="l00398"></a>00398 (dvoid *) ostr, (ub4) osize,<a name="l00399"></a>00399 (ub4) OCI_ATTR_NAME, dp-><a class="code" href="struct_o_c_i___dir_path.html#52410868a337ad04434b1e11859a471b">con</a>-><a class="code" href="struct_o_c_i___connection.html#573a359867139990b1b0f50aa7a86175">err</a>)<a name="l00400"></a>00400 )<a name="l00401"></a>00401 <a name="l00402"></a>00402 OCI_ReleaseMetaString(ostr);<a name="l00403"></a>00403 }<a name="l00404"></a>00404 <a name="l00405"></a>00405 <span class="comment">/* set column type */</span><a name="l00406"></a>00406 <a name="l00407"></a>00407 OCI_CALL2<a name="l00408"></a>00408 (<a name="l00409"></a>00409 res, dp-><a class="code" href="struct_o_c_i___dir_path.html#52410868a337ad04434b1e11859a471b">con</a>,<a name="l00410"></a>00410 <a name="l00411"></a>00411 OCIAttrSet((dvoid *) hattr, (ub4) OCI_DTYPE_PARAM,<a name="l00412"></a>00412 (dvoid *) &dpcol->sqlcode, <span class="keyword">sizeof</span>(dpcol->sqlcode),<a name="l00413"></a>00413 (ub4) OCI_ATTR_DATA_TYPE, dp-><a class="code" href="struct_o_c_i___dir_path.html#52410868a337ad04434b1e11859a471b">con</a>-><a class="code" href="struct_o_c_i___connection.html#573a359867139990b1b0f50aa7a86175">err</a>)<a name="l00414"></a>00414 )<a name="l00415"></a>00415 <a name="l00416"></a>00416 <span class="comment">/* set column size */</span><a name="l00417"></a>00417 <a name="l00418"></a>00418 OCI_CALL2<a name="l00419"></a>00419 (<a name="l00420"></a>00420 res, dp-><a class="code" href="struct_o_c_i___dir_path.html#52410868a337ad04434b1e11859a471b">con</a>,<a name="l00421"></a>00421 <a name="l00422"></a>00422 OCIAttrSet((dvoid *) hattr, (ub4) OCI_DTYPE_PARAM,<a name="l00423"></a>00423 (dvoid *) &dpcol->maxsize, <span class="keyword">sizeof</span>(dpcol->maxsize),<a name="l00424"></a>00424 (ub4) OCI_ATTR_DATA_SIZE, dp-><a class="code" href="struct_o_c_i___dir_path.html#52410868a337ad04434b1e11859a471b">con</a>-><a class="code" href="struct_o_c_i___connection.html#573a359867139990b1b0f50aa7a86175">err</a>)<a name="l00425"></a>00425 )<a name="l00426"></a>00426 <a name="l00427"></a>00427 <span class="comment">/* set column precision */</span><a name="l00428"></a>00428 <a name="l00429"></a>00429 <span class="keywordflow">if</span> (col-><a class="code" href="struct_o_c_i___column.html#c4994d12d5658ac0749a89eca1c1b1c3">prec</a> != 0)<a name="l00430"></a>00430 {<a name="l00431"></a>00431 OCI_CALL2<a name="l00432"></a>00432 (<a name="l00433"></a>00433 res, dp-><a class="code" href="struct_o_c_i___dir_path.html#52410868a337ad04434b1e11859a471b">con</a>,<a name="l00434"></a>00434 <a name="l00435"></a>00435 OCIAttrSet((dvoid *) hattr, (ub4) OCI_DTYPE_PARAM,<a name="l00436"></a>00436 (dvoid *) &col-><a class="code" href="struct_o_c_i___column.html#c4994d12d5658ac0749a89eca1c1b1c3">prec</a>, <span class="keyword">sizeof</span>(col-><a class="code" href="struct_o_c_i___column.html#c4994d12d5658ac0749a89eca1c1b1c3">prec</a>),<a name="l00437"></a>00437 (ub4) OCI_ATTR_PRECISION, dp-><a class="code" href="struct_o_c_i___dir_path.html#52410868a337ad04434b1e11859a471b">con</a>-><a class="code" href="struct_o_c_i___connection.html#573a359867139990b1b0f50aa7a86175">err</a>)<a name="l00438"></a>00438 )<a name="l00439"></a>00439 }<a name="l00440"></a>00440 <a name="l00441"></a>00441 <span class="comment">/* set column scale */</span>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -