📄 group__misc.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta http-equiv="Content-Type" content="text/html;charset=iso-8859-1"><title>libsqlora8: Miscellaneous functions</title><link href="doxygen.css" rel="stylesheet" type="text/css"></head><body><!-- Generated by Doxygen 1.3.6 --><div class="qindex"><a class="qindex" href="index.html">Main Page</a> | <a class="qindex" href="modules.html">Modules</a> | <a class="qindex" href="annotated.html">Data Structures</a> | <a class="qindex" href="files.html">File List</a> | <a class="qindex" href="functions.html">Data Fields</a> | <a class="qindex" href="globals.html">Globals</a> | <a class="qindex" href="pages.html">Related Pages</a> | <a class="qindex" href="examples.html">Examples</a></div><h1>Miscellaneous functions</h1><table border=0 cellpadding=0 cellspacing=0><tr><td></td></tr><tr><td colspan=2><br><h2>Functions</h2></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__misc.html#ga0">sqlo_get_oci_handle</a> (int sqloh, void *ocihp, <a class="el" href="group__typedefs.html#ga4">sqlo_oci_handle_types_e</a> type)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Get the specified OCI handle. <a href="#ga0"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__misc.html#ga1">sqlo_get_db_handle</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Return the database handle of a statement handle. <a href="#ga1"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__misc.html#ga2">sqlo_set_blocking</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, unsigned int on)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Set OCI blocking mode on/off. <a href="#ga2"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__misc.html#ga3">sqlo_get_blocking</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, unsigned int *blocking)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Get OCI blocking mode. <a href="#ga3"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__misc.html#ga4">sqlo_break</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Abort all operations in non-blocking mode. <a href="#ga4"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__misc.html#ga5">sqlo_set_prefetch_rows</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, unsigned int nrows)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Set the prefetch row attribute for a statement. <a href="#ga5"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__misc.html#ga6">sqlo_server_version</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, char *bufp, unsigned int buflen)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Get the server version string. <a href="#ga6"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__misc.html#ga7">sqlo_get_stmt_state</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Get the state of the statement. <a href="#ga7"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>const char * </td><td class="memItemRight" valign=bottom><a class="el" href="group__misc.html#ga8">sqlo_get_stmt</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Get the sql statement text for the statement handle. <a href="#ga8"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__misc.html#ga9">sqlo_get_ocol_dtype</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, unsigned int pos)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Get the datatype of a column in the select list. <a href="#ga9"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__misc.html#ga10">sqlo_trace</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, int on)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Switches Oracle trace on/off. <a href="#ga10"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__misc.html#ga11">sqlo_print</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Print info about the statement to stdout. <a href="#ga11"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__misc.html#ga12">sqlo_register_int_handler</a> (int *handle, <a class="el" href="group__typedefs.html#ga3">sqlo_signal_handler_t</a> signal_handler)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Register a signal handler for interrupts. <a href="#ga12"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__misc.html#ga13">sqlo_clear_int_handler</a> (int handle)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Clear an interrupt handler. <a href="#ga13"></a><br><br></td></tr></table><hr><h2>Function Documentation</h2><a class="anchor" name="ga4" doxytag="sqlora.h::sqlo_break" ></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_break </td> <td class="md" valign="top">( </td> <td class="md" nowrap valign="top"><a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> </td> <td class="mdname1" valign="top" nowrap> <em>dbh</em> </td> <td class="md" valign="top"> ) </td> <td class="md" nowrap></td> </tr> </table> </td> </tr></table><table cellspacing=5 cellpadding=0 border=0> <tr> <td> </td> <td><p>Abort all operations in non-blocking mode. <p>This call performs an immediate (asynchronous) abort of any currently executing OCI function that is associated with a connection.<p>If the connection is in blocking mode, SQLO_SUCCESS is returned without doing an abort.<p>The cursor in "SQLO_STILL_EXECUTING" status is closed.<p><dl compact><dt><b>Parameters:</b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign=top><em>dbh</em> </td><td>A database handle</td></tr> </table></dl><dl compact><dt><b>Returns:</b></dt><dd><ul><li>SQLO_SUCCESS </li><li>SQLO_ERROR </li><li>SQLO_INVALID_DB_HANDLE </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#l07300">7300</a> of file <a class="el" href="sqlora_8c-source.html">sqlora.c</a>.<p>References <a class="el" href="sqlora_8c-source.html#l04207">_close_all_executing_cursors()</a>, <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#l00340">CHECK_DBHANDLE</a>, <a class="el" href="sqlora_8c-source.html#l00416">CHECK_OCI_STATUS_RETURN</a>, <a class="el" href="sqlora_8c-source.html#l00483">_sqlo_db_struct::errhp</a>, <a class="el" href="sqlora_8h-source.html#l00309">sqlo_db_handle_t</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#gga5a45">SQLO_OFF</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#l00493">_sqlo_db_struct::status</a>, <a class="el" href="sqlora_8c-source.html#l00500">_sqlo_db_struct::stmthp</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_ga4_cgraph.png" border="0" usemap="#group__misc_ga4_cgraph_map" alt=""></center><map name="group__misc_ga4_cgraph_map"><area href="sqlora_8c.html#a127" shape="rect" coords="145,127,335,146" alt=""><area href="sqlora_8c.html#a128" shape="rect" coords="576,218,672,237" alt=""><area href="sqlora_8c.html#a152" shape="rect" coords="383,222,521,241" alt=""><area href="group__easy.html#ga14" shape="rect" coords="415,127,489,146" alt=""><area href="sqlora_8c.html#a104" shape="rect" coords="575,5,673,23" alt=""><area href="sqlora_8c.html#a120" shape="rect" coords="569,47,679,66" alt=""><area href="sqlora_8c.html#a110" shape="rect" coords="583,90,665,109" alt=""><area href="sqlora_8c.html#a109" shape="rect" coords="577,133,671,151" alt=""><area href="sqlora_8c.html#a103" shape="rect" coords="576,175,672,194" alt=""></map><a class="anchor" name="ga13" doxytag="sqlora.h::sqlo_clear_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_clear_int_handler </td> <td class="md" valign="top">( </td> <td class="md" nowrap valign="top">int </td> <td class="mdname1" valign="top" nowrap> <em>handle</em> </td> <td class="md" valign="top"> ) </td> <td class="md" nowrap></td> </tr> </table> </td> </tr></table><table cellspacing=5 cellpadding=0 border=0> <tr> <td> </td> <td><p>Clear an interrupt handler. <p><dl compact><dt><b>Parameters:</b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign=top><em>handle</em> </td><td>I - The handle created by <a class="el" href="group__misc.html#ga12">sqlo_register_int_handler</a>.</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#l08035">8035</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>. </td> </tr></table><a class="anchor" name="ga3" doxytag="sqlora.h::sqlo_get_blocking" ></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_blocking </td> <td class="md" valign="top">( </td> <td class="md" nowrap valign="top"><a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> </td> <td class="mdname" nowrap> <em>dbh</em>, </td> </tr> <tr> <td class="md" nowrap align="right"></td> <td></td> <td class="md" nowrap>unsigned int * </td> <td class="mdname" nowrap> <em>blocking</em></td> </tr> <tr> <td></td> <td class="md">) </td> <td class="md" colspan="2"></td> </tr> </table> </td> </tr></table><table cellspacing=5 cellpadding=0 border=0> <tr> <td> </td> <td><p>Get OCI blocking mode. <p>Returns the the blocking mode.<p><dl compact><dt><b>Parameters:</b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign=top><em>dbh</em> </td><td>I - A database handle </td></tr> <tr><td valign=top><em>blocking</em> </td><td>O - SQL_ON if in blocking mode (database default), or SQLO_OFF if in non-blocking mode. </td></tr> </table></dl><dl compact><dt><b>Returns:</b></dt><dd>SQLO_SUCCESS or OCI status code. </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#l07282">7282</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#l00340">CHECK_DBHANDLE</a>, <a class="el" href="sqlora_8c-source.html#l00416">CHECK_OCI_STATUS_RETURN</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>, and <a class="el" href="sqlora_8c-source.html#l00493">_sqlo_db_struct::status</a>. </td> </tr></table><p>Here is the call graph for this function:<p><center><img src="group__misc_ga3_cgraph.png" border="0" usemap="#group__misc_ga3_cgraph_map" alt=""></center><map name="group__misc_ga3_cgraph_map"><area href="sqlora_8c.html#a152" shape="rect" coords="188,5,327,23" alt=""><area href="sqlora_8c.html#a128" shape="rect" coords="375,5,471,23" alt=""></map><a class="anchor" name="ga1" doxytag="sqlora.h::sqlo_get_db_handle" ></a><p><table class="mdTable" width="100%" cellpadding="2" cellspacing="0">⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -