group__g__plsql.html

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

<tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__plsql.html#g0d3321a0abff0722baf6b2b7233f4cb5">OCI_ServerDisableOutput</a> (<a class="el" href="struct_o_c_i___connection.html">OCI_Connection</a> *con)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Disable the server output.  <a href="#g0d3321a0abff0722baf6b2b7233f4cb5"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT const dtext *OCI_API&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__plsql.html#gbb13df960f035cd9e48e774c39db425a">OCI_ServerGetOutput</a> (<a class="el" href="struct_o_c_i___connection.html">OCI_Connection</a> *con)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Retrieve one line of the server buffer.  <a href="#gbb13df960f035cd9e48e774c39db425a"></a><br></td></tr>
</table>
<hr><h2>Function Documentation</h2>
<a class="anchor" name="g0d3321a0abff0722baf6b2b7233f4cb5"></a><!-- doxytag: member="ocilib.h::OCI_ServerDisableOutput" ref="g0d3321a0abff0722baf6b2b7233f4cb5" args="(OCI_Connection *con)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_ServerDisableOutput           </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>
</div>
<div class="memdoc">

<p>
Disable the server output. 
<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>con</em>&nbsp;</td><td>- Connection handle</td></tr>
  </table>
</dl>
<dl class="note" compact><dt><b>Note:</b></dt><dd>After this call, <a class="el" href="group__g__plsql.html#gbb13df960f035cd9e48e774c39db425a" title="Retrieve one line of the server buffer.">OCI_ServerGetOutput()</a> will return NULL.</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="connection_8c-source.html#l01199">1199</a> of file <a class="el" href="connection_8c-source.html">connection.c</a>.</p>

<p>References <a class="el" href="group__g__exec.html#gf2163ec44e644cc734c393188707985b">OCI_ExecuteStmt()</a>, <a class="el" href="group__g__exec.html#g487b4f90f1fd4aee18f3d901f5aed104">OCI_StatementFree()</a>, and <a class="el" href="ocilib__types_8h-source.html#l00265">OCI_Connection::svopt</a>.</p>

<p>Referenced by <a class="el" href="group__g__plsql.html#geff8f38ba15b9e757cec70d91e4ffe13">OCI_ServerEnableOutput()</a>.</p>

</div>
</div><p>
<a class="anchor" name="geff8f38ba15b9e757cec70d91e4ffe13"></a><!-- doxytag: member="ocilib.h::OCI_ServerEnableOutput" ref="geff8f38ba15b9e757cec70d91e4ffe13" args="(OCI_Connection *con, unsigned int bufsize, unsigned int arrsize, unsigned int lnsize)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_ServerEnableOutput           </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>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">unsigned int&nbsp;</td>
          <td class="paramname"> <em>bufsize</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">unsigned int&nbsp;</td>
          <td class="paramname"> <em>arrsize</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">unsigned int&nbsp;</td>
          <td class="paramname"> <em>lnsize</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>
Enable the server output. 
<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>con</em>&nbsp;</td><td>- Connection handle </td></tr>
    <tr><td valign="top"></td><td valign="top"><em>bufsize</em>&nbsp;</td><td>- server buffer max size (server side) </td></tr>
    <tr><td valign="top"></td><td valign="top"><em>arrsize</em>&nbsp;</td><td>- number of lines to retrieve per server roundtrip </td></tr>
    <tr><td valign="top"></td><td valign="top"><em>lnsize</em>&nbsp;</td><td>- maximum size of one line</td></tr>
  </table>
</dl>
<dl class="note" compact><dt><b>Note:</b></dt><dd>This call is equivalent to the command 'set serveroutput on' in SQL*PLUS<p>
'bufsize' minimum value is 2000, maximum 1000000 with Oracle &lt; 10.2g and can be unlimited above<p>
'lnsize' maximum value is 255 with Oracle &lt; 10.2g and 32767 above</dd></dl>
<dl class="warning" compact><dt><b>Warning:</b></dt><dd>If <a class="el" href="group__g__plsql.html#geff8f38ba15b9e757cec70d91e4ffe13" title="Enable the server output.">OCI_ServerEnableOutput()</a> is not called, <a class="el" href="group__g__plsql.html#gbb13df960f035cd9e48e774c39db425a" title="Retrieve one line of the server buffer.">OCI_ServerGetOutput()</a> will return NULL</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="connection_8c-source.html#l01097">1097</a> of file <a class="el" href="connection_8c-source.html">connection.c</a>.</p>

<p>References <a class="el" href="group__g__bind.html#g502cd4785691b17955f5d99276e48884">OCI_BindArrayOfStrings()</a>, <a class="el" href="group__g__bind.html#gaaed296bca244acc22d4f0d2f07e63b9">OCI_BindUnsignedInt()</a>, <a class="el" href="group__g__exec.html#g7189aa353845909aaedc8d5956429450">OCI_Execute()</a>, <a class="el" href="group__g__exec.html#gd5a7fcffe7d24da001e44636cfc06578">OCI_Prepare()</a>, <a class="el" href="group__g__plsql.html#g0d3321a0abff0722baf6b2b7233f4cb5">OCI_ServerDisableOutput()</a>, <a class="el" href="group__g__bind.html#g5e2b8cf5ec98a2e0379853387ea97c5e">OCI_SetNull()</a>, <a class="el" href="group__g__exec.html#g335822f983af0fb5c529431f06a9a17b">OCI_StatementCreate()</a>, <a class="el" href="ocilib__types_8h-source.html#l00265">OCI_Connection::svopt</a>, <a class="el" href="ocilib__types_8h-source.html#l00277">OCI_Connection::ver_maj</a>, and <a class="el" href="ocilib__types_8h-source.html#l00278">OCI_Connection::ver_min</a>.</p>

</div>
</div><p>
<a class="anchor" name="gbb13df960f035cd9e48e774c39db425a"></a><!-- doxytag: member="ocilib.h::OCI_ServerGetOutput" ref="gbb13df960f035cd9e48e774c39db425a" args="(OCI_Connection *con)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT const dtext* OCI_API OCI_ServerGetOutput           </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>
</div>
<div class="memdoc">

<p>
Retrieve one line of the server buffer. 
<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>con</em>&nbsp;</td><td>- Connection handle</td></tr>
  </table>
</dl>
<dl class="note" compact><dt><b>Note:</b></dt><dd>The current transaction is automatically stopped but the newly assigned is not started or resumed.<p>
Internally, OCILIB gets the server buffer through an array of lines in order to minimize roundtrips with the server</dd></dl>
<dl class="return" compact><dt><b>Returns:</b></dt><dd>return a server output buffer line or NULL if the server buffer is empty </dd></dl>

<p>Definition at line <a class="el" href="connection_8c-source.html#l01225">1225</a> of file <a class="el" href="connection_8c-source.html">connection.c</a>.</p>

<p>References <a class="el" href="group__g__exec.html#g7189aa353845909aaedc8d5956429450">OCI_Execute()</a>, and <a class="el" href="ocilib__types_8h-source.html#l00265">OCI_Connection::svopt</a>.</p>

</div>
</div><p>
<hr size="1"><address style="text-align: right;"><small>Generated on Sat Apr 18 01:13:13 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>