sqlora_8c.html

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

<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga172">sqlo_close</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Close the cursor.  <a href="group__easy.html#ga172"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__misc.html#ga173">sqlo_print</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Print info about the statement to stdout.  <a href="group__misc.html#ga173"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__loginout.html#ga174">sqlo_split_cstring</a> (const char *cstr, char *uid, char *pwd, char *tnsname, unsigned int bufsize)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Split an Oracle connect string.  <a href="group__loginout.html#ga174"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__loginout.html#ga175">sqlo_server_attach</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> *dbhp, const char *tnsname)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Attach to a database server.  <a href="group__loginout.html#ga175"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__loginout.html#ga176">sqlo_session_begin</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, const char *username, const char *password)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Begin a session.  <a href="group__loginout.html#ga176"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__loginout.html#ga177">sqlo_server_detach</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Detach from server.  <a href="group__loginout.html#ga177"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__loginout.html#ga178">sqlo_server_free</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Free a server connection This is your emergency exit when a connection to a database gets lost (end of file on communication channel).  <a href="group__loginout.html#ga178"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__loginout.html#ga179">sqlo_session_end</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">End a session.  <a href="group__loginout.html#ga179"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__loginout.html#ga180">sqlo_connect</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> *dbhp, const char *cstr)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Connect to a database.  <a href="group__loginout.html#ga180"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__loginout.html#ga181">sqlo_finish</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Finish the session.  <a href="group__loginout.html#ga181"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>const char *&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__loginout.html#ga182">sqlo_getdatabase</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Returns the tnsname.  <a href="group__loginout.html#ga182"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__transactions.html#ga183">sqlo_commit</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Commit.  <a href="group__transactions.html#ga183"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__transactions.html#ga184">sqlo_rollback</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Rollback.  <a href="group__transactions.html#ga184"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga185">sqlo_isopen</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Test if a cursor is open.  <a href="group__easy.html#ga185"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__complex.html#ga186">sqlo_prepare</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, const char *stmt)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Parse a statement.  <a href="group__complex.html#ga186"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__complex.html#ga187">sqlo_bind_by_name</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, const char *param_name, int param_type, const void *param_addr, unsigned int param_size, short *ind_addr, int is_array)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Bind a variable by name.  <a href="group__complex.html#ga187"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__complex.html#ga190">sqlo_bind_by_pos</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, int param_pos, int param_type, const void *param_addr, unsigned int param_size, short *ind_addr, int is_array)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Bind a variable by position.  <a href="group__complex.html#ga190"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__complex.html#ga191">sqlo_bind_by_pos2</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, int param_pos, 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 class="mdescLeft">&nbsp;</td><td class="mdescRight">Bind a variable by position.  <a href="group__complex.html#ga191"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__complex.html#ga192">sqlo_define_by_pos</a> (<a class="el" href="group__typedefs.html#ga1">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 class="mdescLeft">&nbsp;</td><td class="mdescRight">Define a output variable of the select list.  <a href="group__complex.html#ga192"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__complex.html#ga193">sqlo_define_by_pos2</a> (<a class="el" href="group__typedefs.html#ga1">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 class="mdescLeft">&nbsp;</td><td class="mdescRight">Define a output variable of the select list.  <a href="group__complex.html#ga193"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__complex.html#ga194">sqlo_execute</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, unsigned int iterations)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Execute a statement.  <a href="group__complex.html#ga194"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>const char **&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga195">sqlo_ocol_names</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, int *num)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Get the select list columns.  <a href="group__easy.html#ga195"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga196">sqlo_ocol_names2</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, int *num, const char ***ocol_names)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Get the select list columns.  <a href="group__easy.html#ga196"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>const int *&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga197">sqlo_ocol_name_lens</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, int *num)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Get the select list columns name lengths.  <a href="group__easy.html#ga197"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>const unsigned short *&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga198">sqlo_value_lens</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, int *num)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Get the length of the returned values.  <a href="group__easy.html#ga198"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__misc.html#ga199">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">&nbsp;</td><td class="mdescRight">Get the specified OCI handle.  <a href="group__misc.html#ga199"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__misc.html#ga200">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">&nbsp;</td><td class="mdescRight">Return the database handle of a statement handle.  <a href="group__misc.html#ga200"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__init.html#ga201">sqlo_version</a> (const char *version_str)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Checks if the version is sufficient.  <a href="group__init.html#ga201"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__misc.html#ga202">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">&nbsp;</td><td class="mdescRight">Set OCI blocking mode on/off.  <a href="group__misc.html#ga202"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__misc.html#ga203">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">&nbsp;</td><td class="mdescRight">Get OCI blocking mode.  <a href="group__misc.html#ga203"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__misc.html#ga204">sqlo_break</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Abort all operations in non-blocking mode.  <a href="group__misc.html#ga204"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__lob.html#ga205">sqlo_alloc_lob_desc</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, <a class="el" href="group__typedefs.html#ga2">sqlo_lob_desc_t</a> *loblpp)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Allocate a lob descriptor.  <a href="group__lob.html#ga205"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__lob.html#ga206">sqlo_free_lob_desc</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, <a class="el" href="group__typedefs.html#ga2">sqlo_lob_desc_t</a> *loblpp)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Free a lob descriptor.  <a href="group__lob.html#ga206"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>int&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="group__lob.html#ga207">sqlo_lob_write_buffer</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, <a class="el" href="group__typedefs.html#ga2">sqlo_lob_desc_t</a> loblp, unsigned int loblen, void *bufp, unsigned int bufl, unsigned int piece)</td></tr>

<tr><td class="mdescLeft">&nbsp;</