Main Page | Modules | File List | Globals | Related Pages | Examples

Constants


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...

Enumeration Type Documentation

enum sqlo_constants
 

Some constants used to pass to the functions.

Enumeration values:
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.

Definition at line 193 of file sqlora.h.

enum sqlo_data_types
 

The data types for bind variables The oracle constants are copied from $ORACLE_HOME/rdbms/demo/ocidfn.h.

Note:
Not all datatypes are implemented in this module (especially exotic ones)
See also:
sqlo_bind_by_name sqlo_bind_by_pos sqlo_defined_by_pos
Enumeration values:
SQLOT_CHR  (ORANET TYPE) character string
SQLOT_NUM  (ORANET TYPE) oracle numeric
SQLOT_INT  (ORANET TYPE) integer
SQLOT_FLT  (ORANET TYPE) Floating point number
SQLOT_STR  zero terminated string
SQLOT_VNU  NUM with preceding length byte.
SQLOT_PDN  (ORANET TYPE) Packed Decimal Numeric
SQLOT_LNG  long
SQLOT_VCS  Variable character string.
SQLOT_NON  Null/empty PCC Descriptor entry.
SQLOT_RID  rowid
SQLOT_DAT  date in oracle format
SQLOT_VBI  binary in VCS format
SQLOT_BIN  binary data(DTYBIN)
SQLOT_LBI  long binary
SQLOT_UIN  unsigned integer
SQLOT_SLS  Display sign leading separate.
SQLOT_LVC  Longer longs (char).
SQLOT_LVB  Longer long binary.
SQLOT_AFC  Ansi fixed char.
SQLOT_AVC  Ansi Var char.
SQLOT_CUR  cursor type
SQLOT_RDD  rowid descriptor
SQLOT_LAB  label type
SQLOT_OSL  oslabel type
SQLOT_NTY  named object type
SQLOT_REF  ref type
SQLOT_CLOB  character lob
SQLOT_BLOB  binary lob
SQLOT_BFILEE  binary file lob
SQLOT_CFILEE  character file lob
SQLOT_RSET  result set type
SQLOT_NCO  named collection type (varray or nested table)
SQLOT_VST  OCIString type.
SQLOT_ODT  OCIDate type.
SQLOT_DATE  ANSI Date.
SQLOT_TIME  TIME.
SQLOT_TIME_TZ  TIME WITH TIME ZONE.
SQLOT_TIMESTAMP  TIMESTAMP.
SQLOT_TIMESTAMP_TZ  TIMESTAMP WITH TIME ZONE.
SQLOT_INTERVAL_YM  INTERVAL YEAR TO MONTH.
SQLOT_INTERVAL_DS  INTERVAL DAY TO SECOND.
SQLOT_TIMESTAMP_LTZ  TIMESTAMP WITH LOCAL TZ.

Definition at line 223 of file sqlora.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.

Enumeration values:
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.

Definition at line 165 of file sqlora.h.

enum sqlo_statement_states
 

Possible statement states returned by sqlo_get_stmt_state.

Enumeration values:
SQLO_STMT_STATE_INITIALIZED  Statement initialized.
SQLO_STMT_STATE_EXECUTED  Statement executed.
SQLO_STMT_STATE_END_OF_FETCH  Statement end of fetch reached.

Definition at line 285 of file sqlora.h.

enum sqlo_status_codes
 

Constants defining the return codes of the functions.

These codes map basically to the OCI return codes.

Enumeration values:
SQLO_SUCCESS  General success code (maps to OCI_SUCCESS).
SQLO_ERROR  General error code (maps to OCI_ERROR).
SQLO_INVALID_HANDLE  Maps to OCI_INVALID_HANDLE.
SQLO_STILL_EXECUTING  Maps to OCI_STILL_EXECUTING.
SQLO_CONTINUE  Maps to OCI_CONTINUE.
SQLO_SUCCESS_WITH_INFO  Maps to OCI_SUCCESS_WITH_INFO.
SQLO_NEED_DATA  Maps to OCI_NEED_DATA.
SQLO_NO_DATA  Maps to OCI_NO_DATA.

Definition at line 146 of file sqlora.h.


Generated on Mon May 21 13:38:41 2007 for libsqlora8 by  doxygen 1.3.9.1