group__g__stmt.html

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

  <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>size</em>&nbsp;</td><td>- number of rows to fetch</td></tr>
  </table>
</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="statement_8c-source.html#l02682">2682</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#l00424">OCI_Statement::fetch_size</a>.</p>

</div>
</div><p>
<a class="anchor" name="g0aec6183761a7d90307ba785733888e0"></a><!-- doxytag: member="ocilib.h::OCI_SetLongMaxSize" ref="g0aec6183761a7d90307ba785733888e0" 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_SetLongMaxSize           </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 LONG datatype piece buffer size. 
<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>size</em>&nbsp;</td><td>- maximum size for long buffer</td></tr>
  </table>
</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="statement_8c-source.html#l02794">2794</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#l00427">OCI_Statement::long_size</a>.</p>

</div>
</div><p>
<a class="anchor" name="ge92422b723eef25355d91e0b50c09c0c"></a><!-- doxytag: member="ocilib.h::OCI_SetLongMode" ref="ge92422b723eef25355d91e0b50c09c0c" 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_SetLongMode           </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 long datatype handling 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_LONG_EXPLICIT : LONGs are explicitly handled by <a class="el" href="struct_o_c_i___long.html" title="Oracle Long datatype.">OCI_Long</a> type</li><li>OCI_LONG_IMPLICIT : LONGs are implicitly mapped to string type in the limits of VARCHAR2 size capacity</li></ul>
<p>
LONG RAWs can't be handled with OCI_LONG_IMPLICIT 
<p>Definition at line <a class="el" href="statement_8c-source.html#l02824">2824</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="g50e9b5456cb68d38a3b24e05bcd3f0e3"></a><!-- doxytag: member="ocilib.h::OCI_SetPrefetchMemory" ref="g50e9b5456cb68d38a3b24e05bcd3f0e3" 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_SetPrefetchMemory           </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 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>
    <tr><td valign="top"></td><td valign="top"><em>size</em>&nbsp;</td><td>- amount of memory to fetch</td></tr>
  </table>
</dl>
<dl class="note" compact><dt><b>Note:</b></dt><dd>Default value is 0 and the pre-fetch size attribute is used instead. When both attributes are set (pre-fetch size and memory) and pre-fetch memory value can hold more rows than specified by pre-fetch size, OCI uses pre-fetch size instead.<p>
OCILIB set pre-fetch attribute to OCI_PREFETCH_SIZE when a statement is created. To setup a big value for <a class="el" href="group__g__stmt.html#g50e9b5456cb68d38a3b24e05bcd3f0e3" title="Set the number of rows pre-fetched by OCI Client.">OCI_SetPrefetchMemory()</a>, you must call <a class="el" href="group__g__stmt.html#g7298b6b4f2d9971e3c05361da12991dd" title="Set the number of rows pre-fetched by OCI Client.">OCI_SetPrefetchSize()</a> to 0 to make OCI consider this attribute.</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="statement_8c-source.html#l02753">2753</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>, <a class="el" href="ocilib__types_8h-source.html#l00267">OCI_Connection::err</a>, <a class="el" href="ocilib__types_8h-source.html#l00426">OCI_Statement::prefetch_mem</a>, and <a class="el" href="ocilib__types_8h-source.html#l00411">OCI_Statement::stmt</a>.</p>

</div>
</div><p>
<a class="anchor" name="g7298b6b4f2d9971e3c05361da12991dd"></a><!-- doxytag: member="ocilib.h::OCI_SetPrefetchSize" ref="g7298b6b4f2d9971e3c05361da12991dd" 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_SetPrefetchSize           </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 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>
    <tr><td valign="top"></td><td valign="top"><em>size</em>&nbsp;</td><td>- number of rows to pre-fetch</td></tr>
  </table>
</dl>
<dl class="note" compact><dt><b>Note:</b></dt><dd>To turn off pre-fetching, set both attributes (size and memory) to 0.</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="statement_8c-source.html#l02712">2712</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>, <a class="el" href="ocilib__types_8h-source.html#l00267">OCI_Connection::err</a>, <a class="el" href="ocilib__types_8h-source.html#l00425">OCI_Statement::prefetch_size</a>, and <a class="el" href="ocilib__types_8h-source.html#l00411">OCI_Statement::stmt</a>.</p>

</div>
</div><p>
<a class="anchor" name="g1f051eb0e55245280385a19f20efe59a"></a><!-- doxytag: member="ocilib.h::OCI_StatementGetConnection" ref="g1f051eb0e55245280385a19f20efe59a" args="(OCI_Statement *stmt)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT <a class="el" href="struct_o_c_i___connection.html">OCI_Connection</a>* OCI_API OCI_StatementGetConnection           </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 connection handle associated with a statement handle. 
<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>

<p>Definition at line <a class="el" href="statement_8c-source.html#l02852">2852</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>.</p>

</div>
</div><p>
<hr size="1"><address style="text-align: right;"><small>Generated on Sat Apr 18 01:13:14 2009 for OCILIB (C Driver for Oracle) by&nbsp;
<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>