📄 group__g__stmt.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta http-equiv="Content-Type" content="text/html;charset=UTF-8"><title>OCILIB (C Driver for Oracle): Statements control</title><link href="doxygen.css" rel="stylesheet" type="text/css"><link href="tabs.css" rel="stylesheet" type="text/css"></head><body><!-- Generated by Doxygen 1.5.4 --><div class="tabs"> <ul> <li><a href="index.html"><span>Main Page</span></a></li> <li><a href="modules.html"><span>Modules</span></a></li> <li><a href="annotated.html"><span>Data Structures</span></a></li> <li><a href="files.html"><span>Files</span></a></li> </ul></div><h1>Statements control</h1><hr><a name="_details"></a><h2>Detailed Description</h2>Those functions give extra information about OCILIB statements and can modify their behaviour. <p><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">OCI_EXPORT unsigned int OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__stmt.html#g78f017309e4be771379a064642ff91ef">OCI_GetStatementType</a> (<a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> *stmt)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Return the type of a SQL statement. <a href="#g78f017309e4be771379a064642ff91ef"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__stmt.html#g83e1c31e40926a84651eb60fefd50d5e">OCI_SetFetchMode</a> (<a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> *stmt, unsigned int mode)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Set the fetch mode of a SQL statement. <a href="#g83e1c31e40926a84651eb60fefd50d5e"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT unsigned int OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__stmt.html#gf6035956d1fd5962753443ead90e2660">OCI_GetFetchMode</a> (<a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> *stmt)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Return the fetch mode of a SQL statement. <a href="#gf6035956d1fd5962753443ead90e2660"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__stmt.html#g33e12da2d28c8a8a73165230a54c91cb">OCI_SetBindMode</a> (<a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> *stmt, unsigned int mode)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Set the binding mode of a SQL statement. <a href="#g33e12da2d28c8a8a73165230a54c91cb"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT unsigned int OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__stmt.html#g9739821da98759af3fb5517e2e678c09">OCI_GetBindMode</a> (<a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> *stmt)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Return the binding mode of a SQL statement. <a href="#g9739821da98759af3fb5517e2e678c09"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__stmt.html#g8ee64921bd9acb110c29cddbb461b3fe">OCI_SetFetchSize</a> (<a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> *stmt, unsigned int size)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Set the number of rows fetched per internal server fetch call. <a href="#g8ee64921bd9acb110c29cddbb461b3fe"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT unsigned int OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__stmt.html#g74cdb9738bad2b947c46a4d90c9da800">OCI_GetFetchSize</a> (<a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> *stmt)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Return the number of rows fetched per internal server fetch call. <a href="#g74cdb9738bad2b947c46a4d90c9da800"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__stmt.html#g7298b6b4f2d9971e3c05361da12991dd">OCI_SetPrefetchSize</a> (<a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> *stmt, unsigned int size)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Set the number of rows pre-fetched by OCI Client. <a href="#g7298b6b4f2d9971e3c05361da12991dd"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT unsigned int OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__stmt.html#gd4f1507605d585c92a19a534fa7f43d1">OCI_GetPrefetchSize</a> (<a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> *stmt)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Return the number of rows pre-fetched by OCI Client. <a href="#gd4f1507605d585c92a19a534fa7f43d1"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__stmt.html#g50e9b5456cb68d38a3b24e05bcd3f0e3">OCI_SetPrefetchMemory</a> (<a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> *stmt, unsigned int size)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Set the number of rows pre-fetched by OCI Client. <a href="#g50e9b5456cb68d38a3b24e05bcd3f0e3"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT unsigned int OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__stmt.html#ge9c7115ff49fa40e0822de8283c94610">OCI_GetPrefetchMemory</a> (<a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> *stmt)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Return the amount of memory used to retrieve rows pre-fetched by OCI Client. <a href="#ge9c7115ff49fa40e0822de8283c94610"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__stmt.html#g0aec6183761a7d90307ba785733888e0">OCI_SetLongMaxSize</a> (<a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> *stmt, unsigned int size)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Set the LONG datatype piece buffer size. <a href="#g0aec6183761a7d90307ba785733888e0"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT unsigned int OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__stmt.html#ga48e7f2aed9136c38a65371c7b224d1a">OCI_GetLongMaxSize</a> (<a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> *stmt)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Return the LONG datatype piece buffer size. <a href="#ga48e7f2aed9136c38a65371c7b224d1a"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT boolean OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__stmt.html#ge92422b723eef25355d91e0b50c09c0c">OCI_SetLongMode</a> (<a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> *stmt, unsigned int mode)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Set the long datatype handling mode of a SQL statement. <a href="#ge92422b723eef25355d91e0b50c09c0c"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT unsigned int OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__stmt.html#g8541a1ef030add7895474a4004fe7709">OCI_GetLongMode</a> (<a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> *stmt)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Return the long datatype handling mode of a SQL statement. <a href="#g8541a1ef030add7895474a4004fe7709"></a><br></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT <a class="el" href="struct_o_c_i___connection.html">OCI_Connection</a> *OCI_API </td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__stmt.html#g1f051eb0e55245280385a19f20efe59a">OCI_StatementGetConnection</a> (<a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> *stmt)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Return the connection handle associated with a statement handle. <a href="#g1f051eb0e55245280385a19f20efe59a"></a><br></td></tr></table><hr><h2>Function Documentation</h2><a class="anchor" name="g9739821da98759af3fb5517e2e678c09"></a><!-- doxytag: member="ocilib.h::OCI_GetBindMode" ref="g9739821da98759af3fb5517e2e678c09" args="(OCI_Statement *stmt)" --><div class="memitem"><div class="memproto"> <table class="memname"> <tr> <td class="memname">OCI_EXPORT unsigned int OCI_API OCI_GetBindMode </td> <td>(</td> <td class="paramtype"><a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> * </td> <td class="paramname"> <em>stmt</em> </td> <td> ) </td> <td width="100%"></td> </tr> </table></div><div class="memdoc"><p>Return the binding mode of a SQL statement. <p><dl compact><dt><b>Parameters:</b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign="top"></td><td valign="top"><em>stmt</em> </td><td>- Statement handle</td></tr> </table></dl><dl class="note" compact><dt><b>Note:</b></dt><dd>See <a class="el" href="group__g__stmt.html#g33e12da2d28c8a8a73165230a54c91cb" title="Set the binding mode of a SQL statement.">OCI_SetBindMode()</a> for possible values Default value is OCI_BIND_BY_NAME<p>if stmt is NULL, the return value is OCI_UNKNOWN </dd></dl><p>Definition at line <a class="el" href="statement_8c-source.html#l02669">2669</a> of file <a class="el" href="statement_8c-source.html">statement.c</a>.</p><p>References <a class="el" href="ocilib__types_8h-source.html#l00422">OCI_Statement::bind_mode</a>.</p></div></div><p><a class="anchor" name="gf6035956d1fd5962753443ead90e2660"></a><!-- doxytag: member="ocilib.h::OCI_GetFetchMode" ref="gf6035956d1fd5962753443ead90e2660" args="(OCI_Statement *stmt)" --><div class="memitem"><div class="memproto"> <table class="memname"> <tr> <td class="memname">OCI_EXPORT unsigned int OCI_API OCI_GetFetchMode </td> <td>(</td> <td class="paramtype"><a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> * </td> <td class="paramname"> <em>stmt</em> </td> <td> ) </td> <td width="100%"></td> </tr> </table></div><div class="memdoc"><p>Return the fetch mode of a SQL statement. <p><dl compact><dt><b>Parameters:</b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign="top"></td><td valign="top"><em>stmt</em> </td><td>- Statement handle</td></tr> </table></dl><dl class="note" compact><dt><b>Note:</b></dt><dd>See <a class="el" href="group__g__stmt.html#g83e1c31e40926a84651eb60fefd50d5e" title="Set the fetch mode of a SQL statement.">OCI_SetFetchMode()</a> for possible values Default value is OCI_FETCH_FORWARD_ONLY </dd></dl><p>Definition at line <a class="el" href="statement_8c-source.html#l02639">2639</a> of file <a class="el" href="statement_8c-source.html">statement.c</a>.</p><p>References <a class="el" href="ocilib__types_8h-source.html#l00414">OCI_Statement::con</a>, and <a class="el" href="ocilib__types_8h-source.html#l00423">OCI_Statement::exec_mode</a>.</p></div></div><p><a class="anchor" name="g74cdb9738bad2b947c46a4d90c9da800"></a><!-- doxytag: member="ocilib.h::OCI_GetFetchSize" ref="g74cdb9738bad2b947c46a4d90c9da800" args="(OCI_Statement *stmt)" --><div class="memitem"><div class="memproto"> <table class="memname"> <tr> <td class="memname">OCI_EXPORT unsigned int OCI_API OCI_GetFetchSize </td> <td>(</td> <td class="paramtype"><a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> * </td> <td class="paramname"> <em>stmt</em> </td> <td> ) </td> <td width="100%"></td> </tr> </table></div><div class="memdoc"><p>Return the number of rows fetched per internal server fetch call. <p><dl class="note" compact><dt><b>Note:</b></dt><dd>Default value is set to constant OCI_FETCH_SIZE</dd></dl><dl compact><dt><b>Parameters:</b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign="top"></td><td valign="top"><em>stmt</em> </td><td>- Statement handle </td></tr> </table></dl><p>Definition at line <a class="el" href="statement_8c-source.html#l02699">2699</a> of file <a class="el" href="statement_8c-source.html">statement.c</a>.</p><p>References <a class="el" href="ocilib__types_8h-source.html#l00424">OCI_Statement::fetch_size</a>.</p></div></div><p><a class="anchor" name="ga48e7f2aed9136c38a65371c7b224d1a"></a><!-- doxytag: member="ocilib.h::OCI_GetLongMaxSize" ref="ga48e7f2aed9136c38a65371c7b224d1a" args="(OCI_Statement *stmt)" --><div class="memitem"><div class="memproto"> <table class="memname"> <tr> <td class="memname">OCI_EXPORT unsigned int OCI_API OCI_GetLongMaxSize </td> <td>(</td> <td class="paramtype"><a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> * </td> <td class="paramname"> <em>stmt</em> </td> <td> ) </td> <td width="100%"></td> </tr> </table></div><div class="memdoc"><p>Return the LONG datatype piece buffer size. <p><dl class="note" compact><dt><b>Note:</b></dt><dd>Default value is set to constant OCI_SIZE_LONG</dd></dl><dl compact><dt><b>Parameters:</b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign="top"></td><td valign="top"><em>stmt</em> </td><td>- Statement handle </td></tr> </table></dl><p>Definition at line <a class="el" href="statement_8c-source.html#l02811">2811</a> of file <a class="el" href="statement_8c-source.html">statement.c</a>.</p><p>References <a class="el" href="ocilib__types_8h-source.html#l00427">OCI_Statement::long_size</a>.</p></div></div><p><a class="anchor" name="g8541a1ef030add7895474a4004fe7709"></a><!-- doxytag: member="ocilib.h::OCI_GetLongMode" ref="g8541a1ef030add7895474a4004fe7709" args="(OCI_Statement *stmt)" --><div class="memitem"><div class="memproto"> <table class="memname"> <tr> <td class="memname">OCI_EXPORT unsigned int OCI_API OCI_GetLongMode </td> <td>(</td> <td class="paramtype"><a class="el" href="struct_o_c_i___statement.html">OCI_Statement</a> * </td> <td class="paramname"> <em>stmt</em> </td> <td> ) </td> <td width="100%"></td> </tr> </table></div><div class="memdoc"><p>Return the long datatype handling mode of a SQL statement. <p><dl compact><dt><b>Parameters:</b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign="top"></td><td valign="top"><em>stmt</em> </td><td>- Statement handle</td></tr> </table></dl><dl class="note" compact><dt><b>Note:</b></dt><dd>See <a class="el" href="group__g__stmt.html#ge92422b723eef25355d91e0b50c09c0c" title="Set the long datatype handling mode of a SQL statement.">OCI_SetLongMode()</a> for possible values </dd></dl>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -