group__g__stmt.html

ORACLE编程的好东西,纯C写的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#l02386">2386</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#l00376">OCI_Statement::con</a>, and <a class="el" href="ocilib__types_8h-source.html#l00383">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#l02498">2498</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#l00376">OCI_Statement::con</a>, and <a class="el" href="ocilib__types_8h-source.html#l00386">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>Possibles 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#l02528">2528</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#l00387">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 prefetched 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 prefetch size attribute is used instead. When both attributes are set (prefecth size and memory) and prefetch memory value can hold more rows than specified by prefecth size, OCI uses prefetch size instead.<p>
OCILIB set prefetch attribute to OCI_PREFETCH_SIZE when a statment is created. To setup a big value for <a class="el" href="group__g__stmt.html#g50e9b5456cb68d38a3b24e05bcd3f0e3" title="Set the number of rows prefetched by OCI Client.">OCI_SetPrefetchMemory()</a>, you must call <a class="el" href="group__g__stmt.html#g7298b6b4f2d9971e3c05361da12991dd" title="Set the number of rows prefetched by OCI Client.">OCI_SetPrefetchSize()</a> to 0 to make OCI condiser 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#l02457">2457</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#l00376">OCI_Statement::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#l00385">OCI_Statement::prefetch_mem</a>, and <a class="el" href="ocilib__types_8h-source.html#l00373">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 prefetched 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 preffetch</td></tr>
  </table>
</dl>
<dl class="note" compact><dt><b>Note:</b></dt><dd>To turn off prefetching, 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#l02416">2416</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#l00376">OCI_Statement::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#l00384">OCI_Statement::prefetch_size</a>, and <a class="el" href="ocilib__types_8h-source.html#l00373">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#l02556">2556</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#l00376">OCI_Statement::con</a>.</p>

</div>
</div><p>
<hr size="1"><address style="text-align: right;"><small>Generated on Thu Oct 9 10:07:47 2008 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>