group__misc.html

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

<area href="sqlora_8c.html#a120" shape="rect" coords="161,5,271,23" alt="">
</map>
<a class="anchor" name="ga7" doxytag="sqlora.h::sqlo_get_stmt_state" ></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_get_stmt_state </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="mdname1" valign="top" nowrap> <em>sth</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>
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! </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 - A statement handle </td></tr>
  </table>
</dl>
<dl compact><dt><b>Returns:</b></dt><dd>The state (see <a class="el" href="group__constants.html#ga7">sqlo_statement_states</a>) or &lt; 0 n 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#l04594">4594</a> of file <a class="el" href="sqlora_8c-source.html">sqlora.c</a>.
<p>
References <a class="el" href="sqlora_8c-source.html#l01521">_get_stmt_state()</a>, <a class="el" href="sqlora_8c-source.html#l00367">CHECK_STHANDLE</a>, <a class="el" href="group__constants.html#gga4a36">SQLO_INVALID_STMT_HANDLE</a>, and <a class="el" href="sqlora_8c.html#a35">sqlo_stmt_struct_ptr_t</a>.    </td>
  </tr>
</table>

<p>
Here is the call graph for this function:<p><center><img src="group__misc_ga7_cgraph.png" border="0" usemap="#group__misc_ga7_cgraph_map" alt=""></center>
<map name="group__misc_ga7_cgraph_map">
<area href="sqlora_8c.html#a121" shape="rect" coords="197,5,301,23" alt="">
</map>
<a class="anchor" name="ga11" doxytag="sqlora.h::sqlo_print" ></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_print </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="mdname1" valign="top" nowrap> <em>sth</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>
Print info about the statement to stdout. 
<p>
<dl compact><dt><b><a class="el" href="deprecated.html#_deprecated000003">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. </dd></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>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>

<p>
Definition at line <a class="el" href="sqlora_8c-source.html#l05711">5711</a> of file <a class="el" href="sqlora_8c-source.html">sqlora.c</a>.
<p>
References <a class="el" href="sqlora_8c-source.html#l02822">_get_data_type_str()</a>, <a class="el" href="sqlora_8c-source.html#l02688">_get_stmt_type_str()</a>, <a class="el" href="sqlora_8c-source.html#l02805">_is_opened()</a>, <a class="el" href="sqlora_8c-source.html#l02785">_is_prepared()</a>, <a class="el" href="sqlora_8c-source.html#l02746">_is_query()</a>, <a class="el" href="sqlora_8c-source.html#l03873">_set_all_ocol_names()</a>, <a class="el" href="sqlora_8c-source.html#l00579">_sqlo_stmt_struct::bindpv_size</a>, <a class="el" href="sqlora_8c-source.html#l00367">CHECK_STHANDLE</a>, <a class="el" href="sqlora_8c-source.html#l00538">_sqlo_col_struct::col_name</a>, <a class="el" href="sqlora_8c-source.html#l00542">_sqlo_col_struct::dbsize</a>, <a class="el" href="sqlora_8c-source.html#l00536">_sqlo_col_struct::dtype</a>, <a class="el" href="sqlora_8c-source.html#l00548">_sqlo_col_struct::nullok</a>, <a class="el" href="sqlora_8c-source.html#l00577">_sqlo_stmt_struct::num_bindpv</a>, <a class="el" href="sqlora_8c-source.html#l00590">_sqlo_stmt_struct::num_defnpv</a>, <a class="el" href="sqlora_8c-source.html#l00586">_sqlo_stmt_struct::ocolsv</a>, <a class="el" href="sqlora_8c-source.html#l00601">_sqlo_stmt_struct::outv_size</a>, <a class="el" href="sqlora_8c-source.html#l00544">_sqlo_col_struct::prec</a>, <a class="el" href="sqlora_8c-source.html#l00546">_sqlo_col_struct::scale</a>, <a class="el" href="group__constants.html#gga4a36">SQLO_INVALID_STMT_HANDLE</a>, <a class="el" href="sqlora_8c-source.html#l05530">sqlo_prows()</a>, <a class="el" href="sqlora_8h-source.html#l00318">sqlo_stmt_handle_t</a>, <a class="el" href="sqlora_8c.html#a35">sqlo_stmt_struct_ptr_t</a>, <a class="el" href="group__constants.html#gga3a25">SQLO_SUCCESS</a>, <a class="el" href="sqlora_8c-source.html#l00562">_sqlo_stmt_struct::sth</a>, <a class="el" href="sqlora_8c-source.html#l00570">_sqlo_stmt_struct::stmt</a>, and <a class="el" href="sqlora_8c-source.html#l00581">_sqlo_stmt_struct::stype</a>.    </td>
  </tr>
</table>

<p>
Here is the call graph for this function:<p><center><img src="group__misc_ga11_cgraph.png" border="0" usemap="#group__misc_ga11_cgraph_map" alt=""></center>
<map name="group__misc_ga11_cgraph_map">
<area href="sqlora_8c.html#a111" shape="rect" coords="143,5,273,24" alt="">
<area href="sqlora_8c.html#a106" shape="rect" coords="145,48,271,66" alt="">
<area href="sqlora_8c.html#a110" shape="rect" coords="341,122,424,141" alt="">
<area href="sqlora_8c.html#a109" shape="rect" coords="161,141,255,160" alt="">
<area href="sqlora_8c.html#a107" shape="rect" coords="172,184,244,202" alt="">
<area href="sqlora_8c.html#a140" shape="rect" coords="139,296,277,314" alt="">
<area href="group__easy.html#ga17" shape="rect" coords="169,226,247,245" alt="">
<area href="sqlora_8c.html#a122" shape="rect" coords="332,352,433,370" alt="">
<area href="sqlora_8c.html#a128" shape="rect" coords="487,286,583,305" alt="">
<area href="sqlora_8c.html#a139" shape="rect" coords="328,309,437,328" alt="">
</map>
<a class="anchor" name="ga12" doxytag="sqlora.h::sqlo_register_int_handler" ></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_register_int_handler </td>
          <td class="md" valign="top">(&nbsp;</td>
          <td class="md" nowrap valign="top">int *&nbsp;</td>
          <td class="mdname" nowrap> <em>handle</em>, </td>
        </tr>
        <tr>
          <td class="md" nowrap align="right"></td>
          <td></td>
          <td class="md" nowrap><a class="el" href="group__typedefs.html#ga3">sqlo_signal_handler_t</a>&nbsp;</td>
          <td class="mdname" nowrap> <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. </dd></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#ga13">sqlo_clear_int_handler</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. </dd></dl>

<p>
Definition at line <a class="el" href="sqlora_8c-source.html#l08018">8018</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="sqlora_8h-source.html#l00348">sqlo_signal_handler_t</a>.    </td>
  </tr>
</table>
<a class="anchor" name="ga6" doxytag="sqlora.h::sqlo_server_version" ></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_version </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>char *&nbsp;</td>
          <td class="mdname" nowrap> <em>bufp</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>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: <pre class="fragment"><div>
   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.
  </div></pre>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. </dd></dl>
<dl compact><dt><b>Since:</b></dt><dd>Version 2.2 </dd></dl>

<p>