group__loginout.html

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

  <span class="comment">/* ex12.c */</span>
  printf(<span class="stringliteral">"Employees with salary &gt;= 1200:\n"</span>);
  do_array_select(dbh, 1200);


  RETURN_ON_ABORT; <span class="comment">/* finish if SIGINT was catched */</span>

  <span class="comment">/* ex13.c */</span>
  insert_into_blob_table(dbh, 1);

  RETURN_ON_ABORT; <span class="comment">/* finish if SIGINT was catched */</span>

  <span class="comment">/* ex13b.c */</span>
  update_blob_table(dbh, 1);

  RETURN_ON_ABORT; <span class="comment">/* finish if SIGINT was catched */</span>

  <span class="comment">/* ex14.c */</span>
  insert_file_into_blob_table(dbh, 2, <span class="stringliteral">"examples"</span>);

  RETURN_ON_ABORT; <span class="comment">/* finish if SIGINT was catched */</span>

  <span class="comment">/* ex15.c */</span>
  select_from_blob_table(dbh, 1);

  RETURN_ON_ABORT; <span class="comment">/* finish if SIGINT was catched */</span>

  <span class="comment">/* ex16.c */</span>
  select_file_from_blob_table(dbh, 2, <span class="stringliteral">"examples.cmp"</span>);
  <span class="keywordflow">if</span> ( 0 != system(<span class="stringliteral">"diff -q examples examples.cmp"</span>)) {
    printf(<span class="stringliteral">"ERROR: examples is different from examples.cmp!!!\n"</span>);
  }
  <a class="code" href="group__transactions.html#ga184">sqlo_rollback</a>(dbh);

  RETURN_ON_ABORT; <span class="comment">/* finish if SIGINT was catched */</span>
  <span class="comment">/* ex17.c */</span>
  printf(<span class="stringliteral">"Employees with salary (via refcursor) &gt;= 1200:\n"</span>);
  select_refcursor(dbh, 1200);

  RETURN_ON_ABORT; <span class="comment">/* finish if SIGINT was catched */</span>
  <span class="comment">/* ex18.c */</span>
  printf(<span class="stringliteral">"Employees with salary (via refcursor with bind vars) &gt;= 1200:\n"</span>);
  select_refcursor2(dbh, 1200);

  RETURN_ON_ABORT; <span class="comment">/* finish if SIGINT was catched */</span>
  <span class="comment">/* ex19.c */</span>
  printf(<span class="stringliteral">"Employees, departements and locations via ntable\n"</span>);
  select_ntable(dbh);

  <span class="comment">/* rollback */</span>
  <a class="code" href="group__transactions.html#ga184">sqlo_rollback</a>(dbh);

  <span class="comment">/* logout */</span>
  <a class="code" href="group__loginout.html#ga181">sqlo_finish</a>(dbh);

  <span class="keywordflow">return</span> EXIT_SUCCESS;
}
<span class="comment">/* $Id: examples.c,v 1.6 2004/01/03 16:48:19 kpoitschke Exp $ */</span>
</pre></div> </dd></dl>
<dl compact><dt><b>See also:</b></dt><dd><a class="el" href="group__loginout.html#ga1">sqlo_finish</a>, <a class="el" href="group__loginout.html#ga3">sqlo_server_attach</a>, <a class="el" href="group__loginout.html#ga4">sqlo_session_begin</a> </dd></dl>

<p>
Definition at line <a class="el" href="sqlora_8c-source.html#l06271">6271</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#l00869">_errmsg</a>, <a class="el" href="sqlora_8c-source.html#l04319">_get_trace_fp()</a>, <a class="el" href="group__constants.html#gga3a26">SQLO_ERROR</a>, <a class="el" href="sqlora_8c-source.html#l04750">sqlo_geterror()</a>, <a class="el" href="sqlora_8c-source.html#l05831">sqlo_server_attach()</a>, <a class="el" href="sqlora_8c-source.html#l06196">sqlo_server_free()</a>, <a class="el" href="sqlora_8c-source.html#l06029">sqlo_session_begin()</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>, and <a class="el" href="sqlora_8c-source.html#l00238">TRACE</a>.    </td>
  </tr>
</table>

<p>
Here is the call graph for this function:<p><center><img src="group__loginout_ga0_cgraph.png" border="0" usemap="#group__loginout_ga0_cgraph_map" alt=""></center>
<map name="group__loginout_ga0_cgraph_map">
<area href="sqlora_8c.html#a128" shape="rect" coords="585,114,681,133" alt="">
<area href="group__error.html#ga0" shape="rect" coords="179,12,269,30" alt="">
<area href="group__loginout.html#ga3" shape="rect" coords="161,322,287,341" alt="">
<area href="group__loginout.html#ga2" shape="rect" coords="364,472,476,490" alt="">
<area href="group__loginout.html#ga6" shape="rect" coords="168,258,280,277" alt="">
<area href="group__loginout.html#ga4" shape="rect" coords="160,494,288,513" alt="">
<area href="sqlora_8c.html#a112" shape="rect" coords="387,386,453,405" alt="">
<area href="sqlora_8c.html#a113" shape="rect" coords="376,258,464,277" alt="">
<area href="sqlora_8c.html#a85" shape="rect" coords="383,344,457,362" alt="">
<area href="sqlora_8c.html#a86" shape="rect" coords="376,429,464,448" alt="">
<area href="sqlora_8c.html#a146" shape="rect" coords="396,301,444,320" alt="">
<area href="sqlora_8c.html#a142" shape="rect" coords="597,384,669,402" alt="">
<area href="sqlora_8c.html#a83" shape="rect" coords="596,248,671,266" alt="">
<area href="sqlora_8c.html#a84" shape="rect" coords="589,341,677,360" alt="">
<area href="sqlora_8c.html#a141" shape="rect" coords="563,426,704,445" alt="">
<area href="sqlora_8c.html#a130" shape="rect" coords="581,469,685,488" alt="">
<area href="sqlora_8c.html#a143" shape="rect" coords="591,512,676,530" alt="">
<area href="sqlora_8c.html#a148" shape="rect" coords="772,272,860,290" alt="">
<area href="sqlora_8c.html#a149" shape="rect" coords="765,449,867,468" alt="">
<area href="sqlora_8c.html#a100" shape="rect" coords="551,162,716,181" alt="">
<area href="sqlora_8c.html#a103" shape="rect" coords="585,205,681,224" alt="">
<area href="sqlora_8c.html#a118" shape="rect" coords="587,605,680,624" alt="">
<area href="sqlora_8c.html#a99" shape="rect" coords="339,608,501,626" alt="">
<area href="group__error.html#ga1" shape="rect" coords="365,565,475,584" alt="">
</map>
<a class="anchor" name="ga1" doxytag="sqlora.h::sqlo_finish" ></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_finish </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>
Finish the session. 
<p>
Finish the session with implicit commit. This is the short form of <a class="el" href="group__loginout.html#ga7">sqlo_session_end</a> followed by <a class="el" href="group__loginout.html#ga5">sqlo_server_detach</a>.<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>
  </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#ga0">sqlo_connect</a>, <a class="el" href="group__loginout.html#ga7">sqlo_session_end</a>, <a class="el" href="group__loginout.html#ga5">sqlo_server_detach</a>, <a class="el" href="group__loginout.html#ga3">sqlo_server_attach</a> </dd></dl>

<p>
Definition at line <a class="el" href="sqlora_8c-source.html#l06318">6318</a> of file <a class="el" href="sqlora_8c-source.html">sqlora.c</a>.
<p>
References <a class="el" href="sqlora_8c-source.html#l00869">_errmsg</a>, <a class="el" href="sqlora_8c-source.html#l04319">_get_trace_fp()</a>, <a class="el" href="sqlora_8c-source.html#l00340">CHECK_DBHANDLE</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="sqlora_8c-source.html#l04750">sqlo_geterror()</a>, <a class="el" href="group__constants.html#gga4a34">SQLO_INVALID_DB_HANDLE</a>, <a class="el" href="sqlora_8c-source.html#l06147">sqlo_server_detach()</a>, <a class="el" href="sqlora_8c-source.html#l06196">sqlo_server_free()</a>, <a class="el" href="sqlora_8c-source.html#l06221">sqlo_session_end()</a>, <a class="el" href="group__constants.html#gga3a25">SQLO_SUCCESS</a>, and <a class="el" href="sqlora_8c-source.html#l00238">TRACE</a>.    </td>
  </tr>
</table>

<p>
Here is the call graph for this function:<p><center><img src="group__loginout_ga1_cgraph.png" border="0" usemap="#group__loginout_ga1_cgraph_map" alt=""></center>
<map name="group__loginout_ga1_cgraph_map">
<area href="sqlora_8c.html#a128" shape="rect" coords="519,197,615,215" alt="">
<area href="group__error.html#ga0" shape="rect" coords="332,263,423,282" alt="">
<area href="group__loginout.html#ga5" shape="rect" coords="141,167,269,186" alt="">
<area href="group__loginout.html#ga7" shape="rect" coords="319,306,436,325" alt="">
<area href="group__loginout.html#ga6" shape="rect" coords="149,115,261,134" alt="">
<area href="sqlora_8c.html#a113" shape="rect" coords="333,69,421,87" alt="">
<area href="sqlora_8c.html#a100" shape="rect" coords="484,90,649,109" alt="">
<area href="sqlora_8c.html#a83" shape="rect" coords="529,133,604,151" alt="">
<area href="sqlora_8c.html#a84" shape="rect" coords="523,5,611,23" alt="">
<area href="sqlora_8c.html#a103" shape="rect" coords="519,47,615,66" alt="">
<area href="sqlora_8c.html#a126" shape="rect" coords="493,306,640,325" alt="">
</map>
<a class="anchor" name="ga8" doxytag="sqlora.h::sqlo_getdatabase" ></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"> const char* sqlo_getdatabase </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>
Returns the tnsname. 
<p>
Returns the tnsname (or service name) of the given dbh. <dl compact><dt><b>Attention:</b></dt><dd>The function returns the database name passed to <a class="el" href="group__loginout.html#ga0">sqlo_connect</a> or <a class="el" href="group__loginout.html#ga3">sqlo_server_attach</a>, not the real SID, which can be different!</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>The tnsname or NULL in case of an invalid dbh </dd></dl>

<p>
Definition at line <a class="el" href="sqlora_8c-source.html#l06356">6356</a> of file <a class="el" href="sqlora_8c-source.html">sqlora.c</a>.
<p>
References <a class="el" href="sqlora_8c-source.html#l04319">_get_trace_fp()</a>, <a class="el" href="sqlora_8c-source.html#l00340">CHECK_DBHANDLE</a>, <a class="el" href="sqlora_8c-source.html#l00495">_sqlo_db_struct::errmsg</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="sqlora_8c-source.html#l00491">_sqlo_db_struct::tnsname</a>, and <a class="el" href="sqlora_8c-source.html#l00238">TRACE</a>.    </td>
  </tr>
</table>

<p>
Here is the call graph for this function:<p><center><img src="group__loginout_ga8_cgraph.png" border="0" usemap="#group__loginout_ga8_cgraph_map" alt=""></center>
<map name="group__loginout_ga8_cgraph_map">
<area href="sqlora_8c.html#a128" shape="rect" coords="185,5,281,23" alt="">
</map>
<a class="anchor" name="ga3" doxytag="sqlora.h::sqlo_server_attach" ></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_server_attach </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="mdname" nowrap> <em>dbhp</em>, </td>