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="sqlora_8c.html#a135">_get_ocol_db_size</a> (<a class="el" href="struct__sqlo__stmt__struct.html">sqlo_stmt_struct_ptr_t</a> stp, unsigned int pos, ub2 *sizep)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Get the database size of the output column.  <a href="#a135"></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="sqlora_8c.html#a136">_get_ocol_db_prec</a> (<a class="el" href="struct__sqlo__stmt__struct.html">sqlo_stmt_struct_ptr_t</a> stp, unsigned int pos, ub1 *precp)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Get the precision of the output column.  <a href="#a136"></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="sqlora_8c.html#a137">_get_ocol_db_scale</a> (<a class="el" href="struct__sqlo__stmt__struct.html">sqlo_stmt_struct_ptr_t</a> stp, unsigned int pos, ub1 *scalep)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Get the scale of the output column.  <a href="#a137"></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="sqlora_8c.html#a138">_get_ocol_db_is_null</a> (<a class="el" href="struct__sqlo__stmt__struct.html">sqlo_stmt_struct_ptr_t</a> stp, unsigned int pos, ub1 *is_nullp)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Get the is_null attribute of the output column.  <a href="#a138"></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="sqlora_8c.html#a139">_set_ocol_name</a> (<a class="el" href="struct__sqlo__stmt__struct.html">sqlo_stmt_struct_ptr_t</a> stp, <a class="el" href="struct__sqlo__col__struct.html">sqlo_col_struct_t</a> *colp, unsigned int pos)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Set the output column name in the col structure.  <a href="#a139"></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="sqlora_8c.html#a140">_set_all_ocol_names</a> (<a class="el" href="struct__sqlo__stmt__struct.html">sqlo_stmt_struct_ptr_t</a> stp)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Set all names of the output columns.  <a href="#a140"></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="sqlora_8c.html#a141">_find_free_dbv_entry</a> (unsigned int *free_idxp)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Looks for a free entry in _dbv.  <a href="#a141"></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="sqlora_8c.html#a142">_db_alloc</a> (unsigned int dbv_idx)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Allocates and initializes a new entry in _dbv[ dbv_idx ].  <a href="#a142"></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="sqlora_8c.html#a143">_stmtv_alloc</a> (unsigned int dbv_idx)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Allocates and initializes the stmt vector _dbv[ dbv_idx ]-&gt;stmtv.  <a href="#a143"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>char *&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="sqlora_8c.html#a146">strdup</a> (const char *s)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">strdup if not available on the target system  <a href="#a146"></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="sqlora_8c.html#a147">_mutex_init</a> (sqlo_mutex_t *mutex)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Initializes a mutex.  <a href="#a147"></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="sqlora_8c.html#a148">_mutex_lock</a> (sqlo_mutex_t *mutex)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Lock a mutex.  <a href="#a148"></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="sqlora_8c.html#a149">_mutex_unlock</a> (sqlo_mutex_t *mutex)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Unlock a mutex.  <a href="#a149"></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="sqlora_8c.html#a150">_bind_by_pos2</a> (<a class="el" href="struct__sqlo__stmt__struct.html">sqlo_stmt_struct_ptr_t</a> stp, unsigned 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 input variables.  <a href="#a150"></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="sqlora_8c.html#a151">_alloc_ocol_buffer</a> (<a class="el" href="struct__sqlo__stmt__struct.html">sqlo_stmt_struct_ptr_t</a> stp, unsigned int pos, unsigned int buffer_size)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Allocates the buffer for the output column.  <a href="#a151"></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="sqlora_8c.html#a152">_get_blocking_mode</a> (<a class="el" href="struct__sqlo__db__struct.html">sqlo_db_struct_ptr_t</a> dbp, unsigned int *blockingp)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Gets the blocking mode for a dbp.  <a href="#a152"></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="sqlora_8c.html#a153">_get_stmt_type</a> (<a class="el" href="struct__sqlo__stmt__struct.html">sqlo_stmt_struct_ptr_t</a> stp, ub2 *stmt_typep)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Determines the statement type of an already prepared statement.  <a href="#a153"></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__misc.html#ga154">sqlo_get_stmt</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">Get the sql statement text for the statement handle.  <a href="group__misc.html#ga154"></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#ga155">sqlo_get_stmt_state</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">Get the state of the statement.  <a href="group__misc.html#ga155"></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#ga157">sqlo_trace</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, int on)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Switches Oracle trace on/off.  <a href="group__misc.html#ga157"></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__error.html#ga158">sqlo_geterror</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">Return last error string.  <a href="group__error.html#ga158"></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__error.html#ga159">sqlo_geterrcode</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">Return the last error code.  <a href="group__error.html#ga159"></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#ga160">sqlo_exists</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, const char *table, const char *colname, const char *colval, const char *where)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Tests if a value exists in a table.  <a href="group__easy.html#ga160"></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#ga161">sqlo_count</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, const char *table, const char *colname, const char *colval, const char *where)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Counts the number of items in the table.  <a href="group__easy.html#ga161"></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#ga162">sqlo_run</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, const char *stmt, int argc, const char **argv)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Run a simple sql statements with parameters.  <a href="group__easy.html#ga162"></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#ga163">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#ga163"></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#ga164">sqlo_open</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, const char *stmt, int argc, const char **argv)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Open a new cursor.  <a href="group__easy.html#ga164"></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#ga165">sqlo_open2</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> *sthp, <a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, const char *stmt, int argc, const char **argv)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Open a new cursor.  <a href="group__easy.html#ga165"></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#ga166">sqlo_reopen</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, int argc, const char **argv)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Reopens a already used cursor.  <a href="group__easy.html#ga166"></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#ga167">sqlo_fetch</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, unsigned int nrows)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Fetches the data from an open cursor.  <a href="group__easy.html#ga167"></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#ga168">sqlo_values</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, int *num, int do_strip_string)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Get one dataset.  <a href="group__easy.html#ga168"></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#ga169">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#ga169"></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#ga170">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#ga170"></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#ga171">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#ga171"></a><br><br></td></tr>