group__misc.html

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

  <tr>
    <td class="mdRow">
      <table cellpadding="0" cellspacing="0" border="0">
        <tr>
          <td class="md" nowrap valign="top"> int sqlo_get_db_handle </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>
Return the database handle of a statement handle. 
<p>
<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><ul>
<li>
The database handle </li>
<li>
&lt; 0 on error </li>
</ul>
</dd></dl>

<p>
Definition at line <a class="el" href="sqlora_8c-source.html#l07170">7170</a> of file <a class="el" href="sqlora_8c-source.html">sqlora.c</a>.
<p>
References <a class="el" href="sqlora_8c-source.html#l00865">_trace_fp</a>, <a class="el" href="sqlora_8c-source.html#l00367">CHECK_STHANDLE</a>, <a class="el" href="sqlora_8c-source.html#l00478">_sqlo_db_struct::dbh</a>, <a class="el" href="sqlora_8c-source.html#l00565">_sqlo_stmt_struct::dbp</a>, <a class="el" href="sqlora_8c-source.html#l00495">_sqlo_db_struct::errmsg</a>, <a class="el" href="group__constants.html#gga4a36">SQLO_INVALID_STMT_HANDLE</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="sqlora_8c-source.html#l00238">TRACE</a>, and <a class="el" href="sqlora_8c-source.html#l00620">_sqlo_stmt_struct::used</a>.    </td>
  </tr>
</table>
<a class="anchor" name="ga0" doxytag="sqlora.h::sqlo_get_oci_handle" ></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_oci_handle </td>
          <td class="md" valign="top">(&nbsp;</td>
          <td class="md" nowrap valign="top">int&nbsp;</td>
          <td class="mdname" nowrap> <em>sqloh</em>, </td>
        </tr>
        <tr>
          <td class="md" nowrap align="right"></td>
          <td></td>
          <td class="md" nowrap>void *&nbsp;</td>
          <td class="mdname" nowrap> <em>ocihp</em>, </td>
        </tr>
        <tr>
          <td class="md" nowrap align="right"></td>
          <td></td>
          <td class="md" nowrap><a class="el" href="group__typedefs.html#ga4">sqlo_oci_handle_types_e</a>&nbsp;</td>
          <td class="mdname" nowrap> <em>type</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 specified OCI handle. 
<p>
You can get the oci handles here, if you want to call other OCI functions.<p>
<dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign=top><em>sqloh</em>&nbsp;</td><td>I - Either a statement or a database handle depending on the handle type you want to get. </td></tr>
    <tr><td valign=top><em>ocihp</em>&nbsp;</td><td>O - The requested OCI handle. </td></tr>
    <tr><td valign=top><em>type</em>&nbsp;</td><td>I - The OCI handle type (see <a class="el" href="group__typedefs.html#ga4">sqlo_oci_handle_types_e</a>)</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__typedefs.html#ga4">sqlo_oci_handle_types_e</a> </dd></dl>

<p>
Definition at line <a class="el" href="sqlora_8c-source.html#l07118">7118</a> of file <a class="el" href="sqlora_8c-source.html">sqlora.c</a>.
<p>
References <a class="el" href="sqlora_8c-source.html#l00487">_sqlo_db_struct::authp</a>, <a class="el" href="sqlora_8c-source.html#l00340">CHECK_DBHANDLE</a>, <a class="el" href="sqlora_8c-source.html#l00367">CHECK_STHANDLE</a>, <a class="el" href="sqlora_8c-source.html#l00489">_sqlo_db_struct::envhp</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#gga4a40">SQLO_INVALID_OCI_HANDLE_TYPE</a>, <a class="el" href="group__constants.html#gga4a36">SQLO_INVALID_STMT_HANDLE</a>, <a class="el" href="group__typedefs.html#gga4a100">SQLO_OCI_HTYPE_ENV</a>, <a class="el" href="group__typedefs.html#gga4a101">SQLO_OCI_HTYPE_ERROR</a>, <a class="el" href="group__typedefs.html#gga4a103">SQLO_OCI_HTYPE_SERVER</a>, <a class="el" href="group__typedefs.html#gga4a104">SQLO_OCI_HTYPE_SESSION</a>, <a class="el" href="group__typedefs.html#gga4a105">SQLO_OCI_HTYPE_STMT</a>, <a class="el" href="group__typedefs.html#gga4a102">SQLO_OCI_HTYPE_SVCCTX</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#l00481">_sqlo_db_struct::srvhp</a>, <a class="el" href="sqlora_8c-source.html#l00567">_sqlo_stmt_struct::stmthp</a>, and <a class="el" href="sqlora_8c-source.html#l00485">_sqlo_db_struct::svchp</a>.    </td>
  </tr>
</table>
<a class="anchor" name="ga9" doxytag="sqlora.h::sqlo_get_ocol_dtype" ></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_ocol_dtype </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>pos</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 datatype of a column in the select list. 
<p>
<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>pos</em>&nbsp;</td><td>I - The column position (1 based). </td></tr>
  </table>
</dl>
<dl compact><dt><b>Returns:</b></dt><dd><ul>
<li>
The datatype (see <a class="el" href="group__constants.html#ga6">sqlo_data_types</a>) </li>
<li>
SQLO_INVALID_STMT_HANDLE </li>
<li>
SQLO_INVALID_COLPOS </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#l07923">7923</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#l04319">_get_trace_fp()</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#l00613">_sqlo_stmt_struct::cursor_type</a>, <a class="el" href="sqlora_8c-source.html#l00565">_sqlo_stmt_struct::dbp</a>, <a class="el" href="sqlora_8c-source.html#l00483">_sqlo_db_struct::errhp</a>, <a class="el" href="sqlora_8c-source.html#l00626">_sqlo_stmt_struct::num_executions</a>, <a class="el" href="sqlora_8c.html#a220a80">REFCURSOR</a>, <a class="el" href="sqlora_8c.html#a30">sqlo_db_struct_ptr_t</a>, <a class="el" href="group__constants.html#gga4a43">SQLO_INVALID_COLPOS</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>, <a class="el" href="sqlora_8c-source.html#l00493">_sqlo_db_struct::status</a>, <a class="el" href="sqlora_8c-source.html#l00567">_sqlo_stmt_struct::stmthp</a>, <a class="el" href="sqlora_8c-source.html#l00485">_sqlo_db_struct::svchp</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_ga9_cgraph.png" border="0" usemap="#group__misc_ga9_cgraph_map" alt=""></center>
<map name="group__misc_ga9_cgraph_map">
<area href="sqlora_8c.html#a111" shape="rect" coords="204,5,335,24" alt="">
<area href="sqlora_8c.html#a128" shape="rect" coords="221,48,317,66" alt="">
</map>
<a class="anchor" name="ga8" doxytag="sqlora.h::sqlo_get_stmt" ></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_get_stmt </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 sql statement text for the statement handle. 
<p>
<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 sql text. </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#l04572">4572</a> of file <a class="el" href="sqlora_8c-source.html">sqlora.c</a>.
<p>
References <a class="el" href="sqlora_8c-source.html#l01496">_get_stmt_string()</a>, <a class="el" href="sqlora_8c-source.html#l00367">CHECK_STHANDLE</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>, and <a class="el" href="sqlora_8c-source.html#l00570">_sqlo_stmt_struct::stmt</a>.    </td>
  </tr>
</table>

<p>
Here is the call graph for this function:<p><center><img src="group__misc_ga8_cgraph.png" border="0" usemap="#group__misc_ga8_cgraph_map" alt=""></center>
<map name="group__misc_ga8_cgraph_map">