group__misc.html
来自「一个很好用的Linux/Unix下Oracle OCI开发接口封装库」· HTML 代码 · 共 711 行 · 第 1/2 页
HTML
711 行
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><html><head><meta http-equiv="Content-Type" content="text/html;charset=iso-8859-1"><title>Miscellaneous functions</title><link href="doxygen.css" rel="stylesheet" type="text/css"></head><body><!-- Generated by Doxygen 1.2.18 --><center><a class="qindex" href="index.html">Main Page</a> <a class="qindex" href="modules.html">Modules</a> <a class="qindex" href="files.html">File List</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> </center><hr><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 nowrap align=right valign=top>int </td><td valign=bottom><a class="el" href="group__misc.html#a0">sqlo_get_oci_handle</a> (int sqloh, void *ocihp, <a class="el" href="group__typedefs.html#a4">sqlo_oci_handle_types_e</a> type)</td></tr><tr><td> </td><td><font size=-1><em>Get the specified OCI handle.</em> <a href="#a0"></a><em></em></font><br><br></td></tr><tr><td nowrap align=right valign=top>int </td><td valign=bottom><a class="el" href="group__misc.html#a1">sqlo_get_db_handle</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> sth)</td></tr><tr><td> </td><td><font size=-1><em>Return the database handle of a statement handle.</em> <a href="#a1"></a><em></em></font><br><br></td></tr><tr><td nowrap align=right valign=top>int </td><td valign=bottom><a class="el" href="group__misc.html#a2">sqlo_set_blocking</a> (<a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a> dbh, unsigned int on)</td></tr><tr><td> </td><td><font size=-1><em>Set OCI blocking mode on/off.</em> <a href="#a2"></a><em></em></font><br><br></td></tr><tr><td nowrap align=right valign=top>int </td><td valign=bottom><a class="el" href="group__misc.html#a3">sqlo_get_blocking</a> (<a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a> dbh, unsigned int *blocking)</td></tr><tr><td> </td><td><font size=-1><em>Get OCI blocking mode.</em> <a href="#a3"></a><em></em></font><br><br></td></tr><tr><td nowrap align=right valign=top>int </td><td valign=bottom><a class="el" href="group__misc.html#a4">sqlo_break</a> (<a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a> dbh)</td></tr><tr><td> </td><td><font size=-1><em>Abort all operations in non-blocking mode.</em> <a href="#a4"></a><em></em></font><br><br></td></tr><tr><td nowrap align=right valign=top>int </td><td valign=bottom><a class="el" href="group__misc.html#a5">sqlo_set_prefetch_rows</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> sth, unsigned int nrows)</td></tr><tr><td> </td><td><font size=-1><em>Set the prefetch row attribute for a statement.</em> <a href="#a5"></a><em></em></font><br><br></td></tr><tr><td nowrap align=right valign=top>int </td><td valign=bottom><a class="el" href="group__misc.html#a6">sqlo_server_version</a> (<a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a> dbh, char *bufp, unsigned int buflen)</td></tr><tr><td> </td><td><font size=-1><em>Get the server version string.</em> <a href="#a6"></a><em></em></font><br><br></td></tr><tr><td nowrap align=right valign=top>int </td><td valign=bottom><a class="el" href="group__misc.html#a7">sqlo_get_stmt_state</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> sth)</td></tr><tr><td> </td><td><font size=-1><em>Get the state of the statement.</em> <a href="#a7"></a><em></em></font><br><br></td></tr><tr><td nowrap align=right valign=top>const char * </td><td valign=bottom><a class="el" href="group__misc.html#a8">sqlo_get_stmt</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> sth)</td></tr><tr><td> </td><td><font size=-1><em>Get the sql statement text for the statement handle.</em> <a href="#a8"></a><em></em></font><br><br></td></tr><tr><td nowrap align=right valign=top>int </td><td valign=bottom><a class="el" href="group__misc.html#a9">sqlo_get_ocol_dtype</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> sth, unsigned int pos)</td></tr><tr><td> </td><td><font size=-1><em>Get the datatype of a column in the select list.</em> <a href="#a9"></a><em></em></font><br><br></td></tr><tr><td nowrap align=right valign=top>int </td><td valign=bottom><a class="el" href="group__misc.html#a10">sqlo_trace</a> (<a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a> dbh, int on)</td></tr><tr><td> </td><td><font size=-1><em>Switches Oracle trace on/off.</em> <a href="#a10"></a><em></em></font><br><br></td></tr><tr><td nowrap align=right valign=top>int </td><td valign=bottom><a class="el" href="group__misc.html#a11">sqlo_print</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> sth)</td></tr><tr><td> </td><td><font size=-1><em>Print info about the statement to stdout.</em> <a href="#a11"></a><em></em></font><br><br></td></tr><tr><td nowrap align=right valign=top>int </td><td valign=bottom><a class="el" href="group__misc.html#a12">sqlo_register_int_handler</a> (int *handle, <a class="el" href="group__typedefs.html#a3">sqlo_signal_handler_t</a> signal_handler)</td></tr><tr><td> </td><td><font size=-1><em>Register a signal handler for interrupts.</em> <a href="#a12"></a><em></em></font><br><br></td></tr><tr><td nowrap align=right valign=top>int </td><td valign=bottom><a class="el" href="group__misc.html#a13">sqlo_clear_int_handler</a> (int handle)</td></tr><tr><td> </td><td><font size=-1><em>Clear an interrupt handler.</em> <a href="#a13"></a><em></em></font><br><br></td></tr></table><hr><h2>Function Documentation</h2><a name="a4" doxytag="sqlora.h::sqlo_break"></a><p><table width="100%" cellpadding="2" cellspacing="0" border="0"> <tr> <td class="md"> <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#a0">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.<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>SQLO_ERROR <li>SQLO_INVALID_DB_HANDLE </ul></dl><dl compact><dt><b>Since: </b></dt><dd>Version 2.2 </dl> </td> </tr></table><a name="a13" doxytag="sqlora.h::sqlo_clear_int_handler"></a><p><table width="100%" cellpadding="2" cellspacing="0" border="0"> <tr> <td class="md"> <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#a12">Miscellaneous functions</a>.</td></tr></table></dl><dl compact><dt><b>Returns: </b></dt><dd>SQLO_SUCCESS or SQLO_ERROR on error. </dl> </td> </tr></table><a name="a3" doxytag="sqlora.h::sqlo_get_blocking"></a><p><table width="100%" cellpadding="2" cellspacing="0" border="0"> <tr> <td class="md"> <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#a0">sqlo_db_handle_t</a> </td> <td class="mdname" nowrap> <em>dbh</em>, </td> </tr> <tr> <td></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.<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. </dl><dl compact><dt><b>Since: </b></dt><dd>Version 2.2 </dl> </td> </tr></table><a name="a1" doxytag="sqlora.h::sqlo_get_db_handle"></a><p><table width="100%" cellpadding="2" cellspacing="0" border="0"> <tr> <td class="md"> <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">( </td> <td class="md" nowrap valign="top"><a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> </td> <td class="mdname1" valign="top" nowrap> <em>sth</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>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> </td><td>I - A statement handle </td></tr></table></dl><dl compact><dt><b>Returns: </b></dt><dd><ul><li>The database handle <li> < 0 on error </ul></dl> </td> </tr></table><a name="a0" doxytag="sqlora.h::sqlo_get_oci_handle"></a><p><table width="100%" cellpadding="2" cellspacing="0" border="0"> <tr> <td class="md"> <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">( </td> <td class="md" nowrap valign="top">int </td> <td class="mdname" nowrap> <em>sqloh</em>, </td> </tr> <tr> <td></td> <td></td> <td class="md" nowrap>void * </td> <td class="mdname" nowrap> <em>ocihp</em>, </td> </tr> <tr> <td></td> <td></td> <td class="md" nowrap><a class="el" href="group__typedefs.html#a4">sqlo_oci_handle_types_e</a> </td> <td class="mdname" nowrap> <em>type</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 the specified OCI handle.<p>You can get the oci handles here, if you want to call other OCI functions.<dl compact><dt><b>Parameters: </b></dt><dd><table border=0 cellspacing=2 cellpadding=0><tr><td valign=top><em>sqloh</em> </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> </td><td>O - The requested OCI handle. </td></tr><tr><td valign=top><em>type</em> </td><td>I - The OCI handle type (see <a class="el" href="group__typedefs.html#a4">Typedefs</a>)</td></tr></table></dl><dl compact><dt><b>Returns: </b></dt><dd><ul><li>SQLO_SUCCESS <li> < 0 on error </ul></dl><dl compact><dt><b>See also: </b></dt><dd><a class="el" href="group__typedefs.html#a4">sqlo_oci_handle_types_e</a> </dl> </td> </tr></table><a name="a9" doxytag="sqlora.h::sqlo_get_ocol_dtype"></a><p><table width="100%" cellpadding="2" cellspacing="0" border="0"> <tr> <td class="md"> <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">( </td> <td class="md" nowrap valign="top"><a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> </td> <td class="mdname" nowrap> <em>sth</em>, </td> </tr> <tr> <td></td> <td></td> <td class="md" nowrap>unsigned int </td> <td class="mdname" nowrap> <em>pos</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 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> </td><td>I - The statement handle </td></tr><tr><td valign=top><em>pos</em> </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#a6">Constants</a>) <li>SQLO_INVALID_STMT_HANDLE <li>SQLO_INVALID_COLPOS </ul></dl><dl compact><dt><b>Since: </b></dt><dd>Version 2.2 </dl> </td> </tr></table><a name="a8" doxytag="sqlora.h::sqlo_get_stmt"></a><p><table width="100%" cellpadding="2" cellspacing="0" border="0"> <tr> <td class="md"> <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">( </td> <td class="md" nowrap valign="top"><a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> </td> <td class="mdname1" valign="top" nowrap> <em>sth</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>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> </td><td>I - A statement handle </td></tr></table></dl><dl compact><dt><b>Returns: </b></dt><dd>The sql text. </dl><dl compact><dt><b>Since: </b></dt><dd>Version 2.2 </dl> </td>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?