📄 oci.h
字号:
#define OCI_DTYPE_INTERVAL_YM 62 /* Interval year month */
#define OCI_DTYPE_INTERVAL_DS 63 /* Interval day second */
#define OCI_DTYPE_AQNFY_DESCRIPTOR 64 /* AQ notify descriptor */
#define OCI_DTYPE_DATE 65 /* Date */
#define OCI_DTYPE_TIME 66 /* Time */
#define OCI_DTYPE_TIME_TZ 67 /* Time with timezone */
#define OCI_DTYPE_TIMESTAMP 68 /* Timestamp */
#define OCI_DTYPE_TIMESTAMP_TZ 69 /* Timestamp with timezone */
#define OCI_DTYPE_TIMESTAMP_LTZ 70 /* Timestamp with local tz */
#define OCI_DTYPE_UCB 71 /* user callback descriptor */
#define OCI_DTYPE_SRVDN 72 /* server DN list descriptor */
#define OCI_DTYPE_SIGNATURE 73 /* signature */
#define OCI_DTYPE_RESERVED_1 74 /* reserved for internal use */
#define OCI_DTYPE_LAST 74 /* last value of a descriptor type */
/*---------------------------------------------------------------------------*/
/*--------------------------------LOB types ---------------------------------*/
#define OCI_TEMP_BLOB 1 /* LOB type - BLOB ------------------ */
#define OCI_TEMP_CLOB 2 /* LOB type - CLOB ------------------ */
/*---------------------------------------------------------------------------*/
/*-------------------------Object Ptr Types----------------------------------*/
#define OCI_OTYPE_NAME 1 /* object name */
#define OCI_OTYPE_REF 2 /* REF to TDO */
#define OCI_OTYPE_PTR 3 /* PTR to TDO */
/*---------------------------------------------------------------------------*/
/*=============================Attribute Types===============================*/
/*
Note: All attributes are global. New attibutes should be added to the end
of the list. Before you add an attribute see if an existing one can be
used for your handle.
If you see any holes please use the holes first.
*/
/*===========================================================================*/
#define OCI_ATTR_FNCODE 1 /* the OCI function code */
#define OCI_ATTR_OBJECT 2 /* is the environment initialized in object mode */
#define OCI_ATTR_NONBLOCKING_MODE 3 /* non blocking mode */
#define OCI_ATTR_SQLCODE 4 /* the SQL verb */
#define OCI_ATTR_ENV 5 /* the environment handle */
#define OCI_ATTR_SERVER 6 /* the server handle */
#define OCI_ATTR_SESSION 7 /* the user session handle */
#define OCI_ATTR_TRANS 8 /* the transaction handle */
#define OCI_ATTR_ROW_COUNT 9 /* the rows processed so far */
#define OCI_ATTR_SQLFNCODE 10 /* the SQL verb of the statement */
#define OCI_ATTR_PREFETCH_ROWS 11 /* sets the number of rows to prefetch */
#define OCI_ATTR_NESTED_PREFETCH_ROWS 12 /* the prefetch rows of nested table*/
#define OCI_ATTR_PREFETCH_MEMORY 13 /* memory limit for rows fetched */
#define OCI_ATTR_NESTED_PREFETCH_MEMORY 14 /* memory limit for nested rows */
#define OCI_ATTR_CHAR_COUNT 15
/* this specifies the bind and define size in characters */
#define OCI_ATTR_PDSCL 16 /* packed decimal scale */
#define OCI_ATTR_FSPRECISION OCI_ATTR_PDSCL
/* fs prec for datetime data types */
#define OCI_ATTR_PDPRC 17 /* packed decimal format */
#define OCI_ATTR_LFPRECISION OCI_ATTR_PDPRC
/* fs prec for datetime data types */
#define OCI_ATTR_PARAM_COUNT 18 /* number of column in the select list */
#define OCI_ATTR_ROWID 19 /* the rowid */
#define OCI_ATTR_CHARSET 20 /* the character set value */
#define OCI_ATTR_NCHAR 21 /* NCHAR type */
#define OCI_ATTR_USERNAME 22 /* username attribute */
#define OCI_ATTR_PASSWORD 23 /* password attribute */
#define OCI_ATTR_STMT_TYPE 24 /* statement type */
#define OCI_ATTR_INTERNAL_NAME 25 /* user friendly global name */
#define OCI_ATTR_EXTERNAL_NAME 26 /* the internal name for global txn */
#define OCI_ATTR_XID 27 /* XOPEN defined global transaction id */
#define OCI_ATTR_TRANS_LOCK 28 /* */
#define OCI_ATTR_TRANS_NAME 29 /* string to identify a global transaction */
#define OCI_ATTR_HEAPALLOC 30 /* memory allocated on the heap */
#define OCI_ATTR_CHARSET_ID 31 /* Character Set ID */
#define OCI_ATTR_CHARSET_FORM 32 /* Character Set Form */
#define OCI_ATTR_MAXDATA_SIZE 33 /* Maximumsize of data on the server */
#define OCI_ATTR_CACHE_OPT_SIZE 34 /* object cache optimal size */
#define OCI_ATTR_CACHE_MAX_SIZE 35 /* object cache maximum size percentage */
#define OCI_ATTR_PINOPTION 36 /* object cache default pin option */
#define OCI_ATTR_ALLOC_DURATION 37
/* object cache default allocation duration */
#define OCI_ATTR_PIN_DURATION 38 /* object cache default pin duration */
#define OCI_ATTR_FDO 39 /* Format Descriptor object attribute */
#define OCI_ATTR_POSTPROCESSING_CALLBACK 40
/* Callback to process outbind data */
#define OCI_ATTR_POSTPROCESSING_CONTEXT 41
/* Callback context to process outbind data */
#define OCI_ATTR_ROWS_RETURNED 42
/* Number of rows returned in current iter - for Bind handles */
#define OCI_ATTR_FOCBK 43 /* Failover Callback attribute */
#define OCI_ATTR_IN_V8_MODE 44 /* is the server/service context in V8 mode */
#define OCI_ATTR_LOBEMPTY 45 /* empty lob ? */
#define OCI_ATTR_SESSLANG 46 /* session language handle */
#define OCI_ATTR_VISIBILITY 47 /* visibility */
#define OCI_ATTR_RELATIVE_MSGID 48 /* relative message id */
#define OCI_ATTR_SEQUENCE_DEVIATION 49 /* sequence deviation */
#define OCI_ATTR_CONSUMER_NAME 50 /* consumer name */
#define OCI_ATTR_DEQ_MODE 51 /* dequeue mode */
#define OCI_ATTR_NAVIGATION 52 /* navigation */
#define OCI_ATTR_WAIT 53 /* wait */
#define OCI_ATTR_DEQ_MSGID 54 /* dequeue message id */
#define OCI_ATTR_PRIORITY 55 /* priority */
#define OCI_ATTR_DELAY 56 /* delay */
#define OCI_ATTR_EXPIRATION 57 /* expiration */
#define OCI_ATTR_CORRELATION 58 /* correlation id */
#define OCI_ATTR_ATTEMPTS 59 /* # of attempts */
#define OCI_ATTR_RECIPIENT_LIST 60 /* recipient list */
#define OCI_ATTR_EXCEPTION_QUEUE 61 /* exception queue name */
#define OCI_ATTR_ENQ_TIME 62 /* enqueue time (only OCIAttrGet) */
#define OCI_ATTR_MSG_STATE 63/* message state (only OCIAttrGet) */
/* NOTE: 64-66 used below */
#define OCI_ATTR_AGENT_NAME 64 /* agent name */
#define OCI_ATTR_AGENT_ADDRESS 65 /* agent address */
#define OCI_ATTR_AGENT_PROTOCOL 66 /* agent protocol */
#define OCI_ATTR_SENDER_ID 68 /* sender id */
#define OCI_ATTR_ORIGINAL_MSGID 69 /* original message id */
#define OCI_ATTR_QUEUE_NAME 70 /* queue name */
#define OCI_ATTR_NFY_MSGID 71 /* message id */
#define OCI_ATTR_MSG_PROP 72 /* message properties */
#define OCI_ATTR_NUM_DML_ERRORS 73 /* num of errs in array DML */
#define OCI_ATTR_DML_ROW_OFFSET 74 /* row offset in the array */
#define OCI_ATTR_DATEFORMAT 75 /* default date format string */
#define OCI_ATTR_BUF_ADDR 76 /* buffer address */
#define OCI_ATTR_BUF_SIZE 77 /* buffer size */
#define OCI_ATTR_DIRPATH_MODE 78 /* mode of direct path operation */
#define OCI_ATTR_DIRPATH_NOLOG 79 /* nologging option */
#define OCI_ATTR_DIRPATH_PARALLEL 80 /* parallel (temp seg) option */
#define OCI_ATTR_NUM_ROWS 81 /* number of rows in column array */
/* NOTE that OCI_ATTR_NUM_COLS is a column
* array attribute too.
*/
#define OCI_ATTR_COL_COUNT 82 /* columns of column array
processed so far. */
#define OCI_ATTR_STREAM_OFFSET 83 /* str off of last row processed */
#define OCI_ATTR_SHARED_HEAPALLOC 84 /* Shared Heap Allocation Size */
#define OCI_ATTR_SERVER_GROUP 85 /* server group name */
#define OCI_ATTR_MIGSESSION 86 /* migratable session attribute */
#define OCI_ATTR_NOCACHE 87 /* Temporary LOBs */
#define OCI_ATTR_MEMPOOL_SIZE 88 /* Pool Size */
#define OCI_ATTR_MEMPOOL_INSTNAME 89 /* Instance name */
#define OCI_ATTR_MEMPOOL_APPNAME 90 /* Application name */
#define OCI_ATTR_MEMPOOL_HOMENAME 91 /* Home Directory name */
#define OCI_ATTR_MEMPOOL_MODEL 92 /* Pool Model (proc,thrd,both)*/
#define OCI_ATTR_MODES 93 /* Modes */
#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 */
/* statement should not be executed in cache */
#define OCI_ATTR_NO_CACHE 145
#define OCI_ATTR_DEQCOND 146 /* dequeue condition */
#define OCI_ATTR_RESERVED_2 147 /* reserved */
#define OCI_ATTR_SUBSCR_RECPT 148 /* recepient of subscription */
#define OCI_ATTR_SUBSCR_RECPTPROTO 149 /* protocol for recepient */
/* 8.2 dpapi support of ADTs */
#define OCI_ATTR_DIRPATH_EXPR_TYPE 150 /* expr type of OCI_ATTR_NAME */
#define OCI_ATTR_DIRPATH_INPUT 151 /* input in text or stream format */
#define OCI_DIRPATH_INPUT_TEXT 0x01
#define OCI_DIRPATH_INPUT_STREAM 0x02
#define OCI_DIRPATH_INPUT_UNKNOWN 0x04
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -