sdora.pas

SQLDirect Component Library is a light-weight Borland Database Engine replacement for Borland Delphi

//--------------------------------LOB types ---------------------------------
  OCI_TEMP_BLOB	= 1;                	// LOB type - BLOB
  OCI_TEMP_CLOB	= 2;                	// LOB type - CLOB
//---------------------------------------------------------------------------

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

//============================Attribute 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 (or OCI_ATTR_PDFMT in v.8) 
  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;
  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
  OCI_ATTR_ATTEMPTS             = 59;	// # of attempts
  OCI_ATTR_RECIPIENT_LIST       = 60;	// recipient list
  OCI_ATTR_EXCEPTION_QUEUE      = 61;	// exception queue name
  OCI_ATTR_ENQ_TIME             = 62;	// enqueue time (only OCIAttrGet)
  OCI_ATTR_MSG_STATE            = 63;	// message state (only OCIAttrGet) NOTE: 64-66 used below
  OCI_ATTR_AGENT_NAME           = 64;	// agent name
  OCI_ATTR_AGENT_ADDRESS        = 65;	// agent address
  OCI_ATTR_AGENT_PROTOCOL       = 66;	// agent protocol

  OCI_ATTR_SENDER_ID            = 68;	// sender id
  OCI_ATTR_ORIGINAL_MSGID       = 69;	// original message id

  OCI_ATTR_QUEUE_NAME           = 70;	// queue name
  OCI_ATTR_NFY_MSGID            = 71;	// message id
  OCI_ATTR_MSG_PROP             = 72;	// message properties

  OCI_ATTR_NUM_DML_ERRORS       = 73;	// num of errs in array DML
  OCI_ATTR_DML_ROW_OFFSET       = 74;	// row offset in the array

  OCI_ATTR_DATEFORMAT           = 75;	// default date format string
  OCI_ATTR_BUF_ADDR             = 76;	// buffer address
  OCI_ATTR_BUF_SIZE             = 77;	// buffer size
  OCI_ATTR_DIRPATH_MODE         = 78;	// mode of direct path operation
  OCI_ATTR_DIRPATH_NOLOG        = 79;	// nologging option
  OCI_ATTR_DIRPATH_PARALLEL     = 80;	// parallel (temp seg) option
  OCI_ATTR_NUM_ROWS             = 81; 	// number of rows in column array
                            		// NOTE that OCI_ATTR_NUM_COLS is a column array attribute too.
  OCI_ATTR_COL_COUNT            = 82;	// columns of column array processed so far
  OCI_ATTR_STREAM_OFFSET        = 83;	// str off of last row processed
  OCI_ATTR_SHARED_HEAPALLOC     = 84;	// Shared Heap Allocation Size

  OCI_ATTR_SERVER_GROUP         = 85;	// server group name

  OCI_ATTR_MIGSESSION           = 86;	// migratable session attribute

  OCI_ATTR_NOCACHE              = 87;	// Temporary LOBs

  OCI_ATTR_MEMPOOL_SIZE         = 88;	// Pool Size
  OCI_ATTR_MEMPOOL_INSTNAME     = 89;	// Instance name
  OCI_ATTR_MEMPOOL_APPNAME      = 90;	// Application name
  OCI_ATTR_MEMPOOL_HOMENAME     = 91;	// Home Directory name
  OCI_ATTR_MEMPOOL_MODEL        = 92;	// Pool Model (proc,thrd,both)
  OCI_ATTR_MODES                = 93;	// Modes

  OCI_ATTR_SUBSCR_NAME          = 94;	// name of subscription
  OCI_ATTR_SUBSCR_CALLBACK      = 95;	// associated callback
  OCI_ATTR_SUBSCR_CTX           = 96;	// associated callback context
  OCI_ATTR_SUBSCR_PAYLOAD       = 97;	// associated payload
  OCI_ATTR_SUBSCR_NAMESPACE     = 98;	// associated namespace

  OCI_ATTR_PROXY_CREDENTIALS    = 99; 	// Proxy user credentials
  OCI_ATTR_INITIAL_CLIENT_ROLES = 100;	// Initial client role list

//	Parameter Attribute Types
  OCI_ATTR_UNK     		= 101;	// unknown attribute
  OCI_ATTR_NUM_COLS    		= 102;  // number of columns
  OCI_ATTR_LIST_COLUMNS		= 103;  // parameter of the column list
  OCI_ATTR_RDBA    		= 104;  // DBA of the segment header
  OCI_ATTR_CLUSTERED   		= 105;  // whether the table is clustered
  OCI_ATTR_PARTITIONED     	= 106;  // whether the table is partitioned
  OCI_ATTR_INDEX_ONLY      	= 107;  // whether the table is index only
  OCI_ATTR_LIST_ARGUMENTS  	= 108;  // parameter of the argument list
  OCI_ATTR_LIST_SUBPROGRAMS	= 109;  // parameter of the subprogram list
  OCI_ATTR_REF_TDO         	= 110;  // REF to the type descriptor
  OCI_ATTR_LINK            	= 111;  // the database link name
  OCI_ATTR_MIN             	= 112;  // minimum value
  OCI_ATTR_MAX             	= 113;  // maximum value
  OCI_ATTR_INCR            	= 114;  // increment value
  OCI_ATTR_CACHE           	= 115;  // number of sequence numbers cached
  OCI_ATTR_ORDER           	= 116;  // whether the sequence is ordered
  OCI_ATTR_HW_MARK         	= 117;  // high-water mark
  OCI_ATTR_TYPE_SCHEMA     	= 118;  // type's schema name
  OCI_ATTR_TIMESTAMP       	= 119;  // timestamp of the object
  OCI_ATTR_NUM_ATTRS       	= 120;  // number of sttributes
  OCI_ATTR_NUM_PARAMS      	= 121;  // number of parameters
  OCI_ATTR_OBJID           	= 122;  // object id for a table or view
  OCI_ATTR_PTYPE           	= 123;  // type of info described by
  OCI_ATTR_PARAM           	= 124;  // parameter descriptor
  OCI_ATTR_OVERLOAD_ID     	= 125;  // overload ID for funcs and procs
  OCI_ATTR_TABLESPACE      	= 126;  // table name space
  OCI_ATTR_TDO                 	= 127;  // TDO of a type
  OCI_ATTR_LTYPE               	= 128;  // list type
  OCI_ATTR_PARSE_ERROR_OFFSET	= 129;  // Parse Error offset
  OCI_ATTR_IS_TEMPORARY     	= 130;  // whether table is temporary
  OCI_ATTR_IS_TYPED        	= 131;  // whether table is typed
  OCI_ATTR_DURATION        	= 132;  // duration of temporary table
  OCI_ATTR_IS_INVOKER_RIGHTS	= 133;  // is invoker rights
  OCI_ATTR_OBJ_NAME       	= 134;	// top level schema obj name
  OCI_ATTR_OBJ_SCHEMA     	= 135;  // schema name
  OCI_ATTR_OBJ_ID         	= 136;  // top level schema object id

  OCI_ATTR_DIRPATH_SORTED_INDEX	= 137; 	// index that data is sorted on

     { direct path index maint method (see oci8dp.h) }
  OCI_ATTR_DIRPATH_INDEX_MAINT_METHOD 	= 138;

    { parallel load: db file, initial and next extent sizes }
  OCI_ATTR_DIRPATH_FILE    		= 139;	// DB file to load into
  OCI_ATTR_DIRPATH_STORAGE_INITIAL 	= 140;	// initial extent size
  OCI_ATTR_DIRPATH_STORAGE_NEXT		= 141;	// next extent size

  OCI_ATTR_TRANS_TIMEOUT	= 142;	// transaction timeout
  OCI_ATTR_SERVER_STATUS	= 143; 	// state of the server handle
  OCI_ATTR_STATEMENT  		= 144; 	// statement txt in stmt hdl, statement should not be executed in cache

  OCI_ATTR_NO_CACHE         	= 145;
  OCI_ATTR_DEQCOND          	= 146;	// dequeue condition
  OCI_ATTR_RESERVED_2       	= 147;	// reserved

  OCI_ATTR_SUBSCR_RECPT     	= 148;	// recepient of subscription
  OCI_ATTR_SUBSCR_RECPTPROTO	= 149;	// protocol for recepient

	// 8.2 dpapi support of ADTs
  OCI_ATTR_DIRPATH_EXPR_TYPE 	= 150;	// expr type of OCI_ATTR_NAME

  OCI_ATTR_DIRPATH_INPUT     	= 151;	// input in text or stream format

  OCI_DIRPATH_INPUT_TEXT    	= $01;
  OCI_DIRPATH_INPUT_STREAM  	= $02;
  OCI_DIRPATH_INPUT_UNKNOWN 	= $04;

  OCI_ATTR_LDAP_HOST      	= 153;	// LDAP host to connect to
  OCI_ATTR_LDAP_PORT      	= 154;	// LDAP port to connect to
  OCI_ATTR_BIND_DN        	= 155;	// bind DN
  OCI_ATTR_LDAP_CRED      	= 156;	// credentials to connect to LDAP
  OCI_ATTR_WALL_LOC       	= 157;	// client wallet location
  OCI_ATTR_LDAP_AUTH      	= 158;	// LDAP authentication method
  OCI_ATTR_LDAP_CTX       	= 159;	// LDAP adminstration context DN
  OCI_ATTR_SERVER_DNS     	= 160;	// list of registration server DNs

  OCI_ATTR_DN_COUNT       	= 161;	// the number of server DNs
  OCI_ATTR_SERVER_DN      	= 162;	// server DN attribute

  OCI_ATTR_MAXCHAR_SIZE   	= 163;	// max char size of data

  OCI_ATTR_CURRENT_POSITION  	= 164;	// for scrollable result sets

// Added to get attributes for ref cursor to statement handle
  OCI_ATTR_RESERVED_3       	= 165;	// reserved
  OCI_ATTR_RESERVED_4       	= 166;	// reserved
  OCI_ATTR_DIRPATH_FN_CTX   	= 167;	// fn ctx ADT attrs or args
  OCI_ATTR_DIGEST_ALGO      	= 168;	// digest algorithm
  OCI_ATTR_CERTIFICATE      	= 169;	// certificate
  OCI_ATTR_SIGNATURE_ALGO   	= 170;	// signature algorithm
  OCI_ATTR_CANONICAL_ALGO   	= 171;	// canonicalization algo.
  OCI_ATTR_PRIVATE_KEY      	= 172;	// private key
  OCI_ATTR_DIGEST_VALUE     	= 173;	// digest value
  OCI_ATTR_SIGNATURE_VAL    	= 174;	// signature value
  OCI_ATTR_SIGNATURE        	= 175;	// signature

// attributes for setting OCI stmt caching specifics in svchp
  OCI_ATTR_STMTCACHESIZE    	= 176;	// size of the stm cache

// --------------------------- Connection Pool Attributes ------------------
  OCI_ATTR_CONN_NOWAIT      	= 178;
  OCI_ATTR_CONN_BUSY_COUNT  	= 179;
  OCI_ATTR_CONN_OPEN_COUNT  	= 180;
  OCI_ATTR_CONN_TIMEOUT     	= 181;
  OCI_ATTR_STMT_STATE       	= 182;
  OCI_ATTR_CONN_MIN         	= 183;
  OCI_ATTR_CONN_MAX         	= 184;
  OCI_ATTR_CONN_INCR        	= 185;

  OCI_ATTR_DIRPATH_OID      	= 187;	// loading into an OID col

  OCI_ATTR_NUM_OPEN_STMTS   	= 188;	// open stmts in session
  OCI_ATTR_DESCRIBE_NATIVE  	= 189;	// get native info via desc

  OCI_ATTR_BIND_COUNT       	= 190;	// number of bind postions
  OCI_ATTR_HANDLE_POSITION  	= 191;	// pos of bind/define handle
  OCI_ATTR_RESERVED_5       	= 192;	// reserverd
  OCI_ATTR_SERVER_BUSY      	= 193;	// call in progress on server

  OCI_ATTR_DIRPATH_SID      	= 194;	// loading into an SID col
// notification presentation for recipient
  OCI_ATTR_SUBSCR_RECPTPRES 	= 195;
  OCI_ATTR_TRANSFORMATION   	= 196;	// AQ message transformation

  OCI_ATTR_ROWS_FETCHED     	= 197;	// rows fetched in last call

// --------------------------- Snapshot attributes -------------------------
  OCI_ATTR_SCN_BASE        	= 198;	// snapshot base
  OCI_ATTR_SCN_WRAP        	= 199;	// snapshot wrap

// --------------------------- Miscellanous attributes ---------------------
  OCI_ATTR_RESERVED_6       	= 200;	// reserved
  OCI_ATTR_READONLY_TXN     	= 201;	// txn is readonly
  OCI_ATTR_RESERVED_7       	= 202;	// reserved
  OCI_ATTR_ERRONEOUS_COLUMN 	= 203;	// position of erroneous col
  OCI_ATTR_RESERVED_8       	= 204;	// reserved

// -------------------- 8.2 dpapi support of ADTs continued ----------------
  OCI_ATTR_DIRPATH_OBJ_CONSTR 	= 206;	// obj type of subst obj tbl

//************************FREE attribute     207      *************************/
//************************FREE attribute     208      *************************/
  OCI_ATTR_ENV_UTF16         	= 209;	// is env in utf16 mode?
  OCI_ATTR_RESERVED_9        	= 210;	// reserved for TMZ
  OCI_ATTR_RESERVED_10       	= 211;	// reserved

// Attr to allow setting of the stream version PRIOR to calling Prepare
  OCI_ATTR_DIRPATH_STREAM_VERSION	= 212;	// version of the stream
  OCI_ATTR_RESERVED_11           	= 213;	// reserved

  OCI_ATTR_RESERVED_12     	= 214;	// reserved
  OCI_ATTR_RESERVED_13     	= 215;	// reserved

//------------- Supported Values for Direct Path Stream Version -------------
  OCI_DIRPATH_STREAM_VERSION_1	= 100;
  OCI_DIRPATH_STREAM_VERSION_2	= 200;

//------------- Supported Values for protocol for recepient -----------------
  OCI_SUBSCR_PROTO_OCI    	= 0;    // oci
  OCI_SUBSCR_PROTO_MAIL   	= 1;    // mail
  OCI_SUBSCR_PROTO_SERVER 	= 2;    // server
  OCI_SUBSCR_PROTO_HTTP   	= 3;    // http
  OCI_SUBSCR_PROTO_MAX    	= 4;	// max current protocols

//------------- Supported Values for presentation for recepient -------------
  OCI_SUBSCR_PRES_DEFAULT	= 0;    // default
  OCI_SUBSCR_PRES_XML    	= 1;    // xml
  OCI_SUBSCR_PRES_MAX    	= 2;	// max current presentations

// ----- Temporary attribute value for UCS2/UTF16 character set ID --------
  OCI_UCS2ID			= 1000;	// UCS2 charset ID
  OCI_UTF16ID          		= 1000;	// UTF16 charset ID

{============================== End OCI Attribute Types ====================}

{---------------- Server Handle Attribute Values ---------------------------}

	// OCI_ATTR_SERVER_STATUS
  OCI_SERVER_NOT_CONNECTED	= $00;
  OCI_SERVER_NORMAL      	= $01;

{---------------------------------------------------------------------------}

{------------------------- Supported Namespaces  ---------------------------}
  OCI_SUBSCR_NAMESPACE_ANONYMOUS= 0;	// Anonymous Namespace 
  OCI_SUBSCR_NAMESPACE_AQ  	= 1;	// Advanced Queues
  OCI_SUBSCR_NAMESPACE_MAX   	= 2;	// Max Name Space Number


//	Credential Types
  OCI_CRED_RDBMS 	= 1;		// database username/password
  OCI_CRED_EXT     	= 2;		// externally provided credentials