group__easy.html

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

    <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>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 </td></tr>
    <tr><td valign=top><em>ocol_names</em>&nbsp;</td><td>O - The address of a char ** which receives the array of ocol_names. array.</td></tr>
  </table>
</dl>
<dl compact><dt><b>Returns:</b></dt><dd>SQLO_SUCCESS or &lt;0 on error. </dd></dl>

<p>
Definition at line <a class="el" href="sqlora_8c-source.html#l06994">6994</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#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-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="group__constants.html#gga3a26">SQLO_ERROR</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#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_ga10_cgraph.png" border="0" usemap="#group__easy_ga10_cgraph_map" alt=""></center>
<map name="group__easy_ga10_cgraph_map">
<area href="sqlora_8c.html#a128" shape="rect" coords="537,101,633,120" alt="">
<area href="sqlora_8c.html#a110" shape="rect" coords="217,56,300,75" alt="">
<area href="sqlora_8c.html#a107" shape="rect" coords="223,99,295,117" alt="">
<area href="sqlora_8c.html#a140" shape="rect" coords="189,141,328,160" alt="">
<area href="sqlora_8c.html#a122" shape="rect" coords="383,124,484,143" alt="">
<area href="sqlora_8c.html#a139" shape="rect" coords="379,167,488,185" alt="">
</map>
<a class="anchor" name="ga3" doxytag="sqlora.h::sqlo_open" ></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"> <a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sqlo_open </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>const char *&nbsp;</td>
          <td class="mdname" nowrap> <em>stmt</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>argc</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>argv</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>
Open a new cursor. 
<p>
This function opens a new cursor for a query statement.<p>
If the stmt is a SELECT statement, the function sets the attribute OCI_ATTR_PREFETCH rows to the max arraysize parameter of the library. This is a kind of internal array fetch Oracle provides to speed up the fetching. In case of an error, the allocated resources are freed. You don't have to call sqlo_close for an invalid sth.<p>
<dl compact><dt><b><a class="el" href="deprecated.html#_deprecated000001">Deprecated:</a></b></dt><dd>For new developments please use <a class="el" href="group__easy.html#ga4">sqlo_open2</a></dd></dl>
<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>stmt</em>&nbsp;</td><td>I - A sql statement </td></tr>
    <tr><td valign=top><em>argc</em>&nbsp;</td><td>I - Number of arguments in argv </td></tr>
    <tr><td valign=top><em>argv</em>&nbsp;</td><td>I - Arguments</td></tr>
  </table>
</dl>
<dl compact><dt><b>Returns:</b></dt><dd><ul>
<li>
A statement handle </li>
<li>
&lt; 0 on error </li>
</ul>
</dd></dl>
<dl compact><dt><b>Example:</b></dt><dd><div class="fragment"><pre><span class="comment">/* $Id: ex4.c,v 1.4 2002/08/24 12:54:47 kpoitschke Exp $ */</span>
<span class="preprocessor">#include &lt;stdio.h&gt;</span>
<span class="preprocessor">#include &lt;stdlib.h&gt;</span>
<span class="preprocessor">#include "examples.h"</span>

<a class="code" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> open_cursor(<a class="code" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh)
{
  <a class="code" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth;
  <span class="keywordtype">int</span> argc = 0;
  <span class="keyword">const</span> <span class="keywordtype">char</span> * argv[1];
  
  argv[argc++] = <span class="stringliteral">"1000"</span>;

  <span class="keywordflow">if</span> ( 0 &gt; (sth = (<a class="code" href="group__easy.html#ga164">sqlo_open</a>(dbh, <span class="stringliteral">"SELECT ENAME, SAL FROM EMP WHERE SAL &gt;= :1"</span>, 
                             argc, argv)))) {
    error_exit(dbh, <span class="stringliteral">"sqlo_open"</span>);
  }
  <span class="keywordflow">return</span> sth;
}

<span class="comment">/* $Id: ex4.c,v 1.4 2002/08/24 12:54:47 kpoitschke Exp $ */</span>

</pre></div></dd></dl>
<dl compact><dt><b>See also:</b></dt><dd><a class="el" href="group__easy.html#ga4">sqlo_open2</a>, <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#ga14">sqlo_close</a> </dd></dl>

<p>
Definition at line <a class="el" href="sqlora_8c-source.html#l05152">5152</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#l02764">_is_plsql()</a>, <a class="el" href="sqlora_8c-source.html#l02746">_is_query()</a>, <a class="el" href="sqlora_8c.html#a56">_num_prefetch_rows</a>, <a class="el" href="sqlora_8c-source.html#l04405">_prepare()</a>, <a class="el" href="sqlora_8c-source.html#l01457">_set_prefetch_rows()</a>, <a class="el" href="sqlora_8c-source.html#l04464">_sqlo_reopen()</a>, <a class="el" href="sqlora_8c-source.html#l01983">_stmt_new()</a>, <a class="el" href="sqlora_8c-source.html#l00456">bool_t</a>, <a class="el" href="sqlora_8c-source.html#l00340">CHECK_DBHANDLE</a>, <a class="el" href="sqlora_8c-source.html#l00389">CHECK_OCI_STATUS</a>, <a class="el" href="sqlora_8c-source.html#l00416">CHECK_OCI_STATUS_RETURN</a>, <a class="el" href="sqlora_8c-source.html#l00223">FALSE</a>, <a class="el" href="sqlora_8c-source.html#l05656">sqlo_close()</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#gga4a38">SQLO_INVALID_STMT_TYPE</a>, <a class="el" href="group__constants.html#gga5a45">SQLO_OFF</a>, <a class="el" href="sqlora_8c-source.html#l07226">sqlo_set_blocking()</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#l00581">_sqlo_stmt_struct::stype</a>, <a class="el" href="sqlora_8c-source.html#l00238">TRACE</a>, and <a class="el" href="sqlora_8c-source.html#l00218">TRUE</a>.    </td>
  </tr>
</table>

<p>
Here is the call graph for this function:<p><center><img src="group__easy_ga3_cgraph.png" border="0" usemap="#group__easy_ga3_cgraph_map" alt=""></center>
<map name="group__easy_ga3_cgraph_map">
<area href="sqlora_8c.html#a152" shape="rect" coords="316,203,455,222" alt="">
<area href="sqlora_8c.html#a128" shape="rect" coords="509,225,605,243" alt="">
<area href="sqlora_8c.html#a108" shape="rect" coords="172,649,236,667" alt="">
<area href="sqlora_8c.html#a107" shape="rect" coords="349,569,421,587" alt="">
<area href="sqlora_8c.html#a129" shape="rect" coords="171,59,237,78" alt="">
<area href="sqlora_8c.html#a119" shape="rect" coords="140,691,268,710" alt="">
<area href="sqlora_8c.html#a133" shape="rect" coords="157,429,251,447" alt="">
<area href="group__easy.html#ga14" shape="rect" coords="348,526,423,545" alt="">
<area href="sqlora_8c.html#a102" shape="rect" coords="165,606,243,625" alt="">
<area href="group__misc.html#ga2" shape="rect" coords="145,203,263,222" alt="">
<area href="sqlora_8c.html#a153" shape="rect" coords="333,59,437,78" alt="">
<area href="sqlora_8c.html#a92" shape="rect" coords="345,289,425,307" alt="">
<area href="sqlora_8c.html#a104" shape="rect" coords="508,513,607,531" alt="">
<area href="sqlora_8c.html#a97" shape="rect" coords="335,382,436,401" alt="">
<area href="sqlora_8c.html#a120" shape="rect" coords="503,455,612,474" alt="">
<area href="sqlora_8c.html#a91" shape="rect" coords="328,246,443,265" alt="">
<area href="sqlora_8c.html#a103" shape="rect" coords="509,621,605,639" alt="">
<area href="sqlora_8c.html#a101" shape="rect" coords="339,654,432,673" alt="">
<area href="sqlora_8c.html#a105" shape="rect" coords="351,611,420,630" alt="">
</map>
<a class="anchor" name="ga4" doxytag="sqlora.h::sqlo_open2" ></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_open2 </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>sthp</em>, </td>
        </tr>
        <tr>
          <td class="md" nowrap align="right"></td>
          <td></td>
          <td class="md" nowrap><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>const char *&nbsp;</td>
          <td class="mdname" nowrap> <em>stmt</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>argc</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>argv</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>
Open a new cursor. 
<p>
This function opens a new cursor for a query statement. Use this function if your bind variables are all strings. If you need native datatype support, use <a class="el" href="group__complex.html#ga0">sqlo_prepare</a><p>
If the stmt is a SELECT statement, the function sets the attribute OCI_ATTR_PREFETCH rows to the max arraysize parameter of the library. This is a kind of internal array fetch Oracle provides to speed up the fetching. In case of an error, the allocated resources are freed. You don't have to call sqlo_close for an invalid sth.<p>
<dl compact><dt><b>Attention:</b></dt><dd>You have to init the passed statement handle with SQLO_STH_INIT. This is required escpecially in non-blocking mode.</dd></dl>
<dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign=to