group__loginout.html

Linux下的操作oracle数据库的连接库

        <tr>
          <td class="md" nowrap align="right"></td>
          <td></td>
          <td class="md" nowrap>const char *&nbsp;</td>
          <td class="mdname" nowrap> <em>password</em></td>
        </tr>
        <tr>
          <td></td>
          <td class="md">)&nbsp;</td>
          <td class="md" colspan="2"></td>
        </tr>

      </table>
    </td>
  </tr>
</table>
<table cellspacing=5 cellpadding=0 border=0>
  <tr>
    <td>
      &nbsp;
    </td>
    <td>

<p>
Begin a session. 
<p>
Do the login to an attached server. You can either pass username and password seperatly, or pass the complete connect string in username.<p>
<dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign=top><em>dbh</em>&nbsp;</td><td>I - A database handle </td></tr>
    <tr><td valign=top><em>username</em>&nbsp;</td><td>I - The username for authentication, or a complete Oracle connect string. </td></tr>
    <tr><td valign=top><em>password</em>&nbsp;</td><td>I - The password for authentication</td></tr>
  </table>
</dl>
<dl compact><dt><b>Returns:</b></dt><dd><ul>
<li>
SQLO_SUCCESS </li>
<li>
&lt; 0 on error </li>
</ul>
</dd></dl>
<dl compact><dt><b>See also:</b></dt><dd><a class="el" href="group__loginout.html#ga3">sqlo_server_attach</a>, <a class="el" href="group__loginout.html#ga7">sqlo_session_end</a> </dd></dl>
<dl compact><dt><b>Since:</b></dt><dd>Version 2.2 </dd></dl>

<p>
Definition at line <a class="el" href="sqlora_8c-source.html#l06029">6029</a> of file <a class="el" href="sqlora_8c-source.html">sqlora.c</a>.
<p>
References <a class="el" href="sqlora_8c.html#a49">_dbv</a>, <a class="el" href="sqlora_8c-source.html#l02905">_get_errcode()</a>, <a class="el" href="sqlora_8c-source.html#l04319">_get_trace_fp()</a>, <a class="el" href="sqlora_8c-source.html#l02451">_open_session_trace_file()</a>, <a class="el" href="sqlora_8c-source.html#l00865">_trace_fp</a>, <a class="el" href="sqlora_8c.html#a58">_trace_level</a>, <a class="el" href="sqlora_8c-source.html#l00507">_sqlo_db_struct::attached</a>, <a class="el" href="sqlora_8c-source.html#l00487">_sqlo_db_struct::authp</a>, <a class="el" href="sqlora_8c-source.html#l00416">CHECK_OCI_STATUS_RETURN</a>, <a class="el" href="sqlora_8c-source.html#l00483">_sqlo_db_struct::errhp</a>, <a class="el" href="sqlora_8c-source.html#l00495">_sqlo_db_struct::errmsg</a>, <a class="el" href="sqlora_8c-source.html#l00508">_sqlo_db_struct::session_created</a>, <a class="el" href="sqlora_8c.html#a30">sqlo_db_struct_ptr_t</a>, <a class="el" href="group__constants.html#gga3a26">SQLO_ERROR</a>, <a class="el" href="sqlora_8c-source.html#l04799">sqlo_geterrcode()</a>, <a class="el" href="group__constants.html#gga4a34">SQLO_INVALID_DB_HANDLE</a>, <a class="el" href="sqlora_8c-source.html#l05764">sqlo_split_cstring()</a>, <a class="el" href="group__constants.html#gga3a25">SQLO_SUCCESS</a>, <a class="el" href="sqlora_8c-source.html#l00493">_sqlo_db_struct::status</a>, <a class="el" href="sqlora_8c-source.html#l00485">_sqlo_db_struct::svchp</a>, <a class="el" href="sqlora_8c-source.html#l00238">TRACE</a>, <a class="el" href="sqlora_8c.html#a219a78">TRACE_ENABLED</a>, <a class="el" href="sqlora_8c-source.html#l00218">TRUE</a>, <a class="el" href="sqlora_8c-source.html#l00506">_sqlo_db_struct::used</a>, and <a class="el" href="sqlora_8c-source.html#l00435">VALID_DBH_RANGE</a>.
<p>
Referenced by <a class="el" href="sqlora_8c-source.html#l06271">sqlo_connect()</a>.    </td>
  </tr>
</table>

<p>
Here is the call graph for this function:<p><center><img src="group__loginout_ga4_cgraph.png" border="0" usemap="#group__loginout_ga4_cgraph_map" alt=""></center>
<map name="group__loginout_ga4_cgraph_map">
<area href="sqlora_8c.html#a118" shape="rect" coords="409,76,503,94" alt="">
<area href="sqlora_8c.html#a128" shape="rect" coords="231,56,327,74" alt="">
<area href="sqlora_8c.html#a99" shape="rect" coords="197,98,360,117" alt="">
<area href="group__error.html#ga1" shape="rect" coords="224,141,333,160" alt="">
<area href="group__loginout.html#ga2" shape="rect" coords="223,184,335,202" alt="">
</map>
<a class="anchor" name="ga7" doxytag="sqlora.h::sqlo_session_end" ></a><p>
<table class="mdTable" width="100%" cellpadding="2" cellspacing="0">
  <tr>
    <td class="mdRow">
      <table cellpadding="0" cellspacing="0" border="0">
        <tr>
          <td class="md" nowrap valign="top"> int sqlo_session_end </td>
          <td class="md" valign="top">(&nbsp;</td>
          <td class="md" nowrap valign="top"><a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a>&nbsp;</td>
          <td class="mdname1" valign="top" nowrap> <em>dbh</em>          </td>
          <td class="md" valign="top">&nbsp;)&nbsp;</td>
          <td class="md" nowrap></td>
        </tr>

      </table>
    </td>
  </tr>
</table>
<table cellspacing=5 cellpadding=0 border=0>
  <tr>
    <td>
      &nbsp;
    </td>
    <td>

<p>
End a session. 
<p>
Does a logout, but does not detach from the server. It is possible to create a new session via <a class="el" href="group__loginout.html#ga4">sqlo_session_begin</a>.<p>
<dl compact><dt><b>Attention:</b></dt><dd>Closing a session this way, means also to close all the cursors. Oracle is doing an implicit commit. This is maybe not be what you want.</dd></dl>
<dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign=top><em>dbh</em>&nbsp;</td><td>I - A database handle</td></tr>
  </table>
</dl>
<dl compact><dt><b>Returns:</b></dt><dd><ul>
<li>
SQLO_SUCCESS </li>
<li>
&lt; 0 on error </li>
</ul>
</dd></dl>
<dl compact><dt><b>See also:</b></dt><dd><a class="el" href="group__loginout.html#ga4">sqlo_session_begin</a> </dd></dl>
<dl compact><dt><b>Since:</b></dt><dd>Version 2.2 </dd></dl>

<p>
Definition at line <a class="el" href="sqlora_8c-source.html#l06221">6221</a> of file <a class="el" href="sqlora_8c-source.html">sqlora.c</a>.
<p>
References <a class="el" href="sqlora_8c-source.html#l04231">_close_all_db_cursors()</a>, <a class="el" href="sqlora_8c.html#a49">_dbv</a>, <a class="el" href="sqlora_8c-source.html#l04319">_get_trace_fp()</a>, <a class="el" href="sqlora_8c-source.html#l00865">_trace_fp</a>, <a class="el" href="sqlora_8c-source.html#l00487">_sqlo_db_struct::authp</a>, <a class="el" href="sqlora_8c-source.html#l00416">CHECK_OCI_STATUS_RETURN</a>, <a class="el" href="sqlora_8c-source.html#l00483">_sqlo_db_struct::errhp</a>, <a class="el" href="sqlora_8c-source.html#l00223">FALSE</a>, <a class="el" href="sqlora_8c-source.html#l00508">_sqlo_db_struct::session_created</a>, <a class="el" href="sqlora_8h-source.html#l00309">sqlo_db_handle_t</a>, <a class="el" href="sqlora_8c.html#a30">sqlo_db_struct_ptr_t</a>, <a class="el" href="group__constants.html#gga4a34">SQLO_INVALID_DB_HANDLE</a>, <a class="el" href="sqlora_8c-source.html#l00493">_sqlo_db_struct::status</a>, <a class="el" href="sqlora_8c-source.html#l00485">_sqlo_db_struct::svchp</a>, <a class="el" href="sqlora_8c-source.html#l00238">TRACE</a>, <a class="el" href="sqlora_8c-source.html#l00506">_sqlo_db_struct::used</a>, and <a class="el" href="sqlora_8c-source.html#l00435">VALID_DBH_RANGE</a>.
<p>
Referenced by <a class="el" href="sqlora_8c-source.html#l06318">sqlo_finish()</a>, and <a class="el" href="sqlora_8c-source.html#l06147">sqlo_server_detach()</a>.    </td>
  </tr>
</table>

<p>
Here is the call graph for this function:<p><center><img src="group__loginout_ga7_cgraph.png" border="0" usemap="#group__loginout_ga7_cgraph_map" alt=""></center>
<map name="group__loginout_ga7_cgraph_map">
<area href="sqlora_8c.html#a126" shape="rect" coords="183,197,329,215" alt="">
<area href="sqlora_8c.html#a128" shape="rect" coords="549,218,645,237" alt="">
<area href="sqlora_8c.html#a125" shape="rect" coords="384,175,488,194" alt="">
<area href="sqlora_8c.html#a123" shape="rect" coords="377,218,495,237" alt="">
<area href="group__easy.html#ga14" shape="rect" coords="399,133,473,151" alt="">
<area href="sqlora_8c.html#a104" shape="rect" coords="548,47,647,66" alt="">
<area href="sqlora_8c.html#a120" shape="rect" coords="543,90,652,109" alt="">
<area href="sqlora_8c.html#a110" shape="rect" coords="556,133,639,151" alt="">
<area href="sqlora_8c.html#a109" shape="rect" coords="551,175,644,194" alt="">
<area href="sqlora_8c.html#a103" shape="rect" coords="549,5,645,23" alt="">
</map>
<a class="anchor" name="ga2" doxytag="sqlora.h::sqlo_split_cstring" ></a><p>
<table class="mdTable" width="100%" cellpadding="2" cellspacing="0">
  <tr>
    <td class="mdRow">
      <table cellpadding="0" cellspacing="0" border="0">
        <tr>
          <td class="md" nowrap valign="top"> int sqlo_split_cstring </td>
          <td class="md" valign="top">(&nbsp;</td>
          <td class="md" nowrap valign="top">const char *&nbsp;</td>
          <td class="mdname" nowrap> <em>cstr</em>, </td>
        </tr>
        <tr>
          <td class="md" nowrap align="right"></td>
          <td></td>
          <td class="md" nowrap>char *&nbsp;</td>
          <td class="mdname" nowrap> <em>uid</em>, </td>
        </tr>
        <tr>
          <td class="md" nowrap align="right"></td>
          <td></td>
          <td class="md" nowrap>char *&nbsp;</td>
          <td class="mdname" nowrap> <em>pwd</em>, </td>
        </tr>
        <tr>
          <td class="md" nowrap align="right"></td>
          <td></td>
          <td class="md" nowrap>char *&nbsp;</td>
          <td class="mdname" nowrap> <em>tnsname</em>, </td>
        </tr>
        <tr>
          <td class="md" nowrap align="right"></td>
          <td></td>
          <td class="md" nowrap>unsigned int&nbsp;</td>
          <td class="mdname" nowrap> <em>bufsize</em></td>
        </tr>
        <tr>
          <td></td>
          <td class="md">)&nbsp;</td>
          <td class="md" colspan="2"></td>
        </tr>

      </table>
    </td>
  </tr>
</table>
<table cellspacing=5 cellpadding=0 border=0>
  <tr>
    <td>
      &nbsp;
    </td>
    <td>

<p>
Split an Oracle connect string. 
<p>
Splits an Oracle connect string of the form uid[[/pwd]@tnsname] into its components. If no tnsname is found in the cstr, we copy the value of the env. variable ORACLE_SID into tnsname.<p>
<dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign=top><em>cstr</em>&nbsp;</td><td>I - A connect string to split </td></tr>
    <tr><td valign=top><em>uid</em>&nbsp;</td><td>O - The returned uid part. </td></tr>
    <tr><td valign=top><em>pwd</em>&nbsp;</td><td>O - The returned pwd part. </td></tr>
    <tr><td valign=top><em>tnsname</em>&nbsp;</td><td>O - The returned tnsname. </td></tr>
    <tr><td valign=top><em>bufsize</em>&nbsp;</td><td>I - The capacity of the output buffers.</td></tr>
  </table>
</dl>
<dl compact><dt><b>Returns:</b></dt><dd><ul>
<li>
SQLO_SUCCESS </li>
<li>
SQLO_ERROR (buffer too small) </li>
</ul>
</dd></dl>
<dl compact><dt><b>Since:</b></dt><dd>Version 2.2 </dd></dl>

<p>
Definition at line <a class="el" href="sqlora_8c-source.html#l05764">5764</a> of file <a class="el" href="sqlora_8c-source.html">sqlora.c</a>.
<p>
References <a class="el" href="group__constants.html#gga3a26">SQLO_ERROR</a>, and <a class="el" href="group__constants.html#gga3a25">SQLO_SUCCESS</a>.
<p>
Referenced by <a class="el" href="sqlora_8c-source.html#l06271">sqlo_connect()</a>, <a class="el" href="sqlora_8c-source.html#l05831">sqlo_server_attach()</a>, and <a class="el" href="sqlora_8c-source.html#l06029">sqlo_session_begin()</a>.    </td>
  </tr>
</table>
<hr size="1"><address style="align: right;"><small>Generated on Sun Jun 13 04:51:42 2004 for libsqlora8 by
<a href="http://www.doxygen.org/index.html">
<img src="doxygen.png" alt="doxygen" align="middle" border=0 > </a>1.3.6 </small></address>
</body>
</html>