group__misc.html

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

Definition at line <a class="el" href="sqlora_8c-source.html#l07898">7898</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#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.html#a30">sqlo_db_struct_ptr_t</a>, <a class="el" href="group__constants.html#gga4a36">SQLO_INVALID_STMT_HANDLE</a>, <a class="el" href="sqlora_8c-source.html#l00481">_sqlo_db_struct::srvhp</a>, <a class="el" href="sqlora_8c-source.html#l00493">_sqlo_db_struct::status</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__misc_ga6_cgraph.png" border="0" usemap="#group__misc_ga6_cgraph_map" alt=""></center>
<map name="group__misc_ga6_cgraph_map">
<area href="sqlora_8c.html#a128" shape="rect" coords="196,5,292,23" alt="">
</map>
<a class="anchor" name="ga2" doxytag="sqlora.h::sqlo_set_blocking" ></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_set_blocking </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>dbh</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>on</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>
Set OCI blocking mode on/off. 
<p>
By default a database connection is in blocking mode. This means the call does not return until the task is finished. With this function you can change to non-blocking mode. In this case some functions can return SQLO_STILL_EXECUTING.<p>
The functions are: <ul>
<li>
sqlo_open2 (when called for queries) </li>
<li>
sqlo_reopen (when called for queries) </li>
<li>
sqlo_fetch (when called for non-queries) </li>
<li>
sqlo_exec </li>
<li>
sqlo_execute </li>
</ul>
<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 where the blocking should be changed. </td></tr>
    <tr><td valign=top><em>on</em>&nbsp;</td><td>I - SQLO_ON switches blocking mode on, SQLO_OFF switches to non-blocking mode </td></tr>
  </table>
</dl>
<dl compact><dt><b>Returns:</b></dt><dd><ul>
<li>
SQLO_SUCCESS </li>
<li>
SQLO_INVALID_DB_HANDLE </li>
<li>
&lt; 0 on error </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#l07226">7226</a> of file <a class="el" href="sqlora_8c-source.html">sqlora.c</a>.
<p>
References <a class="el" href="sqlora_8c-source.html#l04271">_get_blocking_mode()</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#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.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="group__constants.html#gga5a45">SQLO_OFF</a>, <a class="el" href="group__constants.html#gga5a46">SQLO_ON</a>, <a class="el" href="sqlora_8c-source.html#l00481">_sqlo_db_struct::srvhp</a>, <a class="el" href="sqlora_8c-source.html#l00493">_sqlo_db_struct::status</a>, and <a class="el" href="sqlora_8c-source.html#l00238">TRACE</a>.
<p>
Referenced by <a class="el" href="sqlora_8c-source.html#l05152">sqlo_open()</a>.    </td>
  </tr>
</table>

<p>
Here is the call graph for this function:<p><center><img src="group__misc_ga2_cgraph.png" border="0" usemap="#group__misc_ga2_cgraph_map" alt=""></center>
<map name="group__misc_ga2_cgraph_map">
<area href="sqlora_8c.html#a152" shape="rect" coords="185,5,324,24" alt="">
<area href="sqlora_8c.html#a128" shape="rect" coords="372,29,468,48" alt="">
</map>
<a class="anchor" name="ga5" doxytag="sqlora.h::sqlo_set_prefetch_rows" ></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_set_prefetch_rows </td>
          <td class="md" valign="top">(&nbsp;</td>
          <td class="md" nowrap valign="top"><a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a>&nbsp;</td>
          <td class="mdname" nowrap> <em>sth</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>nrows</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>
Set the prefetch row attribute for a statement. 
<p>
This functions sets the oci attribute OCI_ATTR_PREFETCH_ROWS to the given value. <dl compact><dt><b>Note:</b></dt><dd>This does not affect the global setting passed by the enviroment variable SQLORA_PREFETCH_ROWS. </dd></dl>
<dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign=top><em>sth</em>&nbsp;</td><td>I - The statement handle </td></tr>
    <tr><td valign=top><em>nrows</em>&nbsp;</td><td>I - The value of the attribute. </td></tr>
  </table>
</dl>
<dl compact><dt><b>Returns:</b></dt><dd>SQLO_SUCCESS or &lt; 0 on error </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#l07876">7876</a> of file <a class="el" href="sqlora_8c-source.html">sqlora.c</a>.
<p>
References <a class="el" href="sqlora_8c-source.html#l01457">_set_prefetch_rows()</a>, <a class="el" href="sqlora_8c-source.html#l00416">CHECK_OCI_STATUS_RETURN</a>, <a class="el" href="sqlora_8c-source.html#l00367">CHECK_STHANDLE</a>, <a class="el" href="sqlora_8c-source.html#l00565">_sqlo_stmt_struct::dbp</a>, <a class="el" href="sqlora_8c.html#a30">sqlo_db_struct_ptr_t</a>, <a class="el" href="group__constants.html#gga4a36">SQLO_INVALID_STMT_HANDLE</a>, <a class="el" href="sqlora_8c.html#a35">sqlo_stmt_struct_ptr_t</a>, and <a class="el" href="sqlora_8c-source.html#l00493">_sqlo_db_struct::status</a>.    </td>
  </tr>
</table>

<p>
Here is the call graph for this function:<p><center><img src="group__misc_ga5_cgraph.png" border="0" usemap="#group__misc_ga5_cgraph_map" alt=""></center>
<map name="group__misc_ga5_cgraph_map">
<area href="sqlora_8c.html#a119" shape="rect" coords="217,5,345,23" alt="">
</map>
<a class="anchor" name="ga10" doxytag="sqlora.h::sqlo_trace" ></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_trace </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>dbh</em>, </td>
        </tr>
        <tr>
          <td class="md" nowrap align="right"></td>
          <td></td>
          <td class="md" nowrap>int&nbsp;</td>
          <td class="mdname" nowrap> <em>on</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>
Switches Oracle trace on/off. 
<p>
Use this to switch the Oracle trace facility (tkprof) on or off.<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>on</em>&nbsp;</td><td>I - A flag indicating if we switch tracing on (SQLO_ON) or off (SQLO_OFF)</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>

<p>
Definition at line <a class="el" href="sqlora_8c-source.html#l04733">4733</a> of file <a class="el" href="sqlora_8c-source.html">sqlora.c</a>.
<p>
References <a class="el" href="sqlora_8c-source.html#l05046">sqlo_exec()</a>.    </td>
  </tr>
</table>

<p>
Here is the call graph for this function:<p><center><img src="group__misc_ga10_cgraph.png" border="0" usemap="#group__misc_ga10_cgraph_map" alt=""></center>
<map name="group__misc_ga10_cgraph_map">
<area href="group__easy.html#ga15" shape="rect" coords="140,5,215,23" alt="">
<area href="sqlora_8c.html#a128" shape="rect" coords="263,5,359,23" alt="">
</map>
<hr size="1"><address style="align: right;"><small>Generated on Sun Jun 13 04:51:43 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>