oradefines.pas

delphi通过OCI访问ORACLE

unit OraDefines;

interface

const
{***************** Plain API constants definition ****************}

 { Generic Default Value for Modes, .... }
 OCI_DEFAULT = 0;  // the default value for parameters and attributes

 { OCIInitialize Modes / OCICreateEnvironment Modes }
 OCI_THREADED  = $01;      // the application is in threaded environment
 OCI_OBJECT    = $02;      // the application is in object environment
 OCI_EVENTS    = $04;      // the application is enabled for events
 OCI_RESERVED1 = $08;      // Reserved for internal use
 OCI_SHARED    = $10;      // the application is in shared mode
 OCI_RESERVED2 = $20;      // Reserved for internal use

(* The following *TWO* are only valid for OCICreateEnvironment call *)
 OCI_NO_UCB    = $40;      // No user callback called during init
 OCI_NO_MUTEX  = $80;      // the environment handle will not be
                           //  protected by a mutex internally
 OCI_SHARED_EXT = $100;    // Used for shared forms
 OCI_CACHE      = $200;    // used by iCache
 OCI_NO_CACHE   = $400;    // turn off iCache mode, used by iCache

 { Bind and Define Options }
 OCI_SB2_IND_PTR      = $01;     // unused
 OCI_DATA_AT_EXEC     = $02;     // data at execute time
 OCI_DYNAMIC_FETCH    = $02;     // fetch dynamically
 OCI_PIECEWISE        = $04;     // piecewise DMLs or fetch
 OCI_DEFINE_RESERVED_1= $08;     // reserved for internal use
 OCI_BIND_RESERVED_2  = $10;     // reserved for internal use
 OCI_DEFINE_RESERVED_2= $20;     // reserved for internal use

 { Attributes common to Columns and Stored Procs }
 OCI_ATTR_DATA_SIZE    = 1;      // maximum size of the data
 OCI_ATTR_DATA_TYPE    = 2;      // the SQL type of the column/argument
 OCI_ATTR_DISP_SIZE    = 3;      // the display size
 OCI_ATTR_NAME         = 4;      // the name of the column/argument
 OCI_ATTR_PRECISION    = 5;      // precision if number type
 OCI_ATTR_SCALE        = 6;      // scale if number type
 OCI_ATTR_IS_NULL      = 7;      // is it null ?
 OCI_ATTR_TYPE_NAME    = 8;

 { Piece Definitions }
 OCI_ONE_PIECE   = 0;  // one piece
 OCI_FIRST_PIECE = 1;  // the first piece
 OCI_NEXT_PIECE  = 2;  // the next of many pieces
 OCI_LAST_PIECE  = 3;  // the last piece

 OCI_V7_SYNTAX=2;   // V815 language - for backwards compatibility
 OCI_V8_SYNTAX=3;   // V815 language - for backwards compatibility
 OCI_NTV_SYNTAX=1;  // Use what so ever is the native lang of server

 { Execution Modes }
 OCI_BATCH_MODE        = $01;         // batch the oci statement for execution
 OCI_EXACT_FETCH       = $02;         // fetch the exact rows specified
 OCI_KEEP_FETCH_STATE  = $04;         // unused
 OCI_SCROLLABLE_CURSOR = $08;         // cursor scrollable
 OCI_DESCRIBE_ONLY     = $10;         // only describe the statement
 OCI_COMMIT_ON_SUCCESS = $20;         // commit, if successful execution
 OCI_NON_BLOCKING      = $40;         // non-blocking
 OCI_BATCH_ERRORS      = $80;         // batch errors in array dmls
 OCI_PARSE_ONLY        = $100;        // only parse the statement
 OCI_EXACT_FETCH_RESERVED_1 = $200;   // reserved for internal use
 OCI_SHOW_DML_WARNINGS = $400;

 { Object Ptr Types }
 OCI_OTYPE_NAME = 1;     // object name
 OCI_OTYPE_REF  = 2;     // REF to TDO
 OCI_OTYPE_PTR  = 3;     // PTR to TDO

 { OCI Parameter Types }
 OCI_PTYPE_UNK         = 0;    // unknown
 OCI_PTYPE_TABLE       = 1;    // table
 OCI_PTYPE_VIEW        = 2;    // view
 OCI_PTYPE_PROC        = 3;    // procedure
 OCI_PTYPE_FUNC        = 4;    // function
 OCI_PTYPE_PKG         = 5;    // package
 OCI_PTYPE_TYPE        = 6;    // user-defined type
 OCI_PTYPE_SYN         = 7;    // synonym
 OCI_PTYPE_SEQ         = 8;    // sequence
 OCI_PTYPE_COL         = 9;    // column
 OCI_PTYPE_ARG         = 10;   // argument
 OCI_PTYPE_LIST        = 11;   // list
 OCI_PTYPE_TYPE_ATTR   = 12;   // user-defined type's attribute
 OCI_PTYPE_TYPE_COLL   = 13;   // collection type's element
 OCI_PTYPE_TYPE_METHOD = 14;   // user-defined type's method
 OCI_PTYPE_TYPE_ARG    = 15;   // user-defined type method's argument
 OCI_PTYPE_TYPE_RESULT = 16;   // user-defined type method's result
 OCI_PTYPE_SCHEMA      = 17;   // schema
 OCI_PTYPE_DATABASE    = 18;   // database

 { OCI Handle Types }
 OCI_HTYPE_FIRST                = 1;    // start value of handle type
 OCI_HTYPE_ENV                  = 1;    // environment handle
 OCI_HTYPE_ERROR                = 2;    // error handle
 OCI_HTYPE_SVCCTX               = 3;    // service handle
 OCI_HTYPE_STMT                 = 4;    // statement handle
 OCI_HTYPE_BIND                 = 5;    // bind handle
 OCI_HTYPE_DEFINE               = 6;    // define handle
 OCI_HTYPE_DESCRIBE             = 7;    // describe handle
 OCI_HTYPE_SERVER               = 8;    // server handle
 OCI_HTYPE_SESSION              = 9;    // authentication handle
 OCI_HTYPE_TRANS                = 10;   // transaction handle
 OCI_HTYPE_COMPLEXOBJECT        = 11;   // complex object retrieval handle
 OCI_HTYPE_SECURITY             = 12;   // security handle
 OCI_HTYPE_SUBSCRIPTION         = 13;   // subscription handle
 OCI_HTYPE_DIRPATH_CTX          = 14;   // direct path context
 OCI_HTYPE_DIRPATH_COLUMN_ARRAY = 15;   // direct path column array
 OCI_HTYPE_DIRPATH_STREAM       = 16;   // direct path stream
 OCI_HTYPE_PROC                 = 17;   // process handle
 OCI_HTYPE_LAST                 = 17;   // last value of a handle type

 { OCI Descriptor Types }
 OCI_DTYPE_FIRST               = 50;     // start value of descriptor type
 OCI_DTYPE_LOB                 = 50;     // lob  locator
 OCI_DTYPE_SNAP                = 51;     // snapshot descriptor
 OCI_DTYPE_RSET                = 52;     // result set descriptor
 OCI_DTYPE_PARAM               = 53;     // a parameter descriptor obtained from ocigparm
 OCI_DTYPE_ROWID               = 54;     // rowid descriptor
 OCI_DTYPE_COMPLEXOBJECTCOMP   = 55;     // complex object retrieval descriptor

 OCI_DTYPE_FILE                = 56;     // File Lob locator
 OCI_DTYPE_AQENQ_OPTIONS       = 57;     // enqueue options
 OCI_DTYPE_AQDEQ_OPTIONS       = 58;     // dequeue options
 OCI_DTYPE_AQMSG_PROPERTIES    = 59;     // message properties
 OCI_DTYPE_AQAGENT             = 60;     // aq agent
 OCI_DTYPE_LOCATOR             = 61;     // LOB locator
 OCI_DTYPE_INTERVAL_YM         = 62;     // Interval year month
 OCI_DTYPE_INTERVAL_DS         = 63;     // Interval day second
// OCI_DTYPE_DATETIME            = 62;
// OCI_DTYPE_INTERVAL            = 63;
 OCI_DTYPE_AQNFY_DESCRIPTOR    = 64;     // user callback descriptor
 OCI_DTYPE_DATE                = 65;     // Date
 OCI_DTYPE_TIME                = 66;     // Time
 OCI_DTYPE_TIME_TZ             = 67;     // Time with timezone
 OCI_DTYPE_TIMESTAMP           = 68;     // Timestamp
 OCI_DTYPE_TIMESTAMP_TZ        = 69;     // Timestamp with timezone
 OCI_DTYPE_TIMESTAMP_LTZ       = 70;     // Timestamp with local tz
 OCI_DTYPE_UCB                 = 71;     // user callback descriptor
 OCI_DTYPE_LAST                = 71;     // last value of a descriptor type

 { OCI Statement Types }
 OCI_STMT_SELECT  = 1;  // select statement
 OCI_STMT_UPDATE  = 2;  // update statement
 OCI_STMT_DELETE  = 3;  // delete statement
 OCI_STMT_INSERT  = 4;  // Insert Statement
 OCI_STMT_CREATE  = 5;  // create statement
 OCI_STMT_DROP    = 6;  // drop statement
 OCI_STMT_ALTER   = 7;  // alter statement
 OCI_STMT_BEGIN   = 8;  // begin ... (pl/sql statement
 OCI_STMT_DECLARE = 9;  // declare .. (pl/sql statement)

  { OCI Attributes Types }
 OCI_ATTR_FNCODE               = 1;   // the OCI function code
 OCI_ATTR_OBJECT               = 2;   // is the environment initialized in object mode
 OCI_ATTR_NONBLOCKING_MODE     = 3;   // non blocking mode
 OCI_ATTR_SQLCODE              = 4;   // the SQL verb
 OCI_ATTR_ENV                  = 5;   // the environment handle
 OCI_ATTR_SERVER               = 6;   // the server handle
 OCI_ATTR_SESSION              = 7;   // the user session handle
 OCI_ATTR_TRANS                = 8;   // the transaction handle
 OCI_ATTR_ROW_COUNT            = 9;   // the rows processed so far
 OCI_ATTR_SQLFNCODE            = 10;  // the SQL verb of the statement
 OCI_ATTR_PREFETCH_ROWS        = 11;  // sets the number of rows to prefetch
 OCI_ATTR_NESTED_PREFETCH_ROWS = 12;  // the prefetch rows of nested table
 OCI_ATTR_PREFETCH_MEMORY      = 13;  // memory limit for rows fetched
 OCI_ATTR_NESTED_PREFETCH_MEMORY = 14;// memory limit for nested rows
 OCI_ATTR_CHAR_COUNT           = 15;  // this specifies the bind and define size in characters
 OCI_ATTR_PDSCL                = 16;  // packed decimal scale
 OCI_ATTR_FSPRECISION          = OCI_ATTR_PDSCL; // fs prec for datetime data types
 OCI_ATTR_PDPRC                = 17;  // packed decimal format
 OCI_ATTR_LFPRECISION          = OCI_ATTR_PDPRC; // fs prec for datetime data types
 OCI_ATTR_PARAM_COUNT          = 18;  // number of column in the select list
 OCI_ATTR_ROWID                = 19;  // the rowid
 OCI_ATTR_CHARSET              = 20;  // the character set value
 OCI_ATTR_NCHAR                = 21;  // NCHAR type
 OCI_ATTR_USERNAME             = 22;  // username attribute
 OCI_ATTR_PASSWORD             = 23;  // password attribute
 OCI_ATTR_STMT_TYPE            = 24;  // statement type
 OCI_ATTR_INTERNAL_NAME        = 25;  // user friendly global name
 OCI_ATTR_EXTERNAL_NAME        = 26;  // the internal name for global txn
 OCI_ATTR_XID                  = 27;  // XOPEN defined global transaction id
 OCI_ATTR_TRANS_LOCK           = 28;  //
 OCI_ATTR_TRANS_NAME           = 29;  // string to identify a global transaction
 OCI_ATTR_HEAPALLOC            = 30;  // memory allocated on the heap
 OCI_ATTR_CHARSET_ID           = 31;  // Character Set ID
 OCI_ATTR_CHARSET_FORM         = 32;  // Character Set Form
 OCI_ATTR_MAXDATA_SIZE         = 33;  // Maximumsize of data on the server
 OCI_ATTR_CACHE_OPT_SIZE       = 34;  // object cache optimal size
 OCI_ATTR_CACHE_MAX_SIZE       = 35;  // object cache maximum size percentage
 OCI_ATTR_PINOPTION            = 36;  // object cache default pin option
 OCI_ATTR_ALLOC_DURATION       = 37;  // object cache default allocation duration
 OCI_ATTR_PIN_DURATION         = 38;  // object cache default pin duration
 OCI_ATTR_FDO                  = 39;  // Format Descriptor object attribute
 OCI_ATTR_POSTPROCESSING_CALLBACK = 40;  // Callback to process outbind data
 OCI_ATTR_POSTPROCESSING_CONTEXT = 41; // Callback context to process outbind data
 OCI_ATTR_ROWS_RETURNED        = 42;  // Number of rows returned in current iter - for Bind handles
 OCI_ATTR_FOCBK                = 43;  // Failover Callback attribute
 OCI_ATTR_IN_V8_MODE           = 44;  // is the server/service context in V8 mode
 OCI_ATTR_LOBEMPTY             = 45;  // empty lob ?
 OCI_ATTR_SESSLANG             = 46;  // session language handle
 OCI_ATTR_VISIBILITY           = 47;  // visibility
 OCI_ATTR_RELATIVE_MSGID       = 48;  // relative message id
 OCI_ATTR_SEQUENCE_DEVIATION   = 49;  // sequence deviation

 OCI_ATTR_CONSUMER_NAME        = 50;  // consumer name
 OCI_ATTR_DEQ_MODE             = 51;  // dequeue mode
 OCI_ATTR_NAVIGATION           = 52;  // navigation
 OCI_ATTR_WAIT                 = 53;  // wait
 OCI_ATTR_DEQ_MSGID            = 54;  // dequeue message id

 OCI_ATTR_PRIORITY             = 55;  // priority
 OCI_ATTR_DELAY                = 56;  // delay
 OCI_ATTR_EXPIRATION           = 57;  // expiration
 OCI_ATTR_CORRELATION          = 58;  // correlation id