group__g__format.html

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

<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_Immediate           </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">const mtext *&nbsp;</td>
          <td class="paramname"> <em>sql</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">&nbsp;</td>
          <td class="paramname"> <em>...</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>
Perform 3 calls (prepare+execute+fetch) in 1 call. 
<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>sql</em>&nbsp;</td><td>- SQL statement </td></tr>
    <tr><td valign="top"></td><td valign="top"><em>...</em>&nbsp;</td><td>- List of program variables address to store the result of fetch operation</td></tr>
  </table>
</dl>
<dl class="note" compact><dt><b>Note:</b></dt><dd>Every output parameter MUST be preceded by an integer parameter that indicates the type of the placeholder in order to handle correctly the given pointer.</dd></dl>
TRUE on success otherwise FALSE 
<p>Definition at line <a class="el" href="statement_8c-source.html#l01442">1442</a> of file <a class="el" href="statement_8c-source.html">statement.c</a>.</p>

<p>References <a class="el" href="group__g__exec.html#gf2163ec44e644cc734c393188707985b">OCI_ExecuteStmt()</a>, <a class="el" href="group__g__stmt.html#g78f017309e4be771379a064642ff91ef">OCI_GetStatementType()</a>, <a class="el" href="group__g__exec.html#g335822f983af0fb5c529431f06a9a17b">OCI_StatementCreate()</a>, and <a class="el" href="group__g__exec.html#g487b4f90f1fd4aee18f3d901f5aed104">OCI_StatementFree()</a>.</p>

</div>
</div><p>
<a class="anchor" name="g845524c6dce7499a0cc27488052a93c2"></a><!-- doxytag: member="ocilib.h::OCI_ImmediateFmt" ref="g845524c6dce7499a0cc27488052a93c2" args="(OCI_Connection *con, const mtext *sql,...)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_ImmediateFmt           </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">const mtext *&nbsp;</td>
          <td class="paramname"> <em>sql</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">&nbsp;</td>
          <td class="paramname"> <em>...</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>
Performs 4 call (prepare+bind+execute+fetch) in 1 call. 
<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>sql</em>&nbsp;</td><td>- SQL statement </td></tr>
    <tr><td valign="top"></td><td valign="top"><em>...</em>&nbsp;</td><td>- List of program values to format the SQL followed by the output variables addresses for the fetch operation</td></tr>
  </table>
</dl>
TRUE on success otherwise FALSE 
<p>Definition at line <a class="el" href="statement_8c-source.html#l01480">1480</a> of file <a class="el" href="statement_8c-source.html">statement.c</a>.</p>

<p>References <a class="el" href="group__g__exec.html#g7189aa353845909aaedc8d5956429450">OCI_Execute()</a>, <a class="el" href="group__g__stmt.html#g78f017309e4be771379a064642ff91ef">OCI_GetStatementType()</a>, <a class="el" href="group__g__exec.html#gd5a7fcffe7d24da001e44636cfc06578">OCI_Prepare()</a>, <a class="el" href="group__g__exec.html#g335822f983af0fb5c529431f06a9a17b">OCI_StatementCreate()</a>, and <a class="el" href="group__g__exec.html#g487b4f90f1fd4aee18f3d901f5aed104">OCI_StatementFree()</a>.</p>

</div>
</div><p>
<a class="anchor" name="g86178afd9c5ad75be6082abc01cf9f49"></a><!-- doxytag: member="ocilib.h::OCI_PrepareFmt" ref="g86178afd9c5ad75be6082abc01cf9f49" args="(OCI_Statement *stmt, const mtext *sql,...)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_PrepareFmt           </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>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">&nbsp;</td>
          <td class="paramname"> <em>...</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 formatted 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 statement </td></tr>
    <tr><td valign="top"></td><td valign="top"><em>...</em>&nbsp;</td><td>- List of program values to format the SQL</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#l01336">1336</a> of file <a class="el" href="statement_8c-source.html">statement.c</a>.</p>

<p>References <a class="el" href="group__g__exec.html#gd5a7fcffe7d24da001e44636cfc06578">OCI_Prepare()</a>.</p>

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