group__g__connect.html

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

          <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>format</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 date format for implicit string / date conversions. 
<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>format</em>&nbsp;</td><td>- Date format</td></tr>
  </table>
</dl>
@ Note Defauft format is :<ul>
<li>'YYYY-MM-DD'</li></ul>
<p>
<dl class="note" compact><dt><b>Note:</b></dt><dd>Possible values are the string date format supported by Oracle. See documentation of Oracle SQL to_date() function for more details </dd></dl>

<p>Definition at line <a class="el" href="connection_8c-source.html#l00967">967</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#l00243">OCI_Connection::fmt_date</a>.</p>

<p>Referenced by <a class="el" href="group__g__connect.html#g88036a98ff02dfadb2ad50800c38684c">OCI_GetDefaultFormatDate()</a>.</p>

</div>
</div><p>
<a class="anchor" name="g591e0e1e49c7ff06e50f5ab17edf3dbf"></a><!-- doxytag: member="ocilib.h::OCI_SetDefaultFormatNumeric" ref="g591e0e1e49c7ff06e50f5ab17edf3dbf" args="(OCI_Connection *con, const mtext *format)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_SetDefaultFormatNumeric           </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>format</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 numeric format for implicit string / numeric conversions. 
<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>format</em>&nbsp;</td><td>- Numeric format</td></tr>
  </table>
</dl>
<dl class="note" compact><dt><b>Note:</b></dt><dd>Possible values are the string numeric format supported by Oracle. See documentation of Oracle SQL to_number() function for more details</dd></dl>
@ Note Defauft format is :<ul>
<li>'FM99999999999999999999999999999999999990.999999999999999999999999'</li></ul>
<p>
<dl class="warning" compact><dt><b>Warning:</b></dt><dd>If data feched from a string column cannot be converted to a number value with the given format, an error will be raised </dd></dl>

<p>Definition at line <a class="el" href="connection_8c-source.html#l01004">1004</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#l00244">OCI_Connection::fmt_num</a>.</p>

<p>Referenced by <a class="el" href="group__g__connect.html#g57c1be56edaf86588dfb7a1245bf5908">OCI_GetDefaultFormatNumeric()</a>.</p>

</div>
</div><p>
<a class="anchor" name="g9442dd482fee879033bea7a3a00ace24"></a><!-- doxytag: member="ocilib.h::OCI_SetPassword" ref="g9442dd482fee879033bea7a3a00ace24" args="(OCI_Connection *con, const mtext *password)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_SetPassword           </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>password</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>
Change the password of the logged user. 
<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>password</em>&nbsp;</td><td>- New password</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#l00749">749</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#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#l00226">OCI_Connection::pwd</a>, and <a class="el" href="ocilib__types_8h-source.html#l00225">OCI_Connection::user</a>.</p>

</div>
</div><p>
<a class="anchor" name="gcd5bcb0f0894ffcafcb6dfee5e850f5a"></a><!-- doxytag: member="ocilib.h::OCI_SetTransaction" ref="gcd5bcb0f0894ffcafcb6dfee5e850f5a" args="(OCI_Connection *con, OCI_Transaction *trans)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_SetTransaction           </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"><a class="el" href="struct_o_c_i___transaction.html">OCI_Transaction</a> *&nbsp;</td>
          <td class="paramname"> <em>trans</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>
Return the current transaction attached to the connection. 
<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>trans</em>&nbsp;</td><td>- Transaction handle to assign</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. </dd></dl>

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

<p>References <a class="el" href="group__g__transac.html#g7ede55e97d4012c7ea43df2bec40762e">OCI_TransactionStop()</a>, and <a class="el" href="ocilib__types_8h-source.html#l00231">OCI_Connection::trs</a>.</p>

</div>
</div><p>
<a class="anchor" name="geed5fe2da7af18c69585fbec9f63c951"></a><!-- doxytag: member="ocilib.h::OCI_SetUserData" ref="geed5fe2da7af18c69585fbec9f63c951" args="(OCI_Connection *con, void *data)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_SetUserData           </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">void *&nbsp;</td>
          <td class="paramname"> <em>data</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>
Associate to the given connection a pointer to user data. 
<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>data</em>&nbsp;</td><td>- user data pointer</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#l00695">695</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#l00242">OCI_Connection::usrdata</a>.</p>

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