sqlora_8h.html

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

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Get the select list columns.  <a href="group__easy.html#ga9"></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#ga10">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#ga10"></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#ga11">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#ga11"></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#ga12">sqlo_ncols</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, int in)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Get the number of bind/select-list variables.  <a href="group__easy.html#ga12"></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#ga13">sqlo_command</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 sql command.  <a href="group__easy.html#ga13"></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#ga14">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#ga14"></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#ga15">sqlo_exec</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">Execute a simple sql statement.  <a href="group__easy.html#ga15"></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#ga16">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#ga16"></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#ga17">sqlo_prows</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 number of processed rows by this statement.  <a href="group__easy.html#ga17"></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#ga0">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#ga0"></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#ga1">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#ga1"></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#ga2">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#ga2"></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#ga3">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#ga3"></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#ga4">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#ga4"></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#ga5">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#ga5"></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#ga6">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#ga6"></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#ga7">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#ga7"></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#ga8">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#ga8"></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#ga0">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#ga0"></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#ga1">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#ga1"></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#ga0">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#ga0"></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#ga1">sqlo_bind_by_name</a> (<a class="el" href="group__typedefs.html#ga1">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 class="mdescLeft">&nbsp;</td><td class="mdescRight">Bind a variable by name.  <a href="group__complex.html#ga1"></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#ga2">sqlo_bind_ref_cursor</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, const char *cursor_name, int *sth2p)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Bind a REF CURSOR.  <a href="group__complex.html#ga2"></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#ga3">sqlo_bind_by_pos</a> (<a class="el" href="group__typedefs.html#ga1">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 class="mdescLeft">&nbsp;</td><td class="mdescRight">Bind a variable by position.  <a href="group__complex.html#ga3"></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#ga4">sqlo_bind_by_pos2</a> (<a class="el" href="group__typedefs.html#ga1">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 class="mdescLeft">&nbsp;</td><td class="mdescRight">Bind a variable by position.  <a href="group__complex.html#ga4"></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#ga5">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#ga5"></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#ga6">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#ga6"></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#ga7">sqlo_define_ntable</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, unsigned int pos, int *sth2p)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Define a nested table Please visit the example for details.  <a href="group__complex.html#ga7"></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#ga8">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#ga8"></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#ga0">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#ga0"></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#ga1">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#ga1"></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#ga2">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;</td><td class="mdescRight">Write lob data from buffer into the lob column.  <a href="group__lob.html#ga2"></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#ga3">sqlo_lob_append_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;</td><td class="mdescRight">Append lob data from buffer to the lob column.  <a href="group__lob.html#ga3"></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#ga4">sqlo_lob_write_stream</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 filelen, FILE *fp)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Write lob data from a file into the lob column.  <a href="group__lob.html#ga4"></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#ga5">sqlo_lob_get_length</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 *loblenp)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Get the length of a lob.  <a href="group__lob.html#ga5"></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#ga6">sqlo_lob_read_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)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Read lob data from lob column into a buffer.  <a href="group__lob.html#ga6"></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#ga7">sqlo_lob_read_stream</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, FILE *fp)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Read lob data from lob column into a stream.  <a href="group__lob.html#ga7"></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#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">&nbsp;</td><td class="mdescRight">Get the specified OCI handle.  <a href="group__misc.html#ga0"></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#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">&nbsp;</td><td class="mdescRight">Return the database handle of a statement handle.  <a href="group__misc.html#ga1"></a><br><br></td></tr>