📄 oci.h
字号:
#define OCI_ATTR_SUBSCR_NAME 94 /* name of subscription */
#define OCI_ATTR_SUBSCR_CALLBACK 95 /* associated callback */
#define OCI_ATTR_SUBSCR_CTX 96 /* associated callback context */
#define OCI_ATTR_SUBSCR_PAYLOAD 97 /* associated payload */
#define OCI_ATTR_SUBSCR_NAMESPACE 98 /* associated namespace */
#define OCI_ATTR_PROXY_CREDENTIALS 99 /* Proxy user credentials */
#define OCI_ATTR_INITIAL_CLIENT_ROLES 100 /* Initial client role list */
#define OCI_ATTR_UNK 101 /* unknown attribute */
#define OCI_ATTR_NUM_COLS 102 /* number of columns */
#define OCI_ATTR_LIST_COLUMNS 103 /* parameter of the column list */
#define OCI_ATTR_RDBA 104 /* DBA of the segment header */
#define OCI_ATTR_CLUSTERED 105 /* whether the table is clustered */
#define OCI_ATTR_PARTITIONED 106 /* whether the table is partitioned */
#define OCI_ATTR_INDEX_ONLY 107 /* whether the table is index only */
#define OCI_ATTR_LIST_ARGUMENTS 108 /* parameter of the argument list */
#define OCI_ATTR_LIST_SUBPROGRAMS 109 /* parameter of the subprogram list */
#define OCI_ATTR_REF_TDO 110 /* REF to the type descriptor */
#define OCI_ATTR_LINK 111 /* the database link name */
#define OCI_ATTR_MIN 112 /* minimum value */
#define OCI_ATTR_MAX 113 /* maximum value */
#define OCI_ATTR_INCR 114 /* increment value */
#define OCI_ATTR_CACHE 115 /* number of sequence numbers cached */
#define OCI_ATTR_ORDER 116 /* whether the sequence is ordered */
#define OCI_ATTR_HW_MARK 117 /* high-water mark */
#define OCI_ATTR_TYPE_SCHEMA 118 /* type's schema name */
#define OCI_ATTR_TIMESTAMP 119 /* timestamp of the object */
#define OCI_ATTR_NUM_ATTRS 120 /* number of sttributes */
#define OCI_ATTR_NUM_PARAMS 121 /* number of parameters */
#define OCI_ATTR_OBJID 122 /* object id for a table or view */
#define OCI_ATTR_PTYPE 123 /* type of info described by */
#define OCI_ATTR_PARAM 124 /* parameter descriptor */
#define OCI_ATTR_OVERLOAD_ID 125 /* overload ID for funcs and procs */
#define OCI_ATTR_TABLESPACE 126 /* table name space */
#define OCI_ATTR_TDO 127 /* TDO of a type */
#define OCI_ATTR_LTYPE 128 /* list type */
#define OCI_ATTR_PARSE_ERROR_OFFSET 129 /* Parse Error offset */
#define OCI_ATTR_IS_TEMPORARY 130 /* whether table is temporary */
#define OCI_ATTR_IS_TYPED 131 /* whether table is typed */
#define OCI_ATTR_DURATION 132 /* duration of temporary table */
#define OCI_ATTR_IS_INVOKER_RIGHTS 133 /* is invoker rights */
#define OCI_ATTR_OBJ_NAME 134 /* top level schema obj name */
#define OCI_ATTR_OBJ_SCHEMA 135 /* schema name */
#define OCI_ATTR_OBJ_ID 136 /* top level schema object id */
#define OCI_ATTR_DIRPATH_SORTED_INDEX 137 /* index that data is sorted on */
/* direct path index maint method (see oci8dp.h) */
#define OCI_ATTR_DIRPATH_INDEX_MAINT_METHOD 138
/* parallel load: db file, initial and next extent sizes */
#define OCI_ATTR_DIRPATH_FILE 139 /* DB file to load into */
#define OCI_ATTR_DIRPATH_STORAGE_INITIAL 140 /* initial extent size */
#define OCI_ATTR_DIRPATH_STORAGE_NEXT 141 /* next extent size */
#define OCI_ATTR_TRANS_TIMEOUT 142 /* transaction timeout */
#define OCI_ATTR_SERVER_STATUS 143 /* state of the server handle */
#define OCI_ATTR_STATEMENT 144 /* statement txt in stmt hdl */
/* ----- Temporary attribute value for UCS2 character set ID -------- */
#define OCI_UCS2ID 1000 /* UCS2 charset ID */
/*============================== End OCI Attribute Types ====================*/
/*---------------- Server Handle Attribute Values ---------------------------*/
/* OCI_ATTR_SERVER_STATUS */
#define OCI_SERVER_NOT_CONNECTED 0x0
#define OCI_SERVER_NORMAL 0x1
/*---------------------------------------------------------------------------*/
/*------------------------- Supported Namespaces ---------------------------*/
#define OCI_SUBSCR_NAMESPACE_ANONYMOUS 0 /* Anonymous Namespace */
#define OCI_SUBSCR_NAMESPACE_AQ 1 /* Advanced Queues */
#define OCI_SUBSCR_NAMESPACE_MAX 2 /* Max Name Space Number */
/*-------------------------Credential Types----------------------------------*/
#define OCI_CRED_RDBMS 1 /* database username/password */
#define OCI_CRED_EXT 2 /* externally provided credentials */
#define OCI_CRED_PROXY 3 /* proxy authentication */
/*---------------------------------------------------------------------------*/
/*------------------------Error Return Values--------------------------------*/
#define OCI_SUCCESS 0 /* maps to SQL_SUCCESS of SAG CLI */
#define OCI_SUCCESS_WITH_INFO 1 /* maps to SQL_SUCCESS_WITH_INFO */
#define OCI_RESERVED_FOR_INT_USE 200 /* reserved for internal use */
#define OCI_NO_DATA 100 /* maps to SQL_NO_DATA */
#define OCI_ERROR -1 /* maps to SQL_ERROR */
#define OCI_INVALID_HANDLE -2 /* maps to SQL_INVALID_HANDLE */
#define OCI_NEED_DATA 99 /* maps to SQL_NEED_DATA */
#define OCI_STILL_EXECUTING -3123 /* OCI would block error */
#define OCI_CONTINUE -24200 /* Continue with the body of the OCI function */
/*---------------------------------------------------------------------------*/
/*------------------DateTime and Interval check Error codes------------------*/
/* DateTime Error Codes used by OCIDateTimeCheck() */
#define OCI_DT_INVALID_DAY 0x1 /* Bad day */
#define OCI_DT_DAY_BELOW_VALID 0x2 /* Bad DAy Low/high bit (1=low)*/
#define OCI_DT_INVALID_MONTH 0x4 /* Bad MOnth */
#define OCI_DT_MONTH_BELOW_VALID 0x8 /* Bad MOnth Low/high bit (1=low) */
#define OCI_DT_INVALID_YEAR 0x10 /* Bad YeaR */
#define OCI_DT_YEAR_BELOW_VALID 0x20 /* Bad YeaR Low/high bit (1=low) */
#define OCI_DT_INVALID_HOUR 0x40 /* Bad HouR */
#define OCI_DT_HOUR_BELOW_VALID 0x80 /* Bad HouR Low/high bit (1=low) */
#define OCI_DT_INVALID_MINUTE 0x100 /* Bad MiNute */
#define OCI_DT_MINUTE_BELOW_VALID 0x200 /*Bad MiNute Low/high bit (1=low) */
#define OCI_DT_INVALID_SECOND 0x400 /* Bad SeCond */
#define OCI_DT_SECOND_BELOW_VALID 0x800 /*bad second Low/high bit (1=low)*/
#define OCI_DT_DAY_MISSING_FROM_1582 0x1000
/* Day is one of those "missing" from 1582 */
#define OCI_DT_YEAR_ZERO 0x2000 /* Year may not equal zero */
#define OCI_DT_INVALID_TIMEZONE 0x4000 /* Bad Timezone */
#define OCI_DT_INVALID_FORMAT 0x8000 /* Bad date format input */
/* Interval Error Codes used by OCIInterCheck() */
#define OCI_INTER_INVALID_DAY 0x1 /* Bad day */
#define OCI_INTER_DAY_BELOW_VALID 0x2 /* Bad DAy Low/high bit (1=low) */
#define OCI_INTER_INVALID_MONTH 0x4 /* Bad MOnth */
#define OCI_INTER_MONTH_BELOW_VALID 0x8 /*Bad MOnth Low/high bit (1=low) */
#define OCI_INTER_INVALID_YEAR 0x10 /* Bad YeaR */
#define OCI_INTER_YEAR_BELOW_VALID 0x20 /*Bad YeaR Low/high bit (1=low) */
#define OCI_INTER_INVALID_HOUR 0x40 /* Bad HouR */
#define OCI_INTER_HOUR_BELOW_VALID 0x80 /*Bad HouR Low/high bit (1=low) */
#define OCI_INTER_INVALID_MINUTE 0x100 /* Bad MiNute */
#define OCI_INTER_MINUTE_BELOW_VALID 0x200
/*Bad MiNute Low/high bit(1=low) */
#define OCI_INTER_INVALID_SECOND 0x400 /* Bad SeCond */
#define OCI_INTER_SECOND_BELOW_VALID 0x800
/*bad second Low/high bit(1=low) */
#define OCI_INTER_INVALID_FRACSEC 0x1000 /* Bad Fractional second */
#define OCI_INTER_FRACSEC_BELOW_VALID 0x2000
/* Bad fractional second Low/High */
/*------------------------Parsing Syntax Types-------------------------------*/
#define OCI_V7_SYNTAX 2 /* V815 language - for backwards compatibility */
#define OCI_V8_SYNTAX 3 /* V815 language - for backwards compatibility */
#define OCI_NTV_SYNTAX 1 /* Use what so ever is the native lang of server */
/* these values must match the values defined in kpul.h */
/*---------------------------------------------------------------------------*/
/*------------------------Scrollable Cursor Options--------------------------*/
#define OCI_FETCH_NEXT 0x02 /* next row */
#define OCI_FETCH_FIRST 0x04 /* first row of the result set */
#define OCI_FETCH_LAST 0x08 /* the last row of the result set */
#define OCI_FETCH_PRIOR 0x10 /* the previous row relative to current */
#define OCI_FETCH_ABSOLUTE 0x20 /* absolute offset from first */
#define OCI_FETCH_RELATIVE 0x40 /* offset relative to current */
#define OCI_FETCH_RESERVED_1 0x80 /* reserved for internal use */
/*---------------------------------------------------------------------------*/
/*------------------------Bind and Define Options----------------------------*/
#define OCI_SB2_IND_PTR 0x01 /* unused */
#define OCI_DATA_AT_EXEC 0x02 /* data at execute time */
#define OCI_DYNAMIC_FETCH 0x02 /* fetch dynamically */
#define OCI_PIECEWISE 0x04 /* piecewise DMLs or fetch */
#define OCI_DEFINE_RESERVED_1 0x08 /* reserved for internal use */
#define OCI_BIND_RESERVED_2 0x10 /* reserved for internal use */
#define OCI_DEFINE_RESERVED_2 0x20 /* reserved for internal use */
/*---------------------------------------------------------------------------*/
/*----------------------------- Various Modes ------------------------------*/
#define OCI_DEFAULT 0x00 /* the default value for parameters and attributes */
/*-------------OCIInitialize Modes / OCICreateEnvironment Modes -------------*/
#define OCI_THREADED 0x01 /* the application is in threaded environment */
#define OCI_OBJECT 0x02 /* the application is in object environment */
#define OCI_EVENTS 0x04 /* the application is enabled for events */
#define OCI_RESERVED1 0x08 /* Reserved for internal use */
#define OCI_SHARED 0x10 /* the application is in shared mode */
#define OCI_RESERVED2 0x20 /* Reserved for internal use */
/* The following *TWO* are only valid for OCICreateEnvironment call */
#define OCI_NO_UCB 0x40 /* No user callback called during init */
#define OCI_NO_MUTEX 0x80 /* the environment handle will not be */
/* protected by a mutex internally */
#define OCI_SHARED_EXT 0x100 /* Used for shared forms */
#define OCI_CACHE 0x200 /* used by iCache */
/*---------------------------------------------------------------------------*/
/*----------------------------- OCIEnvInit Modes ----------------------------*/
/* NOTE: NO NEW MODES SHOULD BE ADDED HERE BECAUSE THE RECOMMENDED METHOD
* IS TO USE THE NEW OCICreateEnvironment MODES.
*/
#define OCI_ENV_NO_UCB 0x01 /* A user callback will not be called in
OCIEnvInit() */
#define OCI_ENV_NO_MUTEX 0x08 /* the environment handle will not be protected
by a mutex internally */
/*---------------------------------------------------------------------------*/
/*------------------------ Parse Modes --------------------------------------*/
#define OCI_NO_SHARING 0x01 /* turn off statement handle sharing */
/* This flag is only valid when process is in sharing mode */
/*---------------------------------------------------------------------------*/
/*----------------------- Execution Modes -----------------------------------*/
#define OCI_BATCH_MODE 0x01 /* batch the oci statement for execution */
#define OCI_EXACT_FETCH 0x02 /* fetch the exact rows specified */
#define OCI_KEEP_FETCH_STATE 0x04 /* unused */
#define OCI_SCROLLABLE_CURSOR 0x08 /* cursor scrollable */
#define OCI_DESCRIBE_ONLY 0x10 /* only describe the statement */
#define OCI_COMMIT_ON_SUCCESS 0x20 /* commit, if successful execution */
#define OCI_NON_BLOCKING 0x40 /* non-blocking */
#define OCI_BATCH_ERRORS 0x80 /* batch errors in array dmls */
#define OCI_PARSE_ONLY 0x100 /* only parse the statement */
#define OCI_EXACT_FETCH_RESERVED_1 0x200 /* reserved for internal use */
#define OCI_SHOW_DML_WARNINGS 0x400
/* return OCI_SUCCESS_WITH_INFO for del/upd with no where clause */
/*---------------------------------------------------------------------------*/
/*------------------------Authentication Modes-------------------------------*/
#define OCI_MIGRATE 0x0001 /* migratable auth context */
#define OCI_SYSDBA 0x0002 /* for SYSDBA authorization */
#define OCI_SYSOPER 0x0004 /* for SYSOPER authorization */
#define OCI_PRELIM_AUTH 0x0008 /* for preliminary authorization */
/*---------------------------------------------------------------------------*/
/*-----------------------------End Various Modes ----------------------------*/
/*------------------------Piece Information----------------------------------*/
#define OCI_PARAM_IN 0x01 /* in parameter */
#define OCI_PARAM_OUT 0x02 /* out parameter */
/*---------------------------------------------------------------------------*/
/*------------------------ Transaction Start Flags --------------------------*/
/* NOTE: OCI_TRANS_JOIN and OCI_TRANS_NOMIGRATE not supported in 8.0.X */
#define OCI_TRANS_NEW 0x00000001 /* starts a new transaction branch */
#define OCI_TRANS_JOIN 0x00000002 /* join an existing transaction */
#define OCI_TRANS_RESUME 0x00000004 /* resume this transaction */
#define OCI_TRANS_STARTMASK 0x000000ff
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -