sqlora_8c.html

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

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Close the session trace file db-&gt;trace_fp.  <a href="#a100"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top><a class="el" href="struct__sqlo__stmt__struct.html">sqlo_stmt_struct_ptr_t</a>&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="sqlora_8c.html#a101">_get_stmt_ptr</a> (<a class="el" href="struct__sqlo__db__struct.html">const_sqlo_db_struct_ptr_t</a> dbp)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Returns a free stmt struct ptr from dbp-&gt;stmtv[].  <a href="#a101"></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#a102">_stmt_new</a> (<a class="el" href="struct__sqlo__db__struct.html">sqlo_db_struct_ptr_t</a> dbp, const char *stmt, <a class="el" href="struct__sqlo__stmt__struct.html">sqlo_stmt_struct_ptr_t</a> *stpp)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Creates a new stmt.  <a href="#a102"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>void&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="sqlora_8c.html#a103">_stmt_release</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">Releases a statement.  <a href="#a103"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top><a class="anchor" name="a104" doxytag="sqlora.c::_bindpv_reset" ></a>
void&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="sqlora_8c.html#a104">_bindpv_reset</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">Resets the number of bindpv entries. <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#a105">_stmt_init</a> (<a class="el" href="struct__sqlo__stmt__struct.html">sqlo_stmt_struct_ptr_t</a> stp, <a class="el" href="struct__sqlo__db__struct.html">sqlo_db_struct_ptr_t</a> dbp, const char *stmt)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Initializes the stmt structure Sets the dbp into stp and copies stmt into the structure.  <a href="#a105"></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="sqlora_8c.html#a106">_get_stmt_type_str</a> (int stype)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Returns the statement type as a string.  <a href="#a106"></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#a107">_is_query</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">Returns whether the stmt is a query or not, by looking at stp-&gt;stype.  <a href="#a107"></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#a108">_is_plsql</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">Returns whether the stmt is a PL/SQL block or not, by looking at stp-&gt;stype.  <a href="#a108"></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#a109">_is_prepared</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">Returns whether the stmt was prepared or not.  <a href="#a109"></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#a110">_is_opened</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">Returns whether the stmt was opened or not.  <a href="#a110"></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="sqlora_8c.html#a111">_get_data_type_str</a> (int dtype)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Returns the data type as string.  <a href="#a111"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top><a class="el" href="struct__sqlo__db__struct.html">sqlo_db_struct_ptr_t</a>&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="sqlora_8c.html#a112">_db_add</a> (void)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Adds a new database entry to <a class="el" href="sqlora_8c.html#a49">_dbv</a>[].  <a href="#a112"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>void&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="sqlora_8c.html#a113">_db_release</a> (<a class="el" href="struct__sqlo__db__struct.html">sqlo_db_struct_ptr_t</a> dbp)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Release a database in _dbv[].  <a href="#a113"></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#a114">_define_by_pos</a> (<a class="el" href="struct__sqlo__stmt__struct.html">sqlo_stmt_struct_ptr_t</a> stp, unsigned int value_pos, int value_type, const void *value_addr, unsigned int value_size, short *ind_addr, ub2 *rlen_addr, ub2 *rcode_addr, int is_array)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Defines an output variable.  <a href="#a114"></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#a115">_define_by_pos2</a> (<a class="el" href="struct__sqlo__stmt__struct.html">sqlo_stmt_struct_ptr_t</a> stp, unsigned int value_pos, int value_type, const void *value_addr, unsigned int value_size, short *ind_addr, ub2 *rlen_addr, ub2 *rcode_addr, unsigned int skip_size)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Defines an output variable.  <a href="#a115"></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#a116">_calc_obuf_size</a> (unsigned int *bufsizep, unsigned int data_type, int prec, int scale, unsigned int dbsize)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Calculates the size of the output buffer for a datatype.  <a href="#a116"></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#a118">_get_errcode</a> (<a class="el" href="struct__sqlo__db__struct.html">sqlo_db_struct_ptr_t</a> dbp)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Returns the last error code.  <a href="#a118"></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#a119">_set_prefetch_rows</a> (<a class="el" href="struct__sqlo__stmt__struct.html">sqlo_stmt_struct_ptr_t</a> stp, unsigned int nrows)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Sets the attribute PREFETCH_ROWS.  <a href="#a119"></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="sqlora_8c.html#a120">_get_stmt_string</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">Gets the statement text and puts it into stp-&gt;stmt.  <a href="#a120"></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#a121">_get_stmt_state</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">Gets the statement state.  <a href="#a121"></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#a122">_alloc_definep</a> (<a class="el" href="struct__sqlo__stmt__struct.html">sqlo_stmt_struct_ptr_t</a> stp, unsigned int size)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">(Re)allocates more space for output variables.  <a href="#a122"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>void&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="sqlora_8c.html#a123">_dealloc_definep</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">Deallocates space for stp-&gt;bindpv[] and stp-&gt;indpv[] Resets stp-&gt;bindpv_size and stp-&gt;numb_bindp to 0.  <a href="#a123"></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#a124">_alloc_bindp</a> (<a class="el" href="struct__sqlo__stmt__struct.html">sqlo_stmt_struct_ptr_t</a> stp, unsigned int size)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">(Re)allocates space for stp-&gt;bindpv[] and stp-&gt;indpv[] if necessary.  <a href="#a124"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>void&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="sqlora_8c.html#a125">_dealloc_bindp</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">Deallocates space for stp-&gt;bindpv[] and stp-&gt;indpv[] Resets stp-&gt;bindpv_size and stp-&gt;numb_bindp to 0.  <a href="#a125"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>void&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="sqlora_8c.html#a126">_close_all_db_cursors</a> (<a class="el" href="struct__sqlo__db__struct.html">const_sqlo_db_struct_ptr_t</a> dbp)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Close all open cursors on a connection.  <a href="#a126"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>void&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="sqlora_8c.html#a127">_close_all_executing_cursors</a> (<a class="el" href="struct__sqlo__db__struct.html">const_sqlo_db_struct_ptr_t</a> dbp)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Close all open cursors which are in the still executing status This function returns no status code and all errors returned by <a class="el" href="group__easy.html#ga14">sqlo_close</a> are ignored.  <a href="#a127"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>FILE *&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="sqlora_8c.html#a128">_get_trace_fp</a> (<a class="el" href="struct__sqlo__db__struct.html">const_sqlo_db_struct_ptr_t</a> dbp)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Returns the trace file pointer for the db connection.  <a href="#a128"></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#a129">_prepare</a> (<a class="el" href="struct__sqlo__stmt__struct.html">sqlo_stmt_struct_ptr_t</a> stp, const char *stmt, ub2 *stmt_type)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Prepares a statement and returns the statement type.  <a href="#a129"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top>sqlo_thread_t&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="sqlora_8c.html#a130">_get_thread_id</a> (void)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Returns the thread id of this thread.  <a href="#a130"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top><a class="el" href="sqlora_8c.html#a28">bool_t</a>&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="sqlora_8c.html#a131">_thread_id_equal</a> (sqlo_thread_t id1, sqlo_thread_t id2)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Compares two thread ids and returns if they are equal.  <a href="#a131"></a><br><br></td></tr>
<tr><td class="memItemLeft" nowrap align=right valign=top><a class="el" href="struct__sqlo__stmt__struct.html">sqlo_stmt_struct_ptr_t</a>&nbsp;</td><td class="memItemRight" valign=bottom><a class="el" href="sqlora_8c.html#a132">_sth2stp</a> (int sth, const char *func_name)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Returns the pointer to the statement structure.  <a href="#a132"></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#a133">_sqlo_reopen</a> (<a class="el" href="struct__sqlo__stmt__struct.html">sqlo_stmt_struct_ptr_t</a> stp, int argc, const char **argv)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Reopens a already used cursor and binds the input variables.  <a href="#a133"></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#a134">_get_ocol_db_data_type</a> (<a class="el" href="struct__sqlo__stmt__struct.html">sqlo_stmt_struct_ptr_t</a> stp, unsigned int pos, ub2 *dtypep)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Get the database data type.  <a href="#a134"></a><br><br></td></tr>