group__g__transac.html

ORACLE编程的好东西,纯C写的OCI封装.很好用,支持数据池.

          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">boolean&nbsp;</td>
          <td class="paramname"> <em>enable</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 / disable auto commit mode. 
<p>
The auto commit mode allows commit changes after every executed SQL order<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>enable</em>&nbsp;</td><td>- Enable (TRUE) or disable (FALSE)</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="connection_8c-source.html#l00628">628</a> of file <a class="el" href="connection_8c-source.html">connection.c</a>.</p>

<p>References <a class="el" href="ocilib__types_8h-source.html#l00238">OCI_Connection::autocom</a>.</p>

</div>
</div><p>
<a class="anchor" name="g206d14aa9a25befd218a7f91a56d5c47"></a><!-- doxytag: member="ocilib.h::OCI_TransactionCreate" ref="g206d14aa9a25befd218a7f91a56d5c47" args="(OCI_Connection *con, unsigned int timeout, unsigned int mode, OCI_XID *pxid)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT <a class="el" href="struct_o_c_i___transaction.html">OCI_Transaction</a>* OCI_API OCI_TransactionCreate           </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>timeout</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">unsigned int&nbsp;</td>
          <td class="paramname"> <em>mode</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___x_i_d.html">OCI_XID</a> *&nbsp;</td>
          <td class="paramname"> <em>pxid</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>
Create a new global transaction or a serializable/read-only local transaction. 
<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>timeout</em>&nbsp;</td><td>- Time that a transaction stays inactive after being stopped </td></tr>
    <tr><td valign="top"></td><td valign="top"><em>mode</em>&nbsp;</td><td>- Connection mode </td></tr>
    <tr><td valign="top"></td><td valign="top"><em>pxid</em>&nbsp;</td><td>- pointer to a global transaction identifier stucture</td></tr>
  </table>
</dl>
<dl class="note" compact><dt><b>Note:</b></dt><dd>The parameter 'mode' can be one of the following values :</dd></dl>
<ul>
<li>Global transactions :<ul>
<li>OCI_TRS_NEW : By default starts a new, tightly coupled and migratable branch.</li><li>OCI_TRS_TIGHT : explicitly specifies a tightly coupled branch</li><li>OCI_TRS_LOOSE : specifies a loosely coupled branch</li></ul>
</li></ul>
<p>
<ul>
<li>Global and local transactions :<ul>
<li>OCI_TRS_READONLY - start a read-only transaction</li><li>OCI_TRS_READWRITE - start a read-write transaction</li><li>OCI_TRS_SERIALIZABLE : start a serializable transaction</li></ul>
</li></ul>
<p>
<dl class="note" compact><dt><b>Note:</b></dt><dd>For local transaction :<ul>
<li>pass a NULL value for pxid </li></ul>
</dd></dl>

<p>Definition at line <a class="el" href="transaction_8c-source.html#l00045">45</a> of file <a class="el" href="transaction_8c-source.html">transaction.c</a>.</p>

<p>References <a class="el" href="ocilib__types_8h-source.html#l00257">OCI_Transaction::con</a>, <a class="el" href="ocilib__types_8h-source.html#l00237">OCI_Connection::cxt</a>, <a class="el" href="ocilib__types_8h-source.html#l00235">OCI_Connection::err</a>, <a class="el" href="ocilib__types_8h-source.html#l00258">OCI_Transaction::htr</a>, <a class="el" href="ocilib__types_8h-source.html#l00261">OCI_Transaction::local</a>, <a class="el" href="ocilib__types_8h-source.html#l00260">OCI_Transaction::mode</a>, <a class="el" href="group__g__transac.html#gab96c358fd6074b5d4f027bd86cfa229">OCI_TransactionFree()</a>, <a class="el" href="ocilib__types_8h-source.html#l00259">OCI_Transaction::timeout</a>, <a class="el" href="ocilib__types_8h-source.html#l00229">OCI_Connection::trsns</a>, and <a class="el" href="ocilib__types_8h-source.html#l00262">OCI_Transaction::xid</a>.</p>

</div>
</div><p>
<a class="anchor" name="gdebbc2e16eea8f328b6d5dfb49a9d5c5"></a><!-- doxytag: member="ocilib.h::OCI_TransactionForget" ref="gdebbc2e16eea8f328b6d5dfb49a9d5c5" args="(OCI_Transaction *trans)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_TransactionForget           </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___transaction.html">OCI_Transaction</a> *&nbsp;</td>
          <td class="paramname"> <em>trans</em>          </td>
          <td>&nbsp;)&nbsp;</td>
          <td width="100%"></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>
Cancel the prepared global transaction validation. 
<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>trans</em>&nbsp;</td><td>- Global transaction 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="transaction_8c-source.html#l00274">274</a> of file <a class="el" href="transaction_8c-source.html">transaction.c</a>.</p>

<p>References <a class="el" href="ocilib__types_8h-source.html#l00257">OCI_Transaction::con</a>, <a class="el" href="ocilib__types_8h-source.html#l00237">OCI_Connection::cxt</a>, and <a class="el" href="ocilib__types_8h-source.html#l00235">OCI_Connection::err</a>.</p>

</div>
</div><p>
<a class="anchor" name="gab96c358fd6074b5d4f027bd86cfa229"></a><!-- doxytag: member="ocilib.h::OCI_TransactionFree" ref="gab96c358fd6074b5d4f027bd86cfa229" args="(OCI_Transaction *trans)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_TransactionFree           </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___transaction.html">OCI_Transaction</a> *&nbsp;</td>
          <td class="paramname"> <em>trans</em>          </td>
          <td>&nbsp;)&nbsp;</td>
          <td width="100%"></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>
Free current transaction. 
<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>trans</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="transaction_8c-source.html#l00149">149</a> of file <a class="el" href="transaction_8c-source.html">transaction.c</a>.</p>

<p>References <a class="el" href="ocilib__types_8h-source.html#l00257">OCI_Transaction::con</a>, and <a class="el" href="ocilib__types_8h-source.html#l00229">OCI_Connection::trsns</a>.</p>

<p>Referenced by <a class="el" href="group__g__transac.html#g206d14aa9a25befd218a7f91a56d5c47">OCI_TransactionCreate()</a>.</p>

</div>
</div><p>
<a class="anchor" name="ge54af0bfb81cd2d21bea6451db491e60"></a><!-- doxytag: member="ocilib.h::OCI_TransactionGetMode" ref="ge54af0bfb81cd2d21bea6451db491e60" args="(OCI_Transaction *trans)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT unsigned int OCI_API OCI_TransactionGetMode           </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___transaction.html">OCI_Transaction</a> *&nbsp;</td>
          <td class="paramname"> <em>trans</em>          </td>
          <td>&nbsp;)&nbsp;</td>
          <td width="100%"></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>
Return global transaction mode.