group__easy.html

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

          <td class="mdname" nowrap> <em>in</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 number of bind/select-list variables. 
<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>
    <tr><td valign=top><em>in</em>&nbsp;</td><td>I - 1 returns the number of bind variables, 0 returns the number of select list columns.</td></tr>
  </table>
</dl>
<dl compact><dt><b>Returns:</b></dt><dd><ul>
<li>
The number of columns </li>
<li>
SQLO_INVALID_STMT_HANDLE </li>
</ul>
</dd></dl>

<p>
Definition at line <a class="el" href="sqlora_8c-source.html#l05579">5579</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#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#l00577">_sqlo_stmt_struct::num_bindpv</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#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#l00562">_sqlo_stmt_struct::sth</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__easy_ga12_cgraph.png" border="0" usemap="#group__easy_ga12_cgraph_map" alt=""></center>
<map name="group__easy_ga12_cgraph_map">
<area href="sqlora_8c.html#a128" shape="rect" coords="140,5,236,23" alt="">
</map>
<a class="anchor" name="ga11" doxytag="sqlora.h::sqlo_ocol_name_lens" ></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 int* sqlo_ocol_name_lens </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>int *&nbsp;</td>
          <td class="mdname" nowrap> <em>num</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 select list columns name lengths. 
<p>
Use this function to get the length of each select list column. Call this when you need the length of the column, for formatting purposes etc.<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>
    <tr><td valign=top><em>num</em>&nbsp;</td><td>O - A destination where the function can write the size of the returned array.</td></tr>
  </table>
</dl>
<dl compact><dt><b>Returns:</b></dt><dd>A pointer to an array of integers containing the lengths</dd></dl>
<dl compact><dt><b>See also:</b></dt><dd><a class="el" href="group__easy.html#ga9">sqlo_ocol_names</a>, <a class="el" href="group__easy.html#ga6">sqlo_fetch</a>, <a class="el" href="group__easy.html#ga4">sqlo_open2</a>, <a class="el" href="group__easy.html#ga14">sqlo_close</a>. </dd></dl>

<p>
Definition at line <a class="el" href="sqlora_8c-source.html#l07040">7040</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#l02805">_is_opened()</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#l00367">CHECK_STHANDLE</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="sqlora_8c-source.html#l00590">_sqlo_stmt_struct::num_defnpv</a>, <a class="el" href="sqlora_8c-source.html#l00611">_sqlo_stmt_struct::ocol_namev_size</a>, <a class="el" href="sqlora_8c.html#a30">sqlo_db_struct_ptr_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#l00238">TRACE</a>.    </td>
  </tr>
</table>

<p>
Here is the call graph for this function:<p><center><img src="group__easy_ga11_cgraph.png" border="0" usemap="#group__easy_ga11_cgraph_map" alt=""></center>
<map name="group__easy_ga11_cgraph_map">
<area href="sqlora_8c.html#a128" shape="rect" coords="559,101,655,120" alt="">
<area href="sqlora_8c.html#a110" shape="rect" coords="239,56,321,75" alt="">
<area href="sqlora_8c.html#a107" shape="rect" coords="244,99,316,117" alt="">
<area href="sqlora_8c.html#a140" shape="rect" coords="211,141,349,160" alt="">
<area href="sqlora_8c.html#a122" shape="rect" coords="404,124,505,143" alt="">
<area href="sqlora_8c.html#a139" shape="rect" coords="400,167,509,185" alt="">
</map>
<a class="anchor" name="ga9" doxytag="sqlora.h::sqlo_ocol_names" ></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_ocol_names </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>int *&nbsp;</td>
          <td class="mdname" nowrap> <em>num</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 select list columns. 
<p>
Use this function to get the select list column names. Most usefull for dynamic sql, where you don't know the sql statement at all.<p>
<dl compact><dt><b><a class="el" href="deprecated.html#_deprecated000002">Deprecated:</a></b></dt><dd>For new developments please use <a class="el" href="group__easy.html#ga10">sqlo_ocol_names2</a></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>
    <tr><td valign=top><em>num</em>&nbsp;</td><td>O - A destination where the function can write the size of the returned array (optional).</td></tr>
  </table>
</dl>
<dl compact><dt><b>Returns:</b></dt><dd>A pointer to an array of strings containing the column names, NULL on error</dd></dl>
<dl compact><dt><b>See also:</b></dt><dd><a class="el" href="group__easy.html#ga6">sqlo_fetch</a>, <a class="el" href="group__easy.html#ga7">sqlo_values</a>, <a class="el" href="group__easy.html#ga4">sqlo_open2</a>, <a class="el" href="group__easy.html#ga14">sqlo_close</a>, <a class="el" href="group__easy.html#ga11">sqlo_ocol_name_lens</a>. </dd></dl>

<p>
Definition at line <a class="el" href="sqlora_8c-source.html#l06949">6949</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#l02805">_is_opened()</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#l00367">CHECK_STHANDLE</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="sqlora_8c-source.html#l00590">_sqlo_stmt_struct::num_defnpv</a>, <a class="el" href="sqlora_8c-source.html#l00607">_sqlo_stmt_struct::ocol_namev</a>, <a class="el" href="sqlora_8c.html#a30">sqlo_db_struct_ptr_t</a>, <a class="el" href="sqlora_8c.html#a35">sqlo_stmt_struct_ptr_t</a>, <a class="el" href="sqlora_8c-source.html#l00581">_sqlo_stmt_struct::stype</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__easy_ga9_cgraph.png" border="0" usemap="#group__easy_ga9_cgraph_map" alt=""></center>
<map name="group__easy_ga9_cgraph_map">
<area href="sqlora_8c.html#a128" shape="rect" coords="532,101,628,120" alt="">
<area href="sqlora_8c.html#a110" shape="rect" coords="212,56,295,75" alt="">
<area href="sqlora_8c.html#a107" shape="rect" coords="217,99,289,117" alt="">
<area href="sqlora_8c.html#a140" shape="rect" coords="184,141,323,160" alt="">
<area href="sqlora_8c.html#a122" shape="rect" coords="377,124,479,143" alt="">
<area href="sqlora_8c.html#a139" shape="rect" coords="373,167,483,185" alt="">
</map>
<a class="anchor" name="ga10" doxytag="sqlora.h::sqlo_ocol_names2" ></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_ocol_names2 </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>int *&nbsp;</td>
          <td class="mdname" nowrap> <em>num</em>, </td>
        </tr>
        <tr>
          <td class="md" nowrap align="right"></td>
          <td></td>
          <td class="md" nowrap>const char ***&nbsp;</td>
          <td class="mdname" nowrap> <em>ocol_names</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>