group__misc.html

来自「一个很好用的Linux/Unix下Oracle OCI开发接口封装库」· HTML 代码 · 共 711 行 · 第 1/2 页

  </tr>
</table>
<a name="a7" doxytag="sqlora.h::sqlo_get_stmt_state"></a><p>
<table width="100%" cellpadding="2" cellspacing="0" border="0">
  <tr>
    <td class="md">
      <table cellpadding="0" cellspacing="0" border="0">
        <tr>
          <td class="md" nowrap valign="top"> int sqlo_get_stmt_state </td>
          <td class="md" valign="top">(&nbsp;</td>
          <td class="md" nowrap valign="top"><a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a>&nbsp;</td>
          <td class="mdname1" valign="top" nowrap>&nbsp; <em>sth</em>          </td>
          <td class="md" valign="top">)&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>
Get the state of the statement.
<p>
<dl compact><dt><b>Note: </b></dt><dd>
Don't use this in Oracle versions &lt; 9.0!  </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 - A statement handle </td></tr>
</table>
</dl><dl compact><dt><b>Returns: </b></dt><dd>
The state (see @sqlo_statement_states) or &lt; 0 n error. </dl><dl compact><dt><b>Since: </b></dt><dd>
Version 2.2 </dl>    </td>
  </tr>
</table>
<a name="a11" doxytag="sqlora.h::sqlo_print"></a><p>
<table width="100%" cellpadding="2" cellspacing="0" border="0">
  <tr>
    <td class="md">
      <table cellpadding="0" cellspacing="0" border="0">
        <tr>
          <td class="md" nowrap valign="top"> int sqlo_print </td>
          <td class="md" valign="top">(&nbsp;</td>
          <td class="md" nowrap valign="top"><a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a>&nbsp;</td>
          <td class="mdname1" valign="top" nowrap>&nbsp; <em>sth</em>          </td>
          <td class="md" valign="top">)&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>
Print info about the statement to stdout.
<p>
<dl compact><dt><b><a class="el" href="deprecated.html#_deprecated000002">Deprecated: </a></b></dt><dd>
This function will not be enhanced or maintained. This is a kind of debuging code, but better use the builtin trace facility.</dl>
<p>
<dl compact><dt><b>Returns: </b></dt><dd>
<ul>
<li>SQLO_SUCCESS <li> &lt; 0 on error </ul>
</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>
A statement handle </td></tr>
</table>
</dl>    </td>
  </tr>
</table>
<a name="a12" doxytag="sqlora.h::sqlo_register_int_handler"></a><p>
<table width="100%" cellpadding="2" cellspacing="0" border="0">
  <tr>
    <td class="md">
      <table cellpadding="0" cellspacing="0" border="0">
        <tr>
          <td class="md" nowrap valign="top"> int sqlo_register_int_handler </td>
          <td class="md" valign="top">(&nbsp;</td>
          <td class="md" nowrap valign="top">int *&nbsp;</td>
          <td class="mdname" nowrap>&nbsp; <em>handle</em>, </td>
        </tr>
        <tr>
          <td></td>
          <td></td>
          <td class="md" nowrap><a class="el" href="group__typedefs.html#a3">sqlo_signal_handler_t</a>&nbsp;</td>
          <td class="mdname" nowrap>&nbsp; <em>signal_handler</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>
Register a signal handler for interrupts.
<p>
Because oracle catches SIGINT, you can register here a handler, which is called by oracle, when SIGINT is catched. <dl compact><dt><b>Note: </b></dt><dd>
Don't do any database operation in this handler. </dl><dl compact><dt><b>Parameters: </b></dt><dd>
<table border=0 cellspacing=2 cellpadding=0>
<tr><td valign=top><em>handle</em>&nbsp;</td><td>
O - The created handle. Needed by <a class="el" href="group__misc.html#a13">Miscellaneous functions</a> to  clear a signal handler </td></tr>
<tr><td valign=top><em>signal_handler</em>&nbsp;</td><td>
I - The address of the signal handler to register.</td></tr>
</table>
</dl><dl compact><dt><b>Returns: </b></dt><dd>
SQLO_SUCCESS or SQLO_ERROR on error. </dl>    </td>
  </tr>
</table>
<a name="a6" doxytag="sqlora.h::sqlo_server_version"></a><p>
<table width="100%" cellpadding="2" cellspacing="0" border="0">
  <tr>
    <td class="md">
      <table cellpadding="0" cellspacing="0" border="0">
        <tr>
          <td class="md" nowrap valign="top"> int sqlo_server_version </td>
          <td class="md" valign="top">(&nbsp;</td>
          <td class="md" nowrap valign="top"><a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a>&nbsp;</td>
          <td class="mdname" nowrap>&nbsp; <em>dbh</em>, </td>
        </tr>
        <tr>
          <td></td>
          <td></td>
          <td class="md" nowrap>char *&nbsp;</td>
          <td class="mdname" nowrap>&nbsp; <em>bufp</em>, </td>
        </tr>
        <tr>
          <td></td>
          <td></td>
          <td class="md" nowrap>unsigned int&nbsp;</td>
          <td class="mdname" nowrap>&nbsp; <em>buflen</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>
Get the server version string.
<p>
Returns the server version string which might look like this: <div class="fragment"><pre>
   Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
   With the Partitioning and Java options
   PL/SQL Release 8.1.5.0.0 - Production.
  </pre></div> The buffer is null terminated. <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 - The database handle </td></tr>
<tr><td valign=top><em>bufp</em>&nbsp;</td><td>
O - The version string </td></tr>
<tr><td valign=top><em>buflen</em>&nbsp;</td><td>
I - Supply her the capacity of your buffer. </td></tr>
</table>
</dl><dl compact><dt><b>Returns: </b></dt><dd>
SQLO_SUCCESS or &lt; 0 on error. </dl><dl compact><dt><b>Since: </b></dt><dd>
Version 2.2 </dl>    </td>
  </tr>
</table>
<a name="a2" doxytag="sqlora.h::sqlo_set_blocking"></a><p>
<table width="100%" cellpadding="2" cellspacing="0" border="0">
  <tr>
    <td class="md">
      <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#a0">sqlo_db_handle_t</a>&nbsp;</td>
          <td class="mdname" nowrap>&nbsp; <em>dbh</em>, </td>
        </tr>
        <tr>
          <td></td>
          <td></td>
          <td class="md" nowrap>unsigned int&nbsp;</td>
          <td class="mdname" nowrap>&nbsp; <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>sqlo_reopen (when called for queries) <li>sqlo_fetch (when called for non-queries) <li>sqlo_exec <li>sqlo_execute </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>SQLO_INVALID_DB_HANDLE <li> &lt; 0 on error </ul>
</dl><dl compact><dt><b>Since: </b></dt><dd>
Version 2.2 </dl>    </td>
  </tr>
</table>
<a name="a5" doxytag="sqlora.h::sqlo_set_prefetch_rows"></a><p>
<table width="100%" cellpadding="2" cellspacing="0" border="0">
  <tr>
    <td class="md">
      <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#a1">sqlo_stmt_handle_t</a>&nbsp;</td>
          <td class="mdname" nowrap>&nbsp; <em>sth</em>, </td>
        </tr>
        <tr>
          <td></td>
          <td></td>
          <td class="md" nowrap>unsigned int&nbsp;</td>
          <td class="mdname" nowrap>&nbsp; <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. </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 </dl><dl compact><dt><b>Since: </b></dt><dd>
Version 2.2 </dl>    </td>
  </tr>
</table>
<a name="a10" doxytag="sqlora.h::sqlo_trace"></a><p>
<table width="100%" cellpadding="2" cellspacing="0" border="0">
  <tr>
    <td class="md">
      <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#a0">sqlo_db_handle_t</a>&nbsp;</td>
          <td class="mdname" nowrap>&nbsp; <em>dbh</em>, </td>
        </tr>
        <tr>
          <td></td>
          <td></td>
          <td class="md" nowrap>int&nbsp;</td>
          <td class="mdname" nowrap>&nbsp; <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.<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> &lt; 0 on error </ul>
</dl>    </td>
  </tr>
</table>
<hr><address style="align: right;"><small>Generated on Thu Aug 14 18:02:53 2003 for libsqlora8 by
<a href="http://www.doxygen.org/index.html">
<img src="doxygen.png" alt="doxygen" align="middle" border=0 
width=110 height=53></a>1.2.18 </small></address>
</body>
</html>