Functions | |
int | sqlo_exists (sqlo_db_handle_t dbh, const char *table, const char *colname, const char *colval, const char *where) |
Tests if a value exists in a table. More... | |
int | sqlo_count (sqlo_db_handle_t dbh, const char *table, const char *colname, const char *colval, const char *where) |
Counts the number of items in the table. More... | |
int | sqlo_run (sqlo_db_handle_t dbh, const char *stmt, int argc, const char **argv) |
Run a simple sql statements with parameters. More... | |
sqlo_stmt_handle_t | sqlo_open (sqlo_db_handle_t dbh, const char *stmt, int argc, const char **argv) |
Open a new cursor. More... | |
int | sqlo_open2 (sqlo_stmt_handle_t *sthp, sqlo_db_handle_t dbh, const char *stmt, int argc, const char **argv) |
Open a new cursor. More... | |
int | sqlo_reopen (sqlo_stmt_handle_t sth, int argc, const char **argv) |
Reopens a already used cursor. More... | |
int | sqlo_fetch (sqlo_stmt_handle_t sth, unsigned int nrows) |
Fetches the data from an open cursor. More... | |
const char ** | sqlo_values (sqlo_stmt_handle_t sth, int *num, int dostrip) |
Get one dataset. More... | |
const unsigned short * | sqlo_value_lens (sqlo_stmt_handle_t sth, int *num) |
Get the length of the returned values. More... | |
const char ** | sqlo_ocol_names (sqlo_stmt_handle_t sth, int *num) |
Get the select list columns. More... | |
const int * | sqlo_ocol_name_lens (sqlo_stmt_handle_t sth, int *num) |
Get the select list columns name lengths. More... | |
int | sqlo_ncols (sqlo_stmt_handle_t sth, int in) |
Get the number of bind/select-list variables. More... | |
const char * | sqlo_command (sqlo_stmt_handle_t sth) |
Return the sql command. More... | |
int | sqlo_close (sqlo_stmt_handle_t sth) |
Close the cursor. More... | |
int | sqlo_exec (sqlo_db_handle_t dbh, const char *stmt) |
Execute a simple sql statement. More... | |
int | sqlo_isopen (sqlo_stmt_handle_t sth) |
Test if a cursor is open. More... | |
int | sqlo_prows (sqlo_stmt_handle_t sth) |
Return the number of processed rows by this statement. More... |
The query results are also converted to strings.
|
Close the cursor. Closes the cursor and releases the Oracle statement handle.
|
|
Return the sql command.
|
|
Counts the number of items in the table. Counts the number of items where field = value [AND where]
|
|
Execute a simple sql statement. Use this to execute non-qeuery statements without bind variables.
|
|
Tests if a value exists in a table. Tests if a record exists in a table where field = value [AND where].
|
|
Fetches the data from an open cursor. This functions fetches data from an open cursor, if the sql was a query. For non-queries, the statement is executed. Use sqlo_values to get the data.
|
|
Test if a cursor is open.
|
|
Get the number of bind/select-list variables.
|
|
Get the select list columns name lengths. Use this function to get the length of each select list column. Call this when you need the length of the column, for formatting purposes etc.
|
|
Get the select list columns. Use this function to get the select list column names. Most usefull for dynamic sql, where you don't know the sql statement at all.
|
|
Open a new cursor. This function opens a new cursor for a query statement. If the stmt is a SELECT statement, the function sets the attribute OCI_ATTR_PREFETCH rows to the max arraysize parameter of the library. This is a kind of internal array fetch Oracle provides to speed up the fetching.
|
|
Open a new cursor. This function opens a new cursor for a query statement. Use this function if your bind variables are all strings. If you need native datatype support, use sqlo_prepare If the stmt is a SELECT statement, the function sets the attribute OCI_ATTR_PREFETCH rows to the max arraysize parameter of the library. This is a kind of internal array fetch Oracle provides to speed up the fetching.
|
|
Return the number of processed rows by this statement.
|
|
Reopens a already used cursor. This function reopens an already used cursor with new bind variables. Reopening cursors improve the speed, because no new parse is necessary.
|
|
Run a simple sql statements with parameters. Like sqlo_exec, but with bind parameters. This is basically the same as calling sqlo_open followed by sqlo_fetch and sqlo_close.
|
|
Get the length of the returned values. Returns the length in number of characters (bytes for non-unicode chars) for a dataset fetched by sqlo_fetch.
|
|
Get one dataset. Returns the data for one set of data fetched via sqlo_fetch.
|