📄 coci.cs
字号:
public const UInt32 OCI_HTYPE_SESSION = 9; /* authentication handle */
public const UInt32 OCI_ATTR_ENV = 5; /* the environment handle */
public const UInt32 OCI_ATTR_SERVER = 6; /* the server handle */
public const UInt32 OCI_ATTR_SESSION = 7; /* the user session handle */
public const UInt32 OCI_ATTR_TRANS = 8; /* the transaction handle */
public const byte OCI_LOB_READONLY = 1; /* readonly mode open for ILOB types */
public const byte OCI_LOB_READWRITE = 2; /* read write mode open for ILOBs */
public const byte OCI_ONE_PIECE = 0; /* there or this is the only piece */
public const byte OCI_FIRST_PIECE = 1; /* the first of many pieces */
public const byte OCI_NEXT_PIECE = 2; /* the next of many pieces */
public const byte OCI_LAST_PIECE = 3; /* the last piece of this column */
/* input data types */
public const UInt16 SQLT_CHR = 1; /* (ORANET TYPE) character string */
public const UInt16 SQLT_NUM = 2; /* (ORANET TYPE) oracle numeric */
public const UInt16 SQLT_INT = 3; /* (ORANET TYPE) integer */
public const UInt16 SQLT_FLT = 4; /* (ORANET TYPE) Floating point number */
public const UInt16 SQLT_STR = 5; /* zero terminated string */
public const UInt16 SQLT_VNU = 6; /* NUM with preceding length byte */
public const UInt16 SQLT_BIN = 23; /* binary data(DTYBIN) */
public const UInt16 SQLT_LBI = 24; /* long binary */
public const UInt16 SQLT_CLOB = 112; /* character lob */
public const UInt16 SQLT_BLOB = 113; /* binary lob */
public const UInt16 SQLT_BFILEE = 114; /* binary file lob */
public const UInt16 SQLT_CFILEE = 115; /* character file lob */
public const UInt16 SQLT_DATE = 184; /* ANSI Date */
public const UInt16 SQLT_TIME = 185; /* TIME */
/*----------------------- Execution Modes -----------------------------------*/
public const UInt32 OCI_BATCH_MODE = 0x01; /* batch the oci statement for execution */
public const UInt32 OCI_EXACT_FETCH = 0x02; /* fetch the exact rows specified */
public const UInt32 OCI_KEEP_FETCH_STATE = 0x04; /* unused */
public const UInt32 OCI_STMT_SCROLLABLE_READONLY = 0x08; /* if result set is scrollable */
public const UInt32 OCI_DESCRIBE_ONLY = 0x10; /* only describe the statement */
public const UInt32 OCI_COMMIT_ON_SUCCESS = 0x20; /* commit, if successful execution */
public const UInt32 OCI_NON_BLOCKING = 0x40; /* non-blocking */
public const UInt32 OCI_BATCH_ERRORS = 0x80; /* batch errors in array dmls */
public const UInt32 OCI_PARSE_ONLY = 0x100; /* only parse the statement */
public const UInt32 OCI_EXACT_FETCH_RESERVED_1 = 0x200; /* reserved */
public const UInt32 OCI_SHOW_DML_WARNINGS = 0x400;
/* return OCI_SUCCESS_WITH_INFO for delete/update w/no where clause */
public const UInt32 OCI_EXEC_RESERVED_2 = 0x800; /* reserved */
public const UInt32 OCI_DESC_RESERVED_1 = 0x1000; /* reserved */
/*---------------------------------------------------------------------------*/
/*------------------------Parsing Syntax Types-------------------------------*/
public const UInt32 OCI_V7_SYNTAX = 2; /* V815 language - for backwards compatibility */
public const UInt32 OCI_V8_SYNTAX = 3; /* V815 language - for backwards compatibility */
public const UInt32 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 Fetch Options-------------------
* For non-scrollable cursor, the only valid (and default) orientation is
* OCI_FETCH_NEXT
*/
public const UInt32 OCI_FETCH_CURRENT = 0x01; /* refetching current position */
public const UInt16 OCI_FETCH_NEXT = 0x02; /* next row */
public const UInt32 OCI_FETCH_FIRST = 0x04; /* first row of the result set */
public const UInt32 OCI_FETCH_LAST = 0x08; /* the last row of the result set */
public const UInt32 OCI_FETCH_PRIOR = 0x10; /* the previous row relative to current */
public const UInt32 OCI_FETCH_ABSOLUTE = 0x20; /* absolute offset from first */
public const UInt32 OCI_FETCH_RELATIVE = 0x40; /* offset relative to current */
public const UInt32 OCI_FETCH_RESERVED_1 = 0x80; /* reserved */
public const UInt32 OCI_ATTR_ROWS_FETCHED = 197; /* rows fetched in last call */
/*---------------------------------------------------------------------------*/
/*--------------------------- OCI Statement Types ---------------------------*/
public const UInt16 OCI_STMT_SELECT = 1; /* select statement */
public const UInt16 OCI_STMT_UPDATE = 2; /* update statement */
public const UInt16 OCI_STMT_DELETE = 3; /* delete statement */
public const UInt16 OCI_STMT_INSERT = 4; /* Insert Statement */
public const UInt16 OCI_STMT_CREATE = 5; /* create statement */
public const UInt16 OCI_STMT_DROP = 6; /* drop statement */
public const UInt16 OCI_STMT_ALTER = 7; /* alter statement */
public const UInt16 OCI_STMT_BEGIN = 8; /* begin ... (pl/sql statement)*/
public const UInt16 OCI_STMT_DECLARE = 9; /* declare .. (pl/sql statement ) */
/*---------------------------------------------------------------------------*/
/*-------------------------Descriptor Types----------------------------------*/
/* descriptor values range from 50 - 255 */
public const UInt32 OCI_DTYPE_FIRST = 50; /* start value of descriptor type */
//public const UInt32 OCI_DTYPE_LOB = 50; /* lob locator */
public const UInt32 OCI_DTYPE_SNAP = 51; /* snapshot descriptor */
public const UInt32 OCI_DTYPE_RSET = 52; /* result set descriptor */
public const UInt32 OCI_DTYPE_PARAM = 53; /* a parameter descriptor obtained from ocigparm */
public const UInt32 OCI_DTYPE_ROWID = 54; /* rowid descriptor */
public const UInt32 OCI_DTYPE_COMPLEXOBJECTCOMP = 55;
/* complex object retrieval descriptor */
public const UInt32 OCI_DTYPE_FILE = 56; /* File Lob locator */
public const UInt32 OCI_DTYPE_AQENQ_OPTIONS = 57; /* enqueue options */
public const UInt32 OCI_DTYPE_AQDEQ_OPTIONS = 58; /* dequeue options */
public const UInt32 OCI_DTYPE_AQMSG_PROPERTIES = 59; /* message properties */
public const UInt32 OCI_DTYPE_AQAGENT = 60; /* aq agent */
public const UInt32 OCI_DTYPE_LOCATOR = 61; /* LOB locator */
public const UInt32 OCI_DTYPE_INTERVAL_YM = 62; /* Interval year month */
public const UInt32 OCI_DTYPE_INTERVAL_DS = 63; /* Interval day second */
public const UInt32 OCI_DTYPE_AQNFY_DESCRIPTOR = 64; /* AQ notify descriptor */
public const UInt32 OCI_DTYPE_DATE = 65; /* Date */
public const UInt32 OCI_DTYPE_TIME = 66; /* Time */
public const UInt32 OCI_DTYPE_TIME_TZ = 67; /* Time with timezone */
public const UInt32 OCI_DTYPE_TIMESTAMP = 68; /* Timestamp */
public const UInt32 OCI_DTYPE_TIMESTAMP_TZ = 69; /* Timestamp with timezone */
public const UInt32 OCI_DTYPE_TIMESTAMP_LTZ = 70; /* Timestamp with local tz */
public const UInt32 OCI_DTYPE_UCB = 71; /* user callback descriptor */
public const UInt32 OCI_DTYPE_SRVDN = 72; /* server DN list descriptor */
public const UInt32 OCI_DTYPE_SIGNATURE = 73; /* signature */
public const UInt32 OCI_DTYPE_RESERVED_1 = 74; /* reserved for internal use */
public const UInt32 OCI_DTYPE_LAST = 74; /* last value of a descriptor type */
/*---------------------------------------------------------------------------*/
/*===========================================================================*/
/* Attributes common to Columns and Stored Procs */
public const UInt32 OCI_ATTR_DATA_SIZE = 1; /* maximum size of the data */
public const UInt32 OCI_ATTR_DATA_TYPE = 2; /* the SQL type of the column/argument */
public const UInt32 OCI_ATTR_DISP_SIZE = 3; /* the display size */
public const UInt32 OCI_ATTR_NAME = 4; /* the name of the column/argument */
public const UInt32 OCI_ATTR_PRECISION = 5; /* precision if number type */
public const UInt32 OCI_ATTR_SCALE = 6; /* scale if number type */
public const UInt32 OCI_ATTR_IS_NULL = 7; /* is it null ? */
public const UInt32 OCI_ATTR_TYPE_NAME = 8;
/* name of the named data type or a package name for package private types */
public const UInt32 OCI_ATTR_SCHEMA_NAME = 9; /* the schema name */
public const UInt32 OCI_ATTR_SUB_NAME = 10; /* type name if package private type */
public const UInt32 OCI_ATTR_POSITION = 11;
/*------------------------Authentication Modes-------------------------------*/
public const UInt32 OCI_MIGRATE = 0x0001; /* migratable auth context */
public const UInt32 OCI_SYSDBA = 0x0002; /* for SYSDBA authorization */
public const UInt32 OCI_SYSOPER = 0x0004; /* for SYSOPER authorization */
public const UInt32 OCI_PRELIM_AUTH = 0x0008; /* for preliminary authorization */
public const UInt32 OCIP_ICACHE = 0x0010; /* Private OCI cache mode to notify cache */
public const UInt32 OCI_AUTH_RESERVED_1 = 0x0020; /* reserved */
public const UInt32 OCI_STMT_CACHE = 0x0040; /* enable OCI Stmt Caching */
/*---------------------------------------------------------------------------*/
/*------------------------Session End Modes----------------------------------*/
public const UInt32 OCI_SESSEND_RESERVED_1 = 0x0001; /* reserved */
/*---------------------------------------------------------------------------*/
/* CHAR/NCHAR/VARCHAR2/NVARCHAR2/CLOB/NCLOB char set "form" information */
public const byte SQLCS_IMPLICIT = 1; /* for CHAR, VARCHAR2, CLOB w/o a specified set */
public const byte SQLCS_NCHAR = 2; /* for NCHAR, NCHAR VARYING, NCLOB */
public const byte SQLCS_EXPLICIT = 3; /* for CHAR, etc, with "CHARACTER SET ..." syntax */
public const byte SQLCS_FLEXIBLE = 4; /* for PL/SQL "flexible" parameters */
public const byte SQLCS_LIT_NULL = 5; /* for typecheck of NULL and empty_clob() lits */
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -