group__init.html

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

  RETURN_ON_ABORT; <span class="comment">/* finish if SIGINT was catched */</span>

  <span class="comment">/* ex6.c */</span>
  sth = reopen_cursor(dbh, 2500.0);
  <span class="keywordflow">if</span> (sth != (stat = reopen_cursor(dbh, 5000.0))) {
    printf(<span class="stringliteral">"reopen_cursor returned a new handle %d, expected %d\n"</span>, stat, sth);
  }
  <span class="comment">/* we don't close this cursor */</span>

  RETURN_ON_ABORT; <span class="comment">/* finish if SIGINT was catched */</span>

  <span class="comment">/* ex7.c */</span>
  do_select(dbh, 3000); <span class="comment">/* note: we reuse the cursor opened by ex6.c */</span>


  RETURN_ON_ABORT; <span class="comment">/* finish if SIGINT was catched */</span>

  <span class="comment">/* ex8.c */</span>
  stat = update_emp(dbh, 2.0, <span class="stringliteral">"MANAGER"</span>);
  printf(<span class="stringliteral">"Doubled the salary of %d managers.\n"</span>, stat);

  <a class="code" href="group__transactions.html#ga184">sqlo_rollback</a>(dbh);

  RETURN_ON_ABORT; <span class="comment">/* finish if SIGINT was catched */</span>

  <span class="comment">/* ex9.c */</span>
  call_plsql(dbh);


  RETURN_ON_ABORT; <span class="comment">/* finish if SIGINT was catched */</span>

  <span class="comment">/* ex10.c */</span>
  min_income = 2500;
  sth = prepare_cursor(dbh, &amp;min_income);
  <a class="code" href="group__easy.html#ga172">sqlo_close</a>(sth);

  RETURN_ON_ABORT; <span class="comment">/* finish if SIGINT was catched */</span>

  <span class="comment">/* ex11.c */</span>
  printf(<span class="stringliteral">"Employees with salary &gt;= 3000:\n"</span>);
  do_select2(dbh, 3000); <span class="comment">/* note: we reuse the cursor opened by ex6.c */</span>
  
  RETURN_ON_ABORT; <span class="comment">/* finish if SIGINT was catched */</span>

  <span class="comment">/* ex12.c */</span>
  printf(<span class="stringliteral">"Employees with salary &gt;= 1200:\n"</span>);
  do_array_select(dbh, 1200);


  RETURN_ON_ABORT; <span class="comment">/* finish if SIGINT was catched */</span>

  <span class="comment">/* ex13.c */</span>
  insert_into_blob_table(dbh, 1);

  RETURN_ON_ABORT; <span class="comment">/* finish if SIGINT was catched */</span>

  <span class="comment">/* ex13b.c */</span>
  update_blob_table(dbh, 1);

  RETURN_ON_ABORT; <span class="comment">/* finish if SIGINT was catched */</span>

  <span class="comment">/* ex14.c */</span>
  insert_file_into_blob_table(dbh, 2, <span class="stringliteral">"examples"</span>);

  RETURN_ON_ABORT; <span class="comment">/* finish if SIGINT was catched */</span>

  <span class="comment">/* ex15.c */</span>
  select_from_blob_table(dbh, 1);

  RETURN_ON_ABORT; <span class="comment">/* finish if SIGINT was catched */</span>

  <span class="comment">/* ex16.c */</span>
  select_file_from_blob_table(dbh, 2, <span class="stringliteral">"examples.cmp"</span>);
  <span class="keywordflow">if</span> ( 0 != system(<span class="stringliteral">"diff -q examples examples.cmp"</span>)) {
    printf(<span class="stringliteral">"ERROR: examples is different from examples.cmp!!!\n"</span>);
  }
  <a class="code" href="group__transactions.html#ga184">sqlo_rollback</a>(dbh);

  RETURN_ON_ABORT; <span class="comment">/* finish if SIGINT was catched */</span>
  <span class="comment">/* ex17.c */</span>
  printf(<span class="stringliteral">"Employees with salary (via refcursor) &gt;= 1200:\n"</span>);
  select_refcursor(dbh, 1200);

  RETURN_ON_ABORT; <span class="comment">/* finish if SIGINT was catched */</span>
  <span class="comment">/* ex18.c */</span>
  printf(<span class="stringliteral">"Employees with salary (via refcursor with bind vars) &gt;= 1200:\n"</span>);
  select_refcursor2(dbh, 1200);

  RETURN_ON_ABORT; <span class="comment">/* finish if SIGINT was catched */</span>
  <span class="comment">/* ex19.c */</span>
  printf(<span class="stringliteral">"Employees, departements and locations via ntable\n"</span>);
  select_ntable(dbh);

  <span class="comment">/* rollback */</span>
  <a class="code" href="group__transactions.html#ga184">sqlo_rollback</a>(dbh);

  <span class="comment">/* logout */</span>
  <a class="code" href="group__loginout.html#ga181">sqlo_finish</a>(dbh);

  <span class="keywordflow">return</span> EXIT_SUCCESS;
}
<span class="comment">/* $Id: examples.c,v 1.6 2004/01/03 16:48:19 kpoitschke Exp $ */</span>
</pre></div> </dd></dl>
    </td>
  </tr>
</table>
<a class="anchor" name="ga1" doxytag="sqlora.h::sqlo_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_version </td>
          <td class="md" valign="top">(&nbsp;</td>
          <td class="md" nowrap valign="top">const char *&nbsp;</td>
          <td class="mdname1" valign="top" nowrap> <em>version_str</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>
Checks if the version is sufficient. 
<p>
You can use this during runtime, to check if the dynamic linker did a good job and linked you to the right version.<p>
<dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign=top><em>version_str</em>&nbsp;</td><td>I - The minimum version in the format major.minor.micro</td></tr>
  </table>
</dl>
<dl compact><dt><b>Returns:</b></dt><dd><ul>
<li>
SQLO_SUCCESS </li>
<li>
SQLO_WRONG_VERSION </li>
<li>
SQLO_MALFORMED_VERSION_STR </li>
</ul>
</dd></dl>

<p>
Definition at line <a class="el" href="sqlora_8c-source.html#l07196">7196</a> of file <a class="el" href="sqlora_8c-source.html">sqlora.c</a>.
<p>
References <a class="el" href="sqlora_8h-source.html#l00371">sqlo_major_version</a>, <a class="el" href="group__constants.html#gga4a41">SQLO_MALFORMED_VERSION_STR</a>, <a class="el" href="sqlora_8h-source.html#l00387">sqlo_micro_version</a>, <a class="el" href="sqlora_8h-source.html#l00379">sqlo_minor_version</a>, <a class="el" href="group__constants.html#gga3a25">SQLO_SUCCESS</a>, and <a class="el" href="group__constants.html#gga4a42">SQLO_WRONG_VERSION</a>.    </td>
  </tr>
</table>
<hr size="1"><address style="align: right;"><small>Generated on Sun Jun 13 04:51:42 2004 for libsqlora8 by
<a href="http://www.doxygen.org/index.html">
<img src="doxygen.png" alt="doxygen" align="middle" border=0 > </a>1.3.6 </small></address>
</body>
</html>