📄 schema_8c-source.html
字号:
<a name="l00250"></a>00250 NULL, num_type, con-><a class="code" href="struct_o_c_i___connection.html#573a359867139990b1b0f50aa7a86175">err</a>)<a name="l00251"></a>00251 )<a name="l00252"></a>00252 }<a name="l00253"></a>00253 <a name="l00254"></a>00254 <span class="comment">/* allocates memory for children */</span><a name="l00255"></a>00255 <a name="l00256"></a>00256 <span class="keywordflow">if</span> (schema-><a class="code" href="struct_o_c_i___schema.html#7e653f740904e095a5dd9e2919f354ff">nb_cols</a> > 0)<a name="l00257"></a>00257 {<a name="l00258"></a>00258 schema-><a class="code" href="struct_o_c_i___schema.html#cf25d0fa0236499ea3845ab77338a5e9">cols</a> = (<a class="code" href="struct_o_c_i___column.html" title="Oracle SQL Column and Type member representation.">OCI_Column</a> *) OCI_MemAlloc(OCI_IPC_COLUMN,<a name="l00259"></a>00259 <span class="keyword">sizeof</span>(*schema-><a class="code" href="struct_o_c_i___schema.html#cf25d0fa0236499ea3845ab77338a5e9">cols</a>),<a name="l00260"></a>00260 schema-><a class="code" href="struct_o_c_i___schema.html#7e653f740904e095a5dd9e2919f354ff">nb_cols</a>,<a name="l00261"></a>00261 TRUE);<a name="l00262"></a>00262 <a name="l00263"></a>00263 <span class="comment">/* describe children */</span><a name="l00264"></a>00264 <a name="l00265"></a>00265 <span class="keywordflow">if</span> (schema-><a class="code" href="struct_o_c_i___schema.html#cf25d0fa0236499ea3845ab77338a5e9">cols</a> != NULL)<a name="l00266"></a>00266 {<a name="l00267"></a>00267 <span class="keywordflow">for</span> (i = 0; i < schema-><a class="code" href="struct_o_c_i___schema.html#7e653f740904e095a5dd9e2919f354ff">nb_cols</a>; i++)<a name="l00268"></a>00268 {<a name="l00269"></a>00269 res = res && OCI_ColumnDescribe(&schema-><a class="code" href="struct_o_c_i___schema.html#cf25d0fa0236499ea3845ab77338a5e9">cols</a>[i], con, <a name="l00270"></a>00270 NULL, parmh2, i + 1, ptype);<a name="l00271"></a>00271 <a name="l00272"></a>00272 res = res && OCI_ColumnMap(&schema-><a class="code" href="struct_o_c_i___schema.html#cf25d0fa0236499ea3845ab77338a5e9">cols</a>[i], NULL);<a name="l00273"></a>00273 <a name="l00274"></a>00274 <span class="keywordflow">if</span> (res == FALSE)<a name="l00275"></a>00275 <span class="keywordflow">break</span>;<a name="l00276"></a>00276 }<a name="l00277"></a>00277 }<a name="l00278"></a>00278 <span class="keywordflow">else</span><a name="l00279"></a>00279 res = FALSE;<a name="l00280"></a>00280 }<a name="l00281"></a>00281 <a name="l00282"></a>00282 <span class="comment">/* free describe handle */</span><a name="l00283"></a>00283 <a name="l00284"></a>00284 <span class="keywordflow">if</span> (dschp != NULL)<a name="l00285"></a>00285 OCI_HandleFree(dschp, OCI_HTYPE_DESCRIBE);<a name="l00286"></a>00286 }<a name="l00287"></a>00287 }<a name="l00288"></a>00288 <a name="l00289"></a>00289 <span class="comment">/* handle errors */</span><a name="l00290"></a>00290 <a name="l00291"></a>00291 <span class="keywordflow">if</span> (res == FALSE)<a name="l00292"></a>00292 {<a name="l00293"></a>00293 <a class="code" href="group__g__desc.html#g61364dbec3c2f18c49b66906daa24849" title="Free a schema object.">OCI_SchemaFree</a>(schema); <a name="l00294"></a>00294 schema = NULL;<a name="l00295"></a>00295 }<a name="l00296"></a>00296 <a name="l00297"></a>00297 OCI_RESULT(res);<a name="l00298"></a>00298 <a name="l00299"></a>00299 <span class="keywordflow">return</span> schema; <a name="l00300"></a>00300 }<a name="l00301"></a>00301 <a name="l00302"></a>00302 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00303"></a>00303 <span class="comment"> * OCI_SchemaFree</span><a name="l00304"></a>00304 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00305"></a>00305 <a name="l00306"></a><a class="code" href="group__g__desc.html#g61364dbec3c2f18c49b66906daa24849">00306</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__desc.html#g61364dbec3c2f18c49b66906daa24849" title="Free a schema object.">OCI_SchemaFree</a>(<a class="code" href="struct_o_c_i___schema.html" title="Schema metadata handle.">OCI_Schema</a> *schema)<a name="l00307"></a>00307 {<a name="l00308"></a>00308 <span class="keywordtype">boolean</span> res = TRUE;<a name="l00309"></a>00309 <a name="l00310"></a>00310 OCI_CHECK_PTR(OCI_IPC_SCHEMA, schema, FALSE);<a name="l00311"></a>00311 <a name="l00312"></a>00312 OCI_ListRemove(schema-><a class="code" href="struct_o_c_i___schema.html#0ef69317a497d87f4c4b1c2975592f5f">con</a>-><a class="code" href="struct_o_c_i___connection.html#220b45c2fd519a7e20e7977490e04ee6">sobjs</a>, schema);<a name="l00313"></a>00313 <a name="l00314"></a>00314 res = OCI_SchemaClose(schema);<a name="l00315"></a>00315 <a name="l00316"></a>00316 OCI_FREE(schema);<a name="l00317"></a>00317 <a name="l00318"></a>00318 OCI_RESULT(res);<a name="l00319"></a>00319 <a name="l00320"></a>00320 <span class="keywordflow">return</span> res;<a name="l00321"></a>00321 }<a name="l00322"></a>00322 <a name="l00323"></a>00323 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00324"></a>00324 <span class="comment"> * OCI_SchemaGetType</span><a name="l00325"></a>00325 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00326"></a>00326 <a name="l00327"></a><a class="code" href="group__g__desc.html#g32df7f2059febe1f4654b1b56900b30d">00327</a> <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> OCI_API <a class="code" href="group__g__desc.html#g32df7f2059febe1f4654b1b56900b30d" title="Return the type schema object.">OCI_SchemaGetType</a>(<a class="code" href="struct_o_c_i___schema.html" title="Schema metadata handle.">OCI_Schema</a> *schema)<a name="l00328"></a>00328 {<a name="l00329"></a>00329 OCI_CHECK_PTR(OCI_IPC_SCHEMA, schema, OCI_UNKNOWN);<a name="l00330"></a>00330 <a name="l00331"></a>00331 OCI_RESULT(TRUE);<a name="l00332"></a>00332 <a name="l00333"></a>00333 <span class="keywordflow">return</span> schema-><a class="code" href="struct_o_c_i___schema.html#e3d92ea63461c344eddb678d167191fc">type</a>;<a name="l00334"></a>00334 }<a name="l00335"></a>00335 <a name="l00336"></a>00336 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00337"></a>00337 <span class="comment"> * OCI_SchemaGetColumnCount</span><a name="l00338"></a>00338 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00339"></a>00339 <a name="l00340"></a><a class="code" href="group__g__desc.html#g2f1776350725fc6286333141428d35cd">00340</a> <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> OCI_API <a class="code" href="group__g__desc.html#g2f1776350725fc6286333141428d35cd" title="Retruns the number of columns of a table/view/object.">OCI_SchemaGetColumnCount</a>(<a class="code" href="struct_o_c_i___schema.html" title="Schema metadata handle.">OCI_Schema</a> *schema)<a name="l00341"></a>00341 {<a name="l00342"></a>00342 OCI_CHECK_PTR(OCI_IPC_SCHEMA, schema, 0);<a name="l00343"></a>00343 <a name="l00344"></a>00344 OCI_RESULT(TRUE);<a name="l00345"></a>00345 <a name="l00346"></a>00346 <span class="keywordflow">return</span> schema-><a class="code" href="struct_o_c_i___schema.html#7e653f740904e095a5dd9e2919f354ff">nb_cols</a>;<a name="l00347"></a>00347 }<a name="l00348"></a>00348 <a name="l00349"></a>00349 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00350"></a>00350 <span class="comment"> * OCI_SchemaGetColumn</span><a name="l00351"></a>00351 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00352"></a>00352 <a name="l00353"></a><a class="code" href="group__g__desc.html#g54d9514129172773ed87017f9603febf">00353</a> <a class="code" href="struct_o_c_i___column.html" title="Oracle SQL Column and Type member representation.">OCI_Column</a> * OCI_API <a class="code" href="group__g__desc.html#g54d9514129172773ed87017f9603febf" title="Return the column object handle at the given index in the table.">OCI_SchemaGetColumn</a>(<a class="code" href="struct_o_c_i___schema.html" title="Schema metadata handle.">OCI_Schema</a> *schema, <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> index)<a name="l00354"></a>00354 {<a name="l00355"></a>00355 OCI_CHECK_PTR(OCI_IPC_SCHEMA, schema, NULL);<a name="l00356"></a>00356 OCI_CHECK_BOUND(schema-><a class="code" href="struct_o_c_i___schema.html#0ef69317a497d87f4c4b1c2975592f5f">con</a>, index, 1, schema-><a class="code" href="struct_o_c_i___schema.html#7e653f740904e095a5dd9e2919f354ff">nb_cols</a>, NULL);<a name="l00357"></a>00357 <a name="l00358"></a>00358 OCI_RESULT(TRUE);<a name="l00359"></a>00359 <a name="l00360"></a>00360 <span class="keywordflow">return</span> &(schema-><a class="code" href="struct_o_c_i___schema.html#cf25d0fa0236499ea3845ab77338a5e9">cols</a>[index-1]);<a name="l00361"></a>00361 }<a name="l00362"></a>00362 <a name="l00363"></a>00363 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00364"></a>00364 <span class="comment"> * OCI_SchemaGetName</span><a name="l00365"></a>00365 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00366"></a>00366 <a name="l00367"></a><a class="code" href="group__g__desc.html#g4c1d0b674727add24a40df582a590520">00367</a> <span class="keyword">const</span> mtext * OCI_API <a class="code" href="group__g__desc.html#g4c1d0b674727add24a40df582a590520" title="Return the name described by the schema object.">OCI_SchemaGetName</a>(<a class="code" href="struct_o_c_i___schema.html" title="Schema metadata handle.">OCI_Schema</a> *schema)<a name="l00368"></a>00368 {<a name="l00369"></a>00369 OCI_CHECK_PTR(OCI_IPC_SCHEMA, schema, NULL);<a name="l00370"></a>00370 <a name="l00371"></a>00371 OCI_RESULT(TRUE);<a name="l00372"></a>00372 <a name="l00373"></a>00373 <span class="keywordflow">return</span> schema-><a class="code" href="struct_o_c_i___schema.html#3defe3dbfe9f95653d2e84ddb2a2023a">name</a>;<a name="l00374"></a>00374 }</pre></div><hr size="1"><address style="text-align: right;"><small>Generated on Thu Oct 9 10:07:44 2008 for OCILIB (C Driver for Oracle) by <a href="http://www.doxygen.org/index.html"><img src="doxygen.png" alt="doxygen" align="middle" border="0"></a> 1.5.4 </small></address></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -