Defines | |
#define | SQLOT_FILE SQLOT_BFILEE |
#define | SQLOT_CFILE SQLOT_CFILEE |
#define | SQLOT_BFILE SQLOT_BFILEE |
Enumerations | |
enum | sqlo_status_codes { SQLO_SUCCESS = 0, SQLO_ERROR = -1, SQLO_INVALID_HANDLE = -2, SQLO_STILL_EXECUTING = -3123, SQLO_CONTINUE = -24200, SQLO_SUCCESS_WITH_INFO = 1, SQLO_NEED_DATA = 99, SQLO_NO_DATA = 100 } |
Constants defining the return codes of the functions. More... | |
enum | sqlo_error_codes { SQLO_ERROR_BASE = -30000, SQLO_INVALID_DB_HANDLE = (SQLO_ERROR_BASE - 1), SQLO_ERRMALLOC = (SQLO_ERROR_BASE - 2), SQLO_INVALID_STMT_HANDLE = (SQLO_ERROR_BASE - 3), SQLO_STMT_NOT_OPENED = (SQLO_ERROR_BASE - 4), SQLO_INVALID_STMT_TYPE = (SQLO_ERROR_BASE - 5), SQLO_STMT_NOT_PARSED = (SQLO_ERROR_BASE - 6), SQLO_INVALID_OCI_HANDLE_TYPE = (SQLO_ERROR_BASE - 7), SQLO_MALFORMED_VERSION_STR = (SQLO_ERROR_BASE - 8), SQLO_WRONG_VERSION = (SQLO_ERROR_BASE - 9), SQLO_INVALID_COLPOS = (SQLO_ERROR_BASE - 10), SQLO_INVALID_SQL = (SQLO_ERROR_BASE -11), SQLO_UNSUPPORTED_DATA_TYPE = (SQLO_ERROR_BASE - 12) } |
Constants defining error codes returned by the library. More... | |
enum | sqlo_constants { SQLO_OFF = 0, SQLO_ON = 1, SQLO_NULL_IND = -1, SQLO_NOT_NULL_IND = 0, SQLO_STH_INIT = -1, SQLO_ONE_PIECE = 0, SQLO_FIRST_PIECE = 1, SQLO_NEXT_PIECE = 2, SQLO_LAST_PIECE = 3 } |
Some constants used to pass to the functions. More... | |
enum | sqlo_data_types { SQLOT_CHR = 1, SQLOT_NUM = 2, SQLOT_INT = 3, SQLOT_FLT = 4, SQLOT_STR = 5, SQLOT_VNU = 6, SQLOT_PDN = 7, SQLOT_LNG = 8, SQLOT_VCS = 9, SQLOT_NON = 10, SQLOT_RID = 11, SQLOT_DAT = 12, SQLOT_VBI = 15, SQLOT_BIN = 23, SQLOT_LBI = 24, SQLOT_UIN = 68, SQLOT_SLS = 91, SQLOT_LVC = 94, SQLOT_LVB = 95, SQLOT_AFC = 96, SQLOT_AVC = 97, SQLOT_CUR = 102, SQLOT_RDD = 104, SQLOT_LAB = 105, SQLOT_OSL = 106, SQLOT_NTY = 108, SQLOT_REF = 110, SQLOT_CLOB = 112, SQLOT_BLOB = 113, SQLOT_BFILEE = 114, SQLOT_CFILEE = 115, SQLOT_RSET = 116, SQLOT_NCO = 122, SQLOT_VST = 155, SQLOT_ODT = 156, SQLOT_DATE = 184, SQLOT_TIME = 185, SQLOT_TIME_TZ = 186, SQLOT_TIMESTAMP = 187, SQLOT_TIMESTAMP_TZ = 188, SQLOT_INTERVAL_YM = 189, SQLOT_INTERVAL_DS = 190, SQLOT_TIMESTAMP_LTZ = 232 } |
The data types for bind variables The oracle constants are copied from $ORACLE_HOME/rdbms/demo/ocidfn.h. More... | |
enum | sqlo_statement_states { SQLO_STMT_STATE_INITIALIZED = 1, SQLO_STMT_STATE_EXECUTED = 2, SQLO_STMT_STATE_END_OF_FETCH = 3 } |
Possible statement states returned by sqlo_get_stmt_state. More... |
enum sqlo_constants |
Some constants used to pass to the functions.
SQLO_OFF | use this to switch something off |
SQLO_ON | use this to switch someting on |
SQLO_NULL_IND | NULL indicator. |
SQLO_NOT_NULL_IND | NOT NULL indicator. |
SQLO_STH_INIT | You must init the sth with this before the first call of sqlo_open2. |
SQLO_ONE_PIECE | Piecewise operation code in sqlo_lob_write_buffer. |
SQLO_FIRST_PIECE | Piecewise operation code in sqlo_lob_write_buffer. |
SQLO_NEXT_PIECE | Piecewise operation code in sqlo_lob_write_buffer. |
SQLO_LAST_PIECE | Piecewise operation code in sqlo_lob_write_buffer. |
enum sqlo_data_types |
The data types for bind variables The oracle constants are copied from $ORACLE_HOME/rdbms/demo/ocidfn.h.
enum sqlo_error_codes |
Constants defining error codes returned by the library.
All Error codes are < -30000 to be seperated from the oracle error space.
SQLO_ERROR_BASE | All our codes are below this value. |
SQLO_INVALID_DB_HANDLE | Invalid dbh passed. |
SQLO_ERRMALLOC | Cannot allocate memory. |
SQLO_INVALID_STMT_HANDLE | Invalid statement handle passed. |
SQLO_STMT_NOT_OPENED | Tried to reopen a not opened cursor in sqlo_reopen. |
SQLO_INVALID_STMT_TYPE | Tried to parse a PL/SQL block with sqlo_open. |
SQLO_STMT_NOT_PARSED | Tried to bind in/out variables for a non-parsed statement. |
SQLO_INVALID_OCI_HANDLE_TYPE | Passed a wrong handle type to sqlo_get_oci_handle. |
SQLO_MALFORMED_VERSION_STR | Passed an invalid version string to sqlo_version. |
SQLO_WRONG_VERSION | The version of the library does not match your request. |
SQLO_INVALID_COLPOS | Column position passed to a function is wrong. |
SQLO_INVALID_SQL | A invalid sql statement was passed to sqlo_open or sqlo_open2. |
SQLO_UNSUPPORTED_DATA_TYPE | Try to query a unsupported data type. |
Possible statement states returned by sqlo_get_stmt_state.
enum sqlo_status_codes |
Constants defining the return codes of the functions.
These codes map basically to the OCI return codes.