group__g__exec.html

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

<li>For UPDATEs : number of rows updated</li><li>For INSERTs : number of rows inserted</li><li>For DELETEs : number of rows deleted</li></ul>
<p>
<dl class="note" compact><dt><b>Note:</b></dt><dd>For SELECTs statements, use <a class="el" href="group__g__fetch.html#g93bd9197720088dbda2bef593ad1c07c" title="Retrieve the number of rows fetched so far.">OCI_GetRowCount()</a> instead </dd></dl>

<p>Definition at line <a class="el" href="statement_8c-source.html#l02891">2891</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>, and <a class="el" href="ocilib__types_8h-source.html#l00411">OCI_Statement::stmt</a>.</p>

</div>
</div><p>
<a class="anchor" name="g05c6c5af87cdff3a231755cfd44e133f"></a><!-- doxytag: member="ocilib.h::OCI_GetSql" ref="g05c6c5af87cdff3a231755cfd44e133f" args="(OCI_Statement *stmt)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT const mtext* OCI_API OCI_GetSql           </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 last SQL or PL/SQL statement parsed by the 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>

<p>Definition at line <a class="el" href="statement_8c-source.html#l02865">2865</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#l00415">OCI_Statement::sql</a>.</p>

</div>
</div><p>
<a class="anchor" name="gddfbdd24d8686d908e560611bb7b6cc7"></a><!-- doxytag: member="ocilib.h::OCI_GetSqlErrorPos" ref="gddfbdd24d8686d908e560611bb7b6cc7" args="(OCI_Statement *stmt)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT unsigned int OCI_API OCI_GetSqlErrorPos           </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 error position in the SQL statement where the error occurred in case of SQL parsing error. 
<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>Positions start at 1. </dd></dl>

<p>Definition at line <a class="el" href="statement_8c-source.html#l02878">2878</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#l00435">OCI_Statement::err_pos</a>.</p>

</div>
</div><p>
<a class="anchor" name="gd5a7fcffe7d24da001e44636cfc06578"></a><!-- doxytag: member="ocilib.h::OCI_Prepare" ref="gd5a7fcffe7d24da001e44636cfc06578" args="(OCI_Statement *stmt, const mtext *sql)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_Prepare           </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">const mtext *&nbsp;</td>
          <td class="paramname"> <em>sql</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>
Prepare a SQL statement or PL/SQL block. 
<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>sql</em>&nbsp;</td><td>- SQL order or PL/SQL block</td></tr>
  </table>
</dl>
<dl class="note" compact><dt><b>Note:</b></dt><dd>With version 1.3.0 and above, do not call this function for fetched statement handle (REF cursors)</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#l01192">1192</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#l00415">OCI_Statement::sql</a>, <a class="el" href="ocilib__types_8h-source.html#l00429">OCI_Statement::status</a>, <a class="el" href="ocilib__types_8h-source.html#l00411">OCI_Statement::stmt</a>, and <a class="el" href="ocilib__types_8h-source.html#l00430">OCI_Statement::type</a>.</p>

<p>Referenced by <a class="el" href="group__g__exec.html#gf2163ec44e644cc734c393188707985b">OCI_ExecuteStmt()</a>, <a class="el" href="group__g__format.html#ge1b4805b4ed6530b496cd637b52a2adf">OCI_ExecuteStmtFmt()</a>, <a class="el" href="group__g__format.html#g845524c6dce7499a0cc27488052a93c2">OCI_ImmediateFmt()</a>, <a class="el" href="group__g__format.html#g86178afd9c5ad75be6082abc01cf9f49">OCI_PrepareFmt()</a>, and <a class="el" href="group__g__plsql.html#geff8f38ba15b9e757cec70d91e4ffe13">OCI_ServerEnableOutput()</a>.</p>

</div>
</div><p>
<a class="anchor" name="g335822f983af0fb5c529431f06a9a17b"></a><!-- doxytag: member="ocilib.h::OCI_StatementCreate" ref="g335822f983af0fb5c529431f06a9a17b" 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___statement.html">OCI_Statement</a>* OCI_API OCI_StatementCreate           </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>
Create a statement object and return its 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>con</em>&nbsp;</td><td>- Connection handle</td></tr>
  </table>
</dl>
<dl class="return" compact><dt><b>Returns:</b></dt><dd>A statement handle on success otherwise NULL </dd></dl>

<p>Definition at line <a class="el" href="statement_8c-source.html#l01112">1112</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#l00260">OCI_Connection::stmts</a>.</p>

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

</div>
</div><p>
<a class="anchor" name="g487b4f90f1fd4aee18f3d901f5aed104"></a><!-- doxytag: member="ocilib.h::OCI_StatementFree" ref="g487b4f90f1fd4aee18f3d901f5aed104" args="(OCI_Statement *stmt)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_StatementFree           </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>
Free a statement and all resources associated to it (resultsets, ....). 
<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>- Connection handle</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#l01137">1137</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#l00260">OCI_Connection::stmts</a>.</p>

<p>Referenced by <a class="el" href="group__g__format.html#g85318e359913e49d5654d2f53a070ef7">OCI_Immediate()</a>, <a class="el" href="group__g__format.html#g845524c6dce7499a0cc27488052a93c2">OCI_ImmediateFmt()</a>, and <a class="el" href="group__g__plsql.html#g0d3321a0abff0722baf6b2b7233f4cb5">OCI_ServerDisableOutput()</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>