group__g__stmt.html

oci的源码,可以在任何平台上编译,相当方便实用

<p>Definition at line <a class="el" href="statement_8c-source.html#l02839">2839</a> of file <a class="el" href="statement_8c-source.html">statement.c</a>.</p>

<p>References <a class="el" href="ocilib__types_8h-source.html#l00428">OCI_Statement::long_mode</a>.</p>

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

<p>
Return the amount of memory used to retrieve rows pre-fetched by OCI Client. 
<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>stmt</em>&nbsp;</td><td>- Statement handle</td></tr>
  </table>
</dl>
<dl class="note" compact><dt><b>Note:</b></dt><dd>Default value is 0 </dd></dl>

<p>Definition at line <a class="el" href="statement_8c-source.html#l02781">2781</a> of file <a class="el" href="statement_8c-source.html">statement.c</a>.</p>

<p>References <a class="el" href="ocilib__types_8h-source.html#l00426">OCI_Statement::prefetch_mem</a>.</p>

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

<p>
Return the number of rows pre-fetched by OCI Client. 
<p>
<dl class="note" compact><dt><b>Note:</b></dt><dd>Default value is set to constant OCI_PREFETCH_SIZE</dd></dl>
<dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign="top"></td><td valign="top"><em>stmt</em>&nbsp;</td><td>- Statement handle </td></tr>
  </table>
</dl>

<p>Definition at line <a class="el" href="statement_8c-source.html#l02740">2740</a> of file <a class="el" href="statement_8c-source.html">statement.c</a>.</p>

<p>References <a class="el" href="ocilib__types_8h-source.html#l00425">OCI_Statement::prefetch_size</a>.</p>

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

<p>
Return the type of a SQL statement. 
<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>stmt</em>&nbsp;</td><td>- Statement handle</td></tr>
  </table>
</dl>
<dl class="note" compact><dt><b>Note:</b></dt><dd>Possible values are :</dd></dl>
<ul>
<li>OCI_CST_SELECT : select statement</li><li>OCI_CST_UPDATE : update statement</li><li>OCI_CST_DELETE : delete statement</li><li>OCI_CST_INSERT : insert statement</li><li>OCI_CST_CREATE : create statement</li><li>OCI_CST_DROP : drop statement</li><li>OCI_CST_ALTER : alter statement</li><li>OCI_CST_BEGIN : begin (pl/sql) statement</li><li>OCI_CST_DECLARE : declare (pl/sql) statement</li></ul>
<p>
<dl class="return" compact><dt><b>Returns:</b></dt><dd>The statement type on success or OCI_UNKOWN on error </dd></dl>

<p>Definition at line <a class="el" href="statement_8c-source.html#l02609">2609</a> of file <a class="el" href="statement_8c-source.html">statement.c</a>.</p>

<p>References <a class="el" href="ocilib__types_8h-source.html#l00430">OCI_Statement::type</a>.</p>

<p>Referenced by <a class="el" href="group__g__format.html#g85318e359913e49d5654d2f53a070ef7">OCI_Immediate()</a>, and <a class="el" href="group__g__format.html#g845524c6dce7499a0cc27488052a93c2">OCI_ImmediateFmt()</a>.</p>

</div>
</div><p>
<a class="anchor" name="g33e12da2d28c8a8a73165230a54c91cb"></a><!-- doxytag: member="ocilib.h::OCI_SetBindMode" ref="g33e12da2d28c8a8a73165230a54c91cb" args="(OCI_Statement *stmt, unsigned int mode)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_SetBindMode           </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> *&nbsp;</td>
          <td class="paramname"> <em>stmt</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">unsigned int&nbsp;</td>
          <td class="paramname"> <em>mode</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>
Set the binding mode of a SQL statement. 
<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>stmt</em>&nbsp;</td><td>- Statement handle </td></tr>
    <tr><td valign="top"></td><td valign="top"><em>mode</em>&nbsp;</td><td>- binding mode value</td></tr>
  </table>
</dl>
<dl class="note" compact><dt><b>Note:</b></dt><dd>Possible values are :</dd></dl>
<ul>
<li>OCI_BIND_BY_POS : position binding</li><li>OCI_BIND_BY_NAME : name binding </li></ul>

<p>Definition at line <a class="el" href="statement_8c-source.html#l02654">2654</a> of file <a class="el" href="statement_8c-source.html">statement.c</a>.</p>

<p>References <a class="el" href="ocilib__types_8h-source.html#l00422">OCI_Statement::bind_mode</a>.</p>

</div>
</div><p>
<a class="anchor" name="g83e1c31e40926a84651eb60fefd50d5e"></a><!-- doxytag: member="ocilib.h::OCI_SetFetchMode" ref="g83e1c31e40926a84651eb60fefd50d5e" args="(OCI_Statement *stmt, unsigned int mode)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_SetFetchMode           </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> *&nbsp;</td>
          <td class="paramname"> <em>stmt</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">unsigned int&nbsp;</td>
          <td class="paramname"> <em>mode</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>
Set the fetch mode of a SQL statement. 
<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>stmt</em>&nbsp;</td><td>- Statement handle </td></tr>
    <tr><td valign="top"></td><td valign="top"><em>mode</em>&nbsp;</td><td>- fetch mode value</td></tr>
  </table>
</dl>
<dl class="warning" compact><dt><b>Warning:</b></dt><dd><a class="el" href="group__g__stmt.html#g83e1c31e40926a84651eb60fefd50d5e" title="Set the fetch mode of a SQL statement.">OCI_SetFetchMode()</a> MUST be called before anyOCI_ExecuteXXX() call</dd></dl>
<dl class="note" compact><dt><b>Note:</b></dt><dd>Possible values are :</dd></dl>
<ul>
<li>OCI_SFM_DEFAULT</li><li>OCI_SFM_SCROLLABLE </li></ul>

<p>Definition at line <a class="el" href="statement_8c-source.html#l02622">2622</a> of file <a class="el" href="statement_8c-source.html">statement.c</a>.</p>

<p>References <a class="el" href="ocilib__types_8h-source.html#l00414">OCI_Statement::con</a>, and <a class="el" href="ocilib__types_8h-source.html#l00423">OCI_Statement::exec_mode</a>.</p>

</div>
</div><p>
<a class="anchor" name="g8ee64921bd9acb110c29cddbb461b3fe"></a><!-- doxytag: member="ocilib.h::OCI_SetFetchSize" ref="g8ee64921bd9acb110c29cddbb461b3fe" args="(OCI_Statement *stmt, unsigned int size)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_SetFetchSize           </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> *&nbsp;</td>
          <td class="paramname"> <em>stmt</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">unsigned int&nbsp;</td>
          <td class="paramname"> <em>size</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>
Set the number of rows fetched per internal server fetch call. 
<p>
<dl compact><dt><b>Parameters:</b></dt><dd>