group__g__collection.html

ORACLE编程的好东西,纯C写的OCI封装.很好用,支持数据池.

        <tr>
          <td class="memname">OCI_EXPORT int OCI_API OCI_CollGetSize           </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___coll.html">OCI_Coll</a> *&nbsp;</td>
          <td class="paramname"> <em>coll</em>          </td>
          <td>&nbsp;)&nbsp;</td>
          <td width="100%"></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>
Returns the current number of elements of the given collection. 
<p>
<dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign="top"></td><td valign="top"><em>coll</em>&nbsp;</td><td>- Collection handle </td></tr>
  </table>
</dl>

<p>Definition at line <a class="el" href="collection_8c-source.html#l00248">248</a> of file <a class="el" href="collection_8c-source.html">collection.c</a>.</p>

<p>References <a class="el" href="ocilib__types_8h-source.html#l00531">OCI_Coll::size</a>.</p>

</div>
</div><p>
<a class="anchor" name="g18518027318ac527c9cbefab4f16b7ba"></a><!-- doxytag: member="ocilib.h::OCI_CollGetType" ref="g18518027318ac527c9cbefab4f16b7ba" args="(OCI_Coll *coll)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT unsigned int OCI_API OCI_CollGetType           </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___coll.html">OCI_Coll</a> *&nbsp;</td>
          <td class="paramname"> <em>coll</em>          </td>
          <td>&nbsp;)&nbsp;</td>
          <td width="100%"></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>
Return the collection type. 
<p>
<dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign="top"></td><td valign="top"><em>coll</em>&nbsp;</td><td>- Collection handle</td></tr>
  </table>
</dl>
<dl class="note" compact><dt><b>Note:</b></dt><dd>Current collection types are :</dd></dl>
<ul>
<li>OCI_COLL_VARRAY : Oracle VARRAY</li><li>OCI_COLL_NESTED_TABLE : ORacle Nested Table</li></ul>
<p>
<dl class="return" compact><dt><b>Returns:</b></dt><dd>Collection type or OCI_UNKNOWN if the collection handle is null </dd></dl>

<p>Definition at line <a class="el" href="collection_8c-source.html#l00211">211</a> of file <a class="el" href="collection_8c-source.html">collection.c</a>.</p>

<p>References <a class="el" href="ocilib__types_8h-source.html#l00558">OCI_Schema::ccode</a>, and <a class="el" href="ocilib__types_8h-source.html#l00529">OCI_Coll::nty</a>.</p>

</div>
</div><p>
<a class="anchor" name="g5fa6e43afbe0dc39b56b52f8e09dc29a"></a><!-- doxytag: member="ocilib.h::OCI_CollSetAt" ref="g5fa6e43afbe0dc39b56b52f8e09dc29a" args="(OCI_Coll *coll, unsigned int index, OCI_Elem *elem)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_CollSetAt           </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___coll.html">OCI_Coll</a> *&nbsp;</td>
          <td class="paramname"> <em>coll</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">unsigned int&nbsp;</td>
          <td class="paramname"> <em>index</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___elem.html">OCI_Elem</a> *&nbsp;</td>
          <td class="paramname"> <em>elem</em></td><td>&nbsp;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td><td width="100%"></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>
Assign the given element value to the element at the given position in the collection. 
<p>
<dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign="top"></td><td valign="top"><em>coll</em>&nbsp;</td><td>- Collection handle </td></tr>
    <tr><td valign="top"></td><td valign="top"><em>index</em>&nbsp;</td><td>- Index of the destination element </td></tr>
    <tr><td valign="top"></td><td valign="top"><em>elem</em>&nbsp;</td><td>- Source element handle to assign</td></tr>
  </table>
</dl>
<dl class="note" compact><dt><b>Note:</b></dt><dd>Collection indexes start at position 1.</dd></dl>
<dl class="return" compact><dt><b>Returns:</b></dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Definition at line <a class="el" href="collection_8c-source.html#l00326">326</a> of file <a class="el" href="collection_8c-source.html">collection.c</a>.</p>

<p>References <a class="el" href="ocilib__types_8h-source.html#l00515">OCI_Elem::col</a>, <a class="el" href="ocilib__types_8h-source.html#l00559">OCI_Schema::cols</a>, <a class="el" href="ocilib__types_8h-source.html#l00528">OCI_Coll::con</a>, <a class="el" href="ocilib__types_8h-source.html#l00235">OCI_Connection::err</a>, <a class="el" href="ocilib__types_8h-source.html#l00526">OCI_Coll::handle</a>, <a class="el" href="ocilib__types_8h-source.html#l00510">OCI_Elem::handle</a>, <a class="el" href="ocilib__types_8h-source.html#l00275">OCI_Column::icode</a>, <a class="el" href="ocilib__types_8h-source.html#l00513">OCI_Elem::ind</a>, and <a class="el" href="ocilib__types_8h-source.html#l00529">OCI_Coll::nty</a>.</p>

</div>
</div><p>
<a class="anchor" name="gc5e37e3a0fd362c8c3aa150d5cb66c51"></a><!-- doxytag: member="ocilib.h::OCI_CollTrim" ref="gc5e37e3a0fd362c8c3aa150d5cb66c51" args="(OCI_Coll *coll, int nb_elem)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_CollTrim           </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___coll.html">OCI_Coll</a> *&nbsp;</td>
          <td class="paramname"> <em>coll</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&nbsp;</td>
          <td class="paramname"> <em>nb_elem</em></td><td>&nbsp;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td><td width="100%"></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>
Trims the given number of elements from the end of the collection. 
<p>
<dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign="top"></td><td valign="top"><em>coll</em>&nbsp;</td><td>- Collection handle </td></tr>
    <tr><td valign="top"></td><td valign="top"><em>nb_elem</em>&nbsp;</td><td>- Number of elements to trim</td></tr>
  </table>
</dl>
<dl class="note" compact><dt><b>Note:</b></dt><dd></dd></dl>
<dl class="return" compact><dt><b>Returns:</b></dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Definition at line <a class="el" href="collection_8c-source.html#l00265">265</a> of file <a class="el" href="collection_8c-source.html">collection.c</a>.</p>

<p>References <a class="el" href="ocilib__types_8h-source.html#l00528">OCI_Coll::con</a>, <a class="el" href="ocilib__types_8h-source.html#l00235">OCI_Connection::err</a>, <a class="el" href="ocilib__types_8h-source.html#l00526">OCI_Coll::handle</a>, and <a class="el" href="ocilib__types_8h-source.html#l00531">OCI_Coll::size</a>.</p>

</div>
</div><p>
<a class="anchor" name="g277da74d3afbe9d25ae0f81fcacf545f"></a><!-- doxytag: member="ocilib.h::OCI_ElemCreate" ref="g277da74d3afbe9d25ae0f81fcacf545f" args="(OCI_Connection *con)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT <a class="el" href="struct_o_c_i___elem.html">OCI_Elem</a>* OCI_API OCI_ElemCreate           </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___connection.html">OCI_Connection</a> *&nbsp;</td>
          <td class="paramname"> <em>con</em>          </td>
          <td>&nbsp;)&nbsp;</td>
          <td width="100%"></td>
        </tr>
      </table>