sqlora_8h.html

来自「一个很好用的Linux/Unix下Oracle OCI开发接口封装库」· HTML 代码 · 共 374 行 · 第 1/3 页

&nbsp;&nbsp;<a class="el" href="group__constants.html#a6a80">SQLOT_REF</a> =  110, 
<a class="el" href="group__constants.html#a6a81">SQLOT_CLOB</a> =  112, 
<br>
&nbsp;&nbsp;<a class="el" href="group__constants.html#a6a82">SQLOT_BLOB</a> =  113, 
<a class="el" href="group__constants.html#a6a83">SQLOT_BFILEE</a> =  114, 
<br>
&nbsp;&nbsp;<a class="el" href="group__constants.html#a6a84">SQLOT_CFILEE</a> =  115, 
<a class="el" href="group__constants.html#a6a85">SQLOT_RSET</a> =  116, 
<br>
&nbsp;&nbsp;<a class="el" href="group__constants.html#a6a86">SQLOT_NCO</a> =  122, 
<a class="el" href="group__constants.html#a6a87">SQLOT_VST</a> =  155, 
<br>
&nbsp;&nbsp;<a class="el" href="group__constants.html#a6a88">SQLOT_ODT</a> =  156, 
<a class="el" href="group__constants.html#a6a89">SQLOT_DATE</a> =  184, 
<br>
&nbsp;&nbsp;<a class="el" href="group__constants.html#a6a90">SQLOT_TIME</a> =  185, 
<a class="el" href="group__constants.html#a6a91">SQLOT_TIME_TZ</a> =  186, 
<br>
&nbsp;&nbsp;<a class="el" href="group__constants.html#a6a92">SQLOT_TIMESTAMP</a> =  187, 
<a class="el" href="group__constants.html#a6a93">SQLOT_TIMESTAMP_TZ</a> =  188, 
<br>
&nbsp;&nbsp;<a class="el" href="group__constants.html#a6a94">SQLOT_INTERVAL_YM</a> =  189, 
<a class="el" href="group__constants.html#a6a95">SQLOT_INTERVAL_DS</a> =  190, 
<br>
&nbsp;&nbsp;<a class="el" href="group__constants.html#a6a96">SQLOT_TIMESTAMP_LTZ</a> =  232
<br>
 }</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>The data types for bind variables The oracle constants are copied from $ORACLE_HOME/rdbms/demo/ocidfn.h.</em> <a href="group__constants.html#a6">More...</a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>enum &nbsp;</td><td valign=bottom><a class="el" href="group__constants.html#a7">sqlo_statement_states</a> { <br>
&nbsp;&nbsp;<a class="el" href="group__constants.html#a7a97">SQLO_STMT_STATE_INITIALIZED</a> =  1, 
<a class="el" href="group__constants.html#a7a98">SQLO_STMT_STATE_EXECUTED</a> =  2, 
<br>
&nbsp;&nbsp;<a class="el" href="group__constants.html#a7a99">SQLO_STMT_STATE_END_OF_FETCH</a> =  3
<br>
 }</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Possible statement states returned by <a class="el" href="group__misc.html#a7">Miscellaneous functions</a>.</em> <a href="group__constants.html#a7">More...</a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>enum &nbsp;</td><td valign=bottom><a class="el" href="group__typedefs.html#a4">sqlo_oci_handle_types_e</a> { <br>
&nbsp;&nbsp;<a class="el" href="group__typedefs.html#a4a100">SQLO_OCI_HTYPE_ENV</a> =  1, 
<a class="el" href="group__typedefs.html#a4a101">SQLO_OCI_HTYPE_ERROR</a> =  2, 
<br>
&nbsp;&nbsp;<a class="el" href="group__typedefs.html#a4a102">SQLO_OCI_HTYPE_SVCCTX</a> =  3, 
<a class="el" href="group__typedefs.html#a4a103">SQLO_OCI_HTYPE_SERVER</a> =  4, 
<br>
&nbsp;&nbsp;<a class="el" href="group__typedefs.html#a4a104">SQLO_OCI_HTYPE_SESSION</a> =  5, 
<a class="el" href="group__typedefs.html#a4a105">SQLO_OCI_HTYPE_STMT</a> =  6
<br>
 }</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Oracle OCI Handle types used by <a class="el" href="group__misc.html#a0">Miscellaneous functions</a>.</em> <a href="group__typedefs.html#a4">More...</a><em></em></font><br><br></td></tr>
<tr><td colspan=2><br><h2>Functions</h2></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__init.html#a0">sqlo_init</a> (int threaded_mode, unsigned int max_db, unsigned int max_cursors)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Init the library.</em> <a href="group__init.html#a0"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__init.html#a1">sqlo_version</a> (const char *version_str)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Checks if the version is sufficient.</em> <a href="group__init.html#a1"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>const char *&nbsp;</td><td valign=bottom><a class="el" href="group__error.html#a0">sqlo_geterror</a> (<a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a> dbh)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Return last error string.</em> <a href="group__error.html#a0"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__error.html#a1">sqlo_geterrcode</a> (<a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a> dbh)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Return the last error code.</em> <a href="group__error.html#a1"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__easy.html#a0">sqlo_exists</a> (<a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a> dbh, const char *table, const char *colname, const char *colval, const char *where)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Tests if a value exists in a table.</em> <a href="group__easy.html#a0"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__easy.html#a1">sqlo_count</a> (<a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a> dbh, const char *table, const char *colname, const char *colval, const char *where)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Counts the number of items in the table.</em> <a href="group__easy.html#a1"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__easy.html#a2">sqlo_run</a> (<a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a> dbh, const char *stmt, int argc, const char **argv)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Run a simple sql statements with parameters.</em> <a href="group__easy.html#a2"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top><a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a>&nbsp;</td><td valign=bottom><a class="el" href="group__easy.html#a3">sqlo_open</a> (<a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a> dbh, const char *stmt, int argc, const char **argv)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Open a new cursor.</em> <a href="group__easy.html#a3"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__easy.html#a4">sqlo_open2</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> *sthp, <a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a> dbh, const char *stmt, int argc, const char **argv)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Open a new cursor.</em> <a href="group__easy.html#a4"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__easy.html#a5">sqlo_reopen</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> sth, int argc, const char **argv)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Reopens a already used cursor.</em> <a href="group__easy.html#a5"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__easy.html#a6">sqlo_fetch</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> sth, unsigned int nrows)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Fetches the data from an open cursor.</em> <a href="group__easy.html#a6"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>const char **&nbsp;</td><td valign=bottom><a class="el" href="group__easy.html#a7">sqlo_values</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> sth, int *num, int dostrip)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Get one dataset.</em> <a href="group__easy.html#a7"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>const unsigned short *&nbsp;</td><td valign=bottom><a class="el" href="group__easy.html#a8">sqlo_value_lens</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> sth, int *num)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Get the length of the returned values.</em> <a href="group__easy.html#a8"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>const char **&nbsp;</td><td valign=bottom><a class="el" href="group__easy.html#a9">sqlo_ocol_names</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> sth, int *num)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Get the select list columns.</em> <a href="group__easy.html#a9"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>const int *&nbsp;</td><td valign=bottom><a class="el" href="group__easy.html#a10">sqlo_ocol_name_lens</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> sth, int *num)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Get the select list columns name lengths.</em> <a href="group__easy.html#a10"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__easy.html#a11">sqlo_ncols</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> sth, int in)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Get the number of bind/select-list variables.</em> <a href="group__easy.html#a11"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>const char *&nbsp;</td><td valign=bottom><a class="el" href="group__easy.html#a12">sqlo_command</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> sth)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Return the sql command.</em> <a href="group__easy.html#a12"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__easy.html#a13">sqlo_close</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> sth)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Close the cursor.</em> <a href="group__easy.html#a13"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__easy.html#a14">sqlo_exec</a> (<a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a> dbh, const char *stmt)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Execute a simple sql statement.</em> <a href="group__easy.html#a14"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__easy.html#a15">sqlo_isopen</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> sth)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Test if a cursor is open.</em> <a href="group__easy.html#a15"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__easy.html#a16">sqlo_prows</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> sth)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Return the number of processed rows by this statement.</em> <a href="group__easy.html#a16"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__loginout.html#a0">sqlo_connect</a> (<a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a> *dbhp, const char *cstr)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Connect to a database.</em> <a href="group__loginout.html#a0"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__loginout.html#a1">sqlo_finish</a> (<a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a> dbh)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Finish the session.</em> <a href="group__loginout.html#a1"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__loginout.html#a2">sqlo_split_cstring</a> (const char *cstr, char *uid, char *pwd, char *tnsname, unsigned int bufsize)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Split an Oracle connect string.</em> <a href="group__loginout.html#a2"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__loginout.html#a3">sqlo_server_attach</a> (<a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a> *dbhp, const char *tnsname)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Attach to a database server.</em> <a href="group__loginout.html#a3"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__loginout.html#a4">sqlo_session_begin</a> (<a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a> dbh, const char *username, const char *password)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Begin a session.</em> <a href="group__loginout.html#a4"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__loginout.html#a5">sqlo_server_detach</a> (<a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a> dbh)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Detach from server.</em> <a href="group__loginout.html#a5"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__loginout.html#a6">sqlo_session_end</a> (<a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a> dbh)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>End a session.</em> <a href="group__loginout.html#a6"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>const char *&nbsp;</td><td valign=bottom><a class="el" href="group__loginout.html#a7">sqlo_getdatabase</a> (<a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a> dbh)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Returns the tnsname.</em> <a href="group__loginout.html#a7"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__transactions.html#a0">sqlo_commit</a> (<a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a> dbh)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Commit.</em> <a href="group__transactions.html#a0"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__transactions.html#a1">sqlo_rollback</a> (<a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a> dbh)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Rollback.</em> <a href="group__transactions.html#a1"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__complex.html#a0">sqlo_prepare</a> (<a class="el" href="group__typedefs.html#a0">sqlo_db_handle_t</a> dbh, const char *stmt)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Parse a statement.</em> <a href="group__complex.html#a0"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__complex.html#a1">sqlo_bind_by_name</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> sth, const char *name, int param_type, const void *param_addr, unsigned int param_size, short *ind_addr, int is_array)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Bind a variable by name.</em> <a href="group__complex.html#a1"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__complex.html#a2">sqlo_bind_ref_cursor</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> sth, const char *cursor_name, int *sth2p)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Bind a REF CURSOR.</em> <a href="group__complex.html#a2"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__complex.html#a3">sqlo_bind_by_pos</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> sth, int position, int param_type, const void *param_addr, unsigned int param_size, short *ind_addr, int is_array)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Bind a variable by position.</em> <a href="group__complex.html#a3"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__complex.html#a4">sqlo_bind_by_pos2</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> sth, int position, int param_type, const void *param_addr, unsigned int param_size, short *ind_addr, unsigned short *rcode_addr, unsigned int skip_size)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Bind a variable by position.</em> <a href="group__complex.html#a4"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__complex.html#a5">sqlo_define_by_pos</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> sth, int value_pos, int value_type, const void *value_addr, unsigned int value_size, short *ind_addr, short *rlen_addr, int is_array)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Define a output variable of the select list.</em> <a href="group__complex.html#a5"></a><em></em></font><br><br></td></tr>
<tr><td nowrap align=right valign=top>int&nbsp;</td><td valign=bottom><a class="el" href="group__complex.html#a6">sqlo_define_by_pos2</a> (<a class="el" href="group__typedefs.html#a1">sqlo_stmt_handle_t</a> sth, int value_pos, int value_type, const void *value_addr, unsigned int value_size, short *ind_addr, unsigned short *rlen_addr, unsigned short *rcode_addr, unsigned int skip_size)</td></tr>
<tr><td>&nbsp;</td><td><font size=-1><em>Define a output variable of the select list.</em> <a href="group__complex.html#a6"></a><em></em></font><br><br></td></tr>