group__g__connect.html

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

<p>References <a class="el" href="ocilib__types_8h-source.html#l00275">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<p>
Defauft format is :<ul>
<li>'FM99999999999999999999999999999999999990.999999999999999999999999'</li></ul>
</dd></dl>
<dl class="warning" compact><dt><b>Warning:</b></dt><dd>If data fetched 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#l01038">1038</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#l00276">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#l00780">780</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#l00269">OCI_Connection::cxt</a>, <a class="el" href="ocilib__types_8h-source.html#l00267">OCI_Connection::err</a>, <a class="el" href="ocilib__types_8h-source.html#l00258">OCI_Connection::pwd</a>, and <a class="el" href="ocilib__types_8h-source.html#l00257">OCI_Connection::user</a>.</p>

</div>
</div><p>
<a class="anchor" name="ga2be0c485c4937039d1fec437420dcf9"></a><!-- doxytag: member="ocilib.h::OCI_SetTrace" ref="ga2be0c485c4937039d1fec437420dcf9" args="(OCI_Connection *con, unsigned int trace, const mtext *value)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_SetTrace           </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>trace</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">const mtext *&nbsp;</td>
          <td class="paramname"> <em>value</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 tracing information to the session of the given 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>trace</em>&nbsp;</td><td>- trace type </td></tr>
    <tr><td valign="top"></td><td valign="top"><em>value</em>&nbsp;</td><td>- trace content</td></tr>
  </table>
</dl>
Store current trace information to the given connection handle. These information:<p>
<ul>
<li>is stored in the system view V$SESSION</li><li>can be retrieved from the connection property of an <a class="el" href="struct_o_c_i___error.html" title="Encapsulates an Oracle or OCILIB exception.">OCI_Error</a> handle</li></ul>
<p>
<dl class="note" compact><dt><b>Note:</b></dt><dd>Possible values of parameter 'trace type' :</dd></dl>
<ul>
<li>OCI_TRC_IDENTITY : Specifies the user defined identifier in the session. It's recorded in the column CLIENT_IDENTIFIER of the system view V$SESSION</li><li>OCI_TRC_MODULE : name of the current module in the client application. It's recorded in the column MODULE of the system view V$SESSION</li><li>OCI_TRC_ACTION : name of the current action within the current module. It's recorded in the column ACTION of the system view V$SESSION</li><li>OCI_TRC_DETAIL : Client application additional information. It's recorded in the column CLIENT_INFO of the system view V$SESSION</li></ul>
<p>
<dl class="warning" compact><dt><b>Warning:</b></dt><dd>The system view V$SESSION is updated on Oracle versions &gt;= 10g<p>
Oracle limits the size of these traces content and thus OCILIB will truncate the given values if needed :</dd></dl>
<ul>
<li>OCI_TRC_IDENTITY : 64 bytes</li><li>OCI_TRC_MODULE : 48 bytes</li><li>OCI_TRC_ACTION : 32 bytes</li><li>OCI_TRC_DETAIL : 64 bytes </li></ul>

<p>Definition at line <a class="el" href="connection_8c-source.html#l01251">1251</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#l00267">OCI_Connection::err</a>, <a class="el" href="ocilib__types_8h-source.html#l00268">OCI_Connection::ses</a>, and <a class="el" href="ocilib__types_8h-source.html#l00280">OCI_Connection::trace</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#l00959">959</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#l00263">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#l00726">726</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#l00274">OCI_Connection::usrdata</a>.</p>

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