📄 sdora.pas
字号:
// Error Return Values
OCI_SUCCESS = 0; // maps to SQL_SUCCESS of SAG CLI
OCI_SUCCESS_WITH_INFO = 1; // maps to SQL_SUCCESS_WITH_INFO
OCI_RESERVED_FOR_INT_USE=200; //* reserved for internal use
OCI_NO_DATA = 100; // maps to SQL_NO_DATA
OCI_ERROR = -1; // maps to SQL_ERROR
OCI_INVALID_HANDLE = -2; // maps to SQL_INVALID_HANDLE
OCI_NEED_DATA = 99; // maps to SQL_NEED_DATA
OCI_STILL_EXECUTING = -3123; // OCI would block error
OCI_CONTINUE = -24200; // Continue with the body of the OCI function
//------------------DateTime and Interval check Error codes------------------
// DateTime Error Codes used by OCIDateTimeCheck()
OCI_DT_INVALID_DAY = $1; // Bad day
OCI_DT_DAY_BELOW_VALID = $2; // Bad DAy Low/high bit (1=low)
OCI_DT_INVALID_MONTH = $4; // Bad MOnth
OCI_DT_MONTH_BELOW_VALID = $8; // Bad MOnth Low/high bit (1=low)
OCI_DT_INVALID_YEAR = $10; // Bad YeaR
OCI_DT_YEAR_BELOW_VALID = $20; // Bad YeaR Low/high bit (1=low)
OCI_DT_INVALID_HOUR = $40; // Bad HouR
OCI_DT_HOUR_BELOW_VALID = $80; // Bad HouR Low/high bit (1=low)
OCI_DT_INVALID_MINUTE = $100; // Bad MiNute
OCI_DT_MINUTE_BELOW_VALID = $200; //Bad MiNute Low/high bit (1=low)
OCI_DT_INVALID_SECOND = $400; // Bad SeCond
OCI_DT_SECOND_BELOW_VALID = $800; //bad second Low/high bit (1=low)
OCI_DT_DAY_MISSING_FROM_1582= $1000; // Day is one of those "missing" from 1582
OCI_DT_YEAR_ZERO = $2000; // Year may not equal zero
OCI_DT_INVALID_TIMEZONE = $4000; // Bad Timezone
OCI_DT_INVALID_FORMAT = $8000; // Bad date format input
// Interval Error Codes used by OCIInterCheck()
OCI_INTER_INVALID_DAY = $1; // Bad day
OCI_INTER_DAY_BELOW_VALID = $2; // Bad DAy Low/high bit (1=low)
OCI_INTER_INVALID_MONTH = $4; // Bad MOnth
OCI_INTER_MONTH_BELOW_VALID = $8; //Bad MOnth Low/high bit (1=low)
OCI_INTER_INVALID_YEAR = $10; // Bad YeaR
OCI_INTER_YEAR_BELOW_VALID = $20; //Bad YeaR Low/high bit (1=low)
OCI_INTER_INVALID_HOUR = $40; // Bad HouR
OCI_INTER_HOUR_BELOW_VALID = $80; //Bad HouR Low/high bit (1=low)
OCI_INTER_INVALID_MINUTE = $100; // Bad MiNute
OCI_INTER_MINUTE_BELOW_VALID = $200; //Bad MiNute Low/high bit(1=low)
OCI_INTER_INVALID_SECOND = $400; // Bad SeCond
OCI_INTER_SECOND_BELOW_VALID = $800; //bad second Low/high bit(1=low)
OCI_INTER_INVALID_FRACSEC = $1000; // Bad Fractional second
OCI_INTER_FRACSEC_BELOW_VALID= $2000; // Bad fractional second Low/High
// Parsing Syntax Types
OCI_V7_SYNTAX = 2; // V7 language
OCI_V8_SYNTAX = 3; // V8 language
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
OCI_FETCH_CURRENT = $01; // refetching current position
OCI_FETCH_NEXT = $02; // next row
OCI_FETCH_FIRST = $04; // first row of the result set
OCI_FETCH_LAST = $08; // the last row of the result set
OCI_FETCH_PRIOR = $10; // the previous row relative to current
OCI_FETCH_ABSOLUTE = $20; // absolute offset from first
OCI_FETCH_RELATIVE = $40; // offset relative to current
OCI_FETCH_RESERVED_1 = $80; // reserved
// Bind and Define Options
OCI_SB2_IND_PTR = $01;
OCI_DATA_AT_EXEC = $02;
OCI_DYNAMIC_FETCH = $02;
OCI_PIECEWISE = $04;
// Execution Modes
OCI_BATCH_MODE = $01;
OCI_EXACT_FETCH = $02;
OCI_KEEP_FETCH_STATE = $04;
OCI_SCROLLABLE_CURSOR = $08;
OCI_DESCRIBE_ONLY = $10;
OCI_COMMIT_ON_SUCCESS = $20;
// Authentication Modes
OCI_MIGRATE = $0001; // migratable auth context
OCI_SYSDBA = $0002; // for SYSDBA authorization
OCI_SYSOPER = $0004; // for SYSOPER authorization
OCI_PRELIM_AUTH = $0008; // for preliminary authorization
// Piece Information
OCI_PARAM_IN = $01;
OCI_PARAM_OUT = $02;
// Transaction Start Flags
OCI_TRANS_OLD = $00000000;
OCI_TRANS_NEW = $00000001;
OCI_TRANS_JOIN = $00000002;
OCI_TRANS_RESUME = $00000004;
OCI_TRANS_STARTMASK = $000000FF;
OCI_TRANS_READONLY = $00000100;
OCI_TRANS_READWRITE = $00000200;
OCI_TRANS_SERIALIZABLE= $00000400;
OCI_TRANS_ISOLMASK = $0000FF00;
OCI_TRANS_LOOSE = $00010000;
OCI_TRANS_TIGHT = $00020000;
OCI_TRANS_TYPEMASK = $000F0000;
OCI_TRANS_NOMIGRATE = $00100000;
// Transaction End Flags
OCI_TRANS_TWOPHASE = $01000000;
// Object Types
OCI_OTYPE_UNK = 0;
OCI_OTYPE_TABLE = 1;
OCI_OTYPE_VIEW = 2;
OCI_OTYPE_SYN = 3;
OCI_OTYPE_PROC = 4;
OCI_OTYPE_FUNC = 5;
OCI_OTYPE_PKG = 6;
OCI_OTYPE_STMT = 7;
//=======================Describe Handle Parameter Attributes ===============
// attributes common to Columns and Stored Procs
OCI_ATTR_DATA_SIZE = 1;
OCI_ATTR_DATA_TYPE = 2;
OCI_ATTR_DISP_SIZE = 3;
OCI_ATTR_NAME = 4;
OCI_ATTR_PRECISION = 5;
OCI_ATTR_SCALE = 6;
OCI_ATTR_IS_NULL = 7;
OCI_ATTR_TYPE_NAME = 8;
OCI_ATTR_SCHEMA_NAME = 9;
OCI_ATTR_SUB_NAME = 10;
OCI_ATTR_POSITION = 11;
// complex object retrieval parameter attributes
OCI_ATTR_COMPLEXOBJECTCOMP_TYPE = 50;
OCI_ATTR_COMPLEXOBJECTCOMP_TYPE_LEVEL = 51;
OCI_ATTR_COMPLEXOBJECT_LEVEL = 52;
OCI_ATTR_COMPLEXOBJECT_COLL_OUTOFLINE = 53;
// only Columns
OCI_ATTR_DISP_NAME = 100; // the display name
// only Stored Procs
OCI_ATTR_OVERLOAD = 210; // is this position overloaded
OCI_ATTR_LEVEL = 211; // level for structured types
OCI_ATTR_HAS_DEFAULT = 212; // has a default value
OCI_ATTR_IOMODE = 213; // in, out inout
OCI_ATTR_RADIX = 214; // returns a radix
OCI_ATTR_NUM_ARGS = 215; // total number of arguments
// only user-defined Type's
OCI_ATTR_TYPECODE = 216; // object or collection
OCI_ATTR_COLLECTION_TYPECODE = 217; // varray or nested table
OCI_ATTR_VERSION = 218; // user assigned version
OCI_ATTR_IS_INCOMPLETE_TYPE = 219; // is this an incomplete type
OCI_ATTR_IS_SYSTEM_TYPE = 220; // a system type
OCI_ATTR_IS_PREDEFINED_TYPE = 221; // a predefined type
OCI_ATTR_IS_TRANSIENT_TYPE = 222; // a transient type
OCI_ATTR_IS_SYSTEM_GENERATED_TYPE=223;// system generated type
OCI_ATTR_HAS_NESTED_TABLE = 224; // contains nested table attr
OCI_ATTR_HAS_LOB = 225; // has a lob attribute
OCI_ATTR_HAS_FILE = 226; // has a file attribute
OCI_ATTR_COLLECTION_ELEMENT = 227; // has a collection attribute
OCI_ATTR_NUM_TYPE_ATTRS = 228; // number of attribute types
OCI_ATTR_LIST_TYPE_ATTRS = 229; // list of type attributes
OCI_ATTR_NUM_TYPE_METHODS = 230; // number of type methods
OCI_ATTR_LIST_TYPE_METHODS = 231; // list of type methods
OCI_ATTR_MAP_METHOD = 232; // map method of type
OCI_ATTR_ORDER_METHOD = 233; // order method of type
// only collection element
OCI_ATTR_NUM_ELEMS = 234; // number of elements
// only type methods
OCI_ATTR_ENCAPSULATION = 235; // encapsulation level
OCI_ATTR_IS_SELFISH = 236; // method selfish
OCI_ATTR_IS_VIRTUAL = 237; // virtual
OCI_ATTR_IS_INLINE = 238; // inline
OCI_ATTR_IS_CONSTANT = 239; // constant
OCI_ATTR_HAS_RESULT = 240; // has result
OCI_ATTR_IS_CONSTRUCTOR = 241; // constructor
OCI_ATTR_IS_DESTRUCTOR = 242; // destructor
OCI_ATTR_IS_OPERATOR = 243; // operator
OCI_ATTR_IS_MAP = 244; // a map method
OCI_ATTR_IS_ORDER = 245; // order method
OCI_ATTR_IS_RNDS = 246; // read no data state method
OCI_ATTR_IS_RNPS = 247; // read no process state
OCI_ATTR_IS_WNDS = 248; // write no data state method
OCI_ATTR_IS_WNPS = 249; // write no process state
OCI_ATTR_DESC_PUBLIC = 250; // public object
// Object Cache Enhancements : attributes for User Constructed Instances
OCI_ATTR_CACHE_CLIENT_CONTEXT = 251;
OCI_ATTR_UCI_CONSTRUCT = 252;
OCI_ATTR_UCI_DESTRUCT = 253;
OCI_ATTR_UCI_COPY = 254;
OCI_ATTR_UCI_PICKLE = 255;
OCI_ATTR_UCI_UNPICKLE = 256;
OCI_ATTR_UCI_REFRESH = 257;
// for type inheritance
OCI_ATTR_IS_SUBTYPE = 258;
OCI_ATTR_SUPERTYPE_SCHEMA_NAME= 259;
OCI_ATTR_SUPERTYPE_NAME = 260;
// for schemas
OCI_ATTR_LIST_OBJECTS = 261; // list of objects in schema
// for database
OCI_ATTR_NCHARSET_ID = 262; // char set id
OCI_ATTR_LIST_SCHEMAS = 263; // list of schemas
OCI_ATTR_MAX_PROC_LEN = 264; // max procedure length
OCI_ATTR_MAX_COLUMN_LEN = 265; // max column name length
OCI_ATTR_CURSOR_COMMIT_BEHAVIOR=266; // cursor commit behavior
OCI_ATTR_MAX_CATALOG_NAMELEN = 267; // catalog namelength
OCI_ATTR_CATALOG_LOCATION = 268; // catalog location
OCI_ATTR_SAVEPOINT_SUPPORT = 269; // savepoint support
OCI_ATTR_NOWAIT_SUPPORT = 270; // nowait support
OCI_ATTR_AUTOCOMMIT_DDL = 271; // autocommit DDL
OCI_ATTR_LOCKING_MODE = 272; // locking mode
// for externally initialized context
OCI_ATTR_APPCTX_SIZE = 273; // count of context to be init
OCI_ATTR_APPCTX_LIST = 274; // count of context to be init
OCI_ATTR_APPCTX_NAME = 275; // name of context to be init
OCI_ATTR_APPCTX_ATTR = 276; // attr of context to be init
OCI_ATTR_APPCTX_VALUE = 277; // value of context to be init
// for client id propagation
OCI_ATTR_CLIENT_IDENTIFIER = 278; // value of client id to set
// for inheritance - part 2
OCI_ATTR_IS_FINAL_TYPE = 279; // is final type ?
OCI_ATTR_IS_INSTANTIABLE_TYPE = 280; // is instantiable type ?
OCI_ATTR_IS_FINAL_METHOD = 281; // is final method ?
OCI_ATTR_IS_INSTANTIABLE_METHOD=282; // is instantiable method ?
OCI_ATTR_IS_OVERRIDING_METHOD = 283; // is overriding method ?
// slot 284 available
OCI_ATTR_CHAR_USED = 285; // char length semantics
OCI_ATTR_CHAR_SIZE = 286; // char length
// SQLJ support
OCI_ATTR_IS_JAVA_TYPE = 287; // is java implemented type ?
// N-Tier support
OCI_ATTR_DISTINGUISHED_NAME = 300; // use DN as user name
OCI_ATTR_KERBEROS_TICKET = 301; // Kerberos ticket as cred.
// for multilanguage debugging
OCI_ATTR_ORA_DEBUG_JDWP = 302; // ORA_DEBUG_JDWP attribute
OCI_ATTR_RESERVED_14 = 303; // reserved
// -------- client side character and national character set ids -----------
OCI_ATTR_ENV_CHARSET_ID = OCI_ATTR_CHARSET_ID; // charset id in env
OCI_ATTR_ENV_NCHARSET_ID = OCI_ATTR_NCHARSET_ID; // ncharset id in env
// ocicpw Modes
OCI_AUTH = $08; // Change the password but donot login
// Other Constants
OCI_MAX_FNS = 100; // max number of OCI Functions
OCI_SQLSTATE_SIZE = 5;
OCI_ERROR_MAXMSG_SIZE = 1024;
OCI_LOBMAXSIZE = MINUB4MAXVAL;
OCI_ROWID_LEN = 23;
// Fail Over Events
OCI_FO_END = $00000001;
OCI_FO_ABORT = $00000002;
OCI_FO_REAUTH = $00000004;
OCI_FO_BEGIN = $00000008;
// Fail Over Types
OCI_FO_NONE = $00000001;
OCI_FO_SESSION = $00000002;
OCI_FO_SELECT = $00000004;
OCI_FO_TXNAL = $00000008;
// Function Codes
OCI_FNCODE_INITIALIZE = 1;
OCI_FNCODE_HANDLEALLOC = 2;
OCI_FNCODE_HANDLEFREE = 3;
OCI_FNCODE_DESCRIPTORALLOC = 4;
OCI_FNCODE_DESCRIPTORFREE = 5;
OCI_FNCODE_ENVINIT = 6;
OCI_FNCODE_SERVERATTACH = 7;
OCI_FNCODE_SERVERDETACH = 8;
// unused 9
OCI_FNCODE_SESSIONBEGIN = 10;
OCI_FNCODE_SESSIONEND = 11;
OCI_FNCODE_PASSWORDCHANGE = 12;
OCI_FNCODE_STMTPREPARE = 13;
OCI_FNCODE_STMTBINDBYPOS = 14;
OCI_FNCODE_STMTBINDBYNAME = 15;
// unused 16
OCI_FNCODE_BINDDYNAMIC = 17;
OCI_FNCODE_BINDOBJECT = 18;
OCI_FNCODE_BINDARRAYOFSTRUCT = 20;
OCI_FNCODE_STMTEXECUTE = 21;
// unused 22, 23
OCI_FNCODE_DEFINE = 24;
OCI_FNCODE_DEFINEOBJECT = 25;
OCI_FNCODE_DEFINEDYNAMIC = 26;
OCI_FNCODE_DEFINEARRAYOFSTRUCT= 27;
OCI_FNCODE_STMTFETCH = 28;
OCI_FNCODE_STMTGETBIND = 29;
// 30, 31 unused
OCI_FNCODE_DESCRIBEANY = 32;
OCI_FNCODE_TRANSSTART = 33;
OCI_FNCODE_TRANSDETACH = 34;
OCI_FNCODE_TRANSCOMMIT = 35;
// 36 unused
OCI_FNCODE_ERRORGET = 37;
OCI_FNCODE_LOBOPENFILE = 38;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -