/* * $Header: /home/cvsroot/parser3project/win32/sql/oracle/include/oci/oci.h,v 1.1.1.1 2001/09/21 15:47:33 parser Exp $ */ /* Copyright (c) Oracle Corporation 1995, 1996, 1997, 1998, 1999. All Rights Reserved. */ /* NAME oci.h - V8 Oracle Call Interface public definitions DESCRIPTION This file defines all the constants and structures required by a V8 OCI programmer. RELATED DOCUMENTS V8 OCI Functional Specification V8 OCI Design Specification Oracle Call Interface Programmer's Guide Vol 1 and 2 INSPECTION STATUS Inspection date: Inspection status: Estimated increasing cost defects per page: Rule sets: ACCEPTANCE REVIEW STATUS Review date: Review status: Reviewers: PUBLIC FUNCTION(S) None PRIVATE FUNCTION(S) None EXAMPLES NOTES MODIFIED (MM/DD/YY) porangas 09/21/99 - Correct lines to 80 characters wide: 974710 slari 08/23/99 - add OCI_DTYPE_UCB slari 08/20/99 - add OCI_UCBTYPE_REPLACE sgollapu 08/02/99 - oci sql routing slari 08/06/99 - rename values for OCI_SERVER_STATUS slari 08/02/99 - add OCI_ATTR_SERVER_STATUS tnbui 07/28/99 - Remove OCI_DTYPE_TIMESTAMP_ITZ amangal 07/19/99 - Merge into 8.1.6 : bug 785797 tnbui 07/07/99 - Change ADJUSTMENT modes dsaha 07/07/99 - OCI_SAHRED_EXT dmwong 06/08/99 - add OCI_ATTR_APPCTX_* vyanaman 06/23/99 - vyanaman 06/21/99 - Add new OCI Datetime and Interval descriptors esoyleme 06/29/99 - expose MTS performance enhancements rshaikh 04/23/99 - add OCI_SQL_VERSION_* tnbui 05/24/99 - Remove OCIAdjStr dsaha 05/21/99 - Add OCI_ADJUST_UNK mluong 05/17/99 - fix merge tnbui 04/05/99 - ADJUSTMENT values abrumm 04/16/99 - dpapi: more attributes dsaha 02/24/99 - Add OCI_SHOW_DML_WARNINGS jiyang 12/07/98 - Add OCI_NLS_DUAL_CURRENCY slari 12/07/98 - change OCI_NOMUTEX to OCI_NO_MUTEX aroy 11/30/98 - change OCI_NOCALLBACK to OCI_NO_UCB aroy 11/13/98 - add env modes to process modes slari 09/08/98 - add OCI_FNCODE_SVC2HST and _SVCRH aroy 09/04/98 - Add OCI_ATTR_MIGSESSION skray 08/14/98 - server groups for session switching mluong 08/11/98 - add back OCI_HTYPE_LAST. aroy 05/25/98 - add process handle type aroy 04/06/98 - add shared mode slari 07/13/98 - merge forward to 8.1.4 slari 07/09/98 - add OCI_BIND_RESERVED_2 slari 07/08/98 - add OCI_EXACT_FETCH_RESERVED_1 dsaha 07/07/98 - Add OCI_PARSE_ONLY dsaha 06/29/98 - Add OCI_PARSE_ONLY slari 07/01/98 - add OCI_BIND_RESERVED_2 sgollapu 06/25/98 - Fix bug 683565 slari 06/17/98 - remove OC_FETCH_RESERVED_2 slari 06/11/98 - add OCI_FETCH_RESERVED_1 and 2 jhasenbe 05/27/98 - Remove definitions for U-Calls (Unicode) jiyang 05/18/98 - remove OCI_ATTR_CARTLANG nbhatt 05/20/98 - OCI_DEQ_REMOVE_NODATA nbhatt 05/19/98 - correct AQ opcode skmishra 05/06/98 - Add precision attribute to Attributes list aroy 04/20/98 - merge forward 8.0.5 -> 8.1.3 schandra 05/01/98 - OCI sender id sgollapu 02/19/98 - enhanced array DML nbhatt 05/15/98 - AQ listen call sgollapu 04/27/98 - more attributes skaluska 04/06/98 - Add OCI_PTYPE_SCHEMA, OCI_PTYPE_DATABASE slari 04/28/98 - add OCI_ATTR_PDPRC lchidamb 05/05/98 - change OCI_NAMESPACE_AQ to 1 nbhatt 04/27/98 - AQ Notification Descriptor abrumm 06/24/98 - more direct path attributes abrumm 05/27/98 - OCI direct path interface support abrumm 05/08/98 - OCI direct path interface support lchidamb 03/02/98 - client notification additions kkarun 04/17/98 - Add more Interval functions vyanaman 04/16/98 - Add get/set TZ kkarun 04/14/98 - Add OCI Datetime shortnames vyanaman 04/13/98 - Add OCI DateTime and Interval check error codes kkarun 04/07/98 - Add OCI_DTYPE_DATETIME and OCI_DTYPE_INTERVAL esoyleme 12/15/97 - support failover callback retry esoyleme 04/22/98 - merge support for failover callback retry mluong 04/16/98 - add OCI_FNCODE_LOBLOCATORASSIGN rkasamse 04/17/98 - add short names for OCIPickler(Memory/Ctx) cart servi slari 04/10/98 - add OCI_FNCODE_SVCCTXTOLDA slari 04/09/98 - add OCI_FNCODE_RESET slari 04/07/98 - add OCI_FNCODE_LOBFILEISOPEN slari 04/06/98 - add OCI_FNCODE_LOBOPEN slari 03/20/98 - change OCI_CBTYPE_xxx to OCI_UCBTYPE_xxx slari 03/18/98 - add OCI_FNCODE_MAXFCN slari 02/12/98 - add OCI_ENV_NO_USRCB skabraha 04/09/98 - adding shortnames for OCIFile rhwu 04/03/98 - Add short names for the OCIThread package tanguyen 04/03/98 - add OCI_ATTR_xxxx for type inheritance rkasamse 04/02/98 - add OCI_ATTR_UCI_REFRESH nramakri 04/01/98 - Add short names for the OCIExtract package ewaugh 03/31/98 - Add short names for the OCIFormat package. jhasenbe 04/06/98 - Add definitions for U-Calls (Unicode) (OCI_TEXT, OCI_UTEXT, OCI_UTEXT4) skmishra 03/03/98 - Add OCI_ATTR_PARSE_ERROR_OFFSET rwessman 03/11/98 - Added OCI_CRED_PROXY for proxy authentication abrumm 03/31/98 - OCI direct path interface support nmallava 03/03/98 - add constants for temp lob apis skotsovo 03/05/98 - resolve merge conflicts skotsovo 02/24/98 - add OCI_DTYPE_LOC skaluska 01/21/98 - Add OCI_ATTR_LTYPE rkasamse 01/06/98 - add OCI_ATTR* for obj cache enhancements dchatter 01/08/98 - more comments skabraha 12/02/97 - moved oci1.h to the front of include files. jiyang 12/18/97 - Add OCI_NLS_MAX_BUFSZ rhwu 12/02/97 - move oci1.h up ewaugh 12/15/97 - Add short names for the OCIFormat package. rkasamse 12/02/97 - Add a constant for memory cartridge services -- OCI_M nmallava 12/31/97 - open/close for internal lobs khnguyen 11/27/97 - add OCI_ATTR_LFPRECISION, OCI_ATTR_FSPRECISION rkasamse 11/03/97 - add types for pickler cartridge services mluong 11/20/97 - changed ubig_ora to ub4 per skotsovo ssamu 11/14/97 - add oci1.h jiyang 11/13/97 - Add NLS service for cartridge esoyleme 12/15/97 - support failover callback retry jwijaya 10/21/97 - change OCILobOffset/Length from ubig_ora to ub4 cxcheng 07/28/97 - fix compile with SLSHORTNAME schandra 06/25/97 - AQ OCI interface sgollapu 07/25/97 - Add OCI_ATTR_DESC_PUBLIC cxcheng 06/16/97 - add OCI_ATTR_TDO skotsovo 06/05/97 - add fntcodes for lob buffering subsystem esoyleme 05/13/97 - move failover callback prototype skmishra 05/06/97 - stdc compiler fixes skmishra 04/22/97 - Provide C++ compatibility lchidamb 04/19/97 - add OCI_ATTR_SESSLANG ramkrish 04/15/97 - Add OCI_LOB_BUFFER_(NO)FREE sgollapu 04/18/97 - Add OCI_ATTR_TABLESPACE skaluska 04/17/97 - Add OCI_ATTR_SUB_NAME schandra 04/10/97 - Use long OCI names aroy 03/27/97 - add OCI_DTYPE_FILE sgollapu 03/26/97 - Add OCI_OTYPEs skmishra 04/09/97 - Added constant OCI_ROWID_LEN dchatter 03/21/97 - add attr OCI_ATTR_IN_V8_MODE lchidamb 03/21/97 - add OCI_COMMIT_ON_SUCCESS execution mode skmishra 03/20/97 - Added OCI_ATTR_LOBEMPTY sgollapu 03/19/97 - Add OCI_ATTR_OVRLD_ID aroy 03/17/97 - add postprocessing callback sgollapu 03/15/97 - Add OCI_ATTR_PARAM cxcheng 02/07/97 - change OCI_PTYPE codes for type method for consistenc cxcheng 02/05/97 - add OCI_PTYPE_TYPE_RESULT cxcheng 02/04/97 - rename OCI_PTYPE constants to be more consistent cxcheng 02/03/97 - add OCI_ATTR, OCI_PTYPE contants for describe type esoyleme 01/23/97 - merge neerja callback sgollapu 12/30/96 - Remove OCI_DTYPE_SECURITY asurpur 12/26/96 - CHanging OCI_NO_AUTH to OCI_AUTH sgollapu 12/23/96 - Add more attrs to COL, ARG, and SEQ sgollapu 12/12/96 - Add OCI_DESCRIBE_ONLY slari 12/11/96 - change prototype of OCICallbackInBind nbhatt 12/05/96 - "callback" lchidamb 11/19/96 - handle subclassing sgollapu 11/09/96 - OCI_PATTR_* dchatter 11/04/96 - add attr OCI_ATTR_CHRCNT mluong 11/01/96 - test cxcheng 10/31/96 - add #defines for OCILobLength etc dchatter 10/31/96 - add lob read write call back fp defs dchatter 10/30/96 - more changes rhari 10/30/96 - Include ociextp.h at the very end lchidamb 10/22/96 - add fdo attribute for bind/server handle dchatter 10/22/96 - change attr defn for prefetch parameters & lobs/file calls slari 10/21/96 - add OCI_ENV_NO_MUTEX rhari 10/25/96 - Include ociextp.h rxgovind 10/25/96 - add OCI_LOBMAXSIZE, remove OCI_FILE_READWRITE sgollapu 10/24/96 - Correct OCILogon and OCILogoff sgollapu 10/24/96 - Correct to OCILogon and OCILogoff sgollapu 10/21/96 - Add ocilon and ociloff skaluska 10/31/96 - Add OCI_PTYPE values sgollapu 10/17/96 - correct OCI_ATTR_SVCCTX to OCI_ATTR_SERVER rwessman 10/16/96 - Added security functions and fixed olint errors. sthakur 10/14/96 - add more COR attributes cxcheng 10/14/96 - re-enable LOB functions sgollapu 10/10/96 - Add ocibdp and ocibdn slari 10/07/96 - add back OCIRowid aroy 10/08/96 - add typedef ocibfill for PRO*C mluong 10/11/96 - replace OCI_ATTR_CHARSET* with OCI_ATTR_CHARSET_* cxcheng 10/10/96 - temporarily take out #define for lob functions sgollapu 10/02/96 - Rename OCI functions and datatypes skotsovo 10/01/96 - move orl lob fnts to oci aroy 09/10/96 - fix merge errors aroy 08/19/96 - NCHAR support jboonleu 09/05/96 - add OCI attributes for object cache dchatter 08/20/96 - HTYPE ranges from 1-50; DTYPE from 50-255 slari 08/06/96 - define OCI_DTYPE_ROWID sthakur 08/14/96 - complex object support schandra 06/17/96 - Convert XA to use new OCI abrik 08/15/96 - OCI_ATTR_HEAPALLOC added aroy 07/17/96 - terminology change: ocilobd => ocilobl aroy 07/03/96 - add lob typedefs for Pro*C slari 06/28/96 - add OCI_ATTR_STMT_TYPE lchidamb 06/26/96 - reorg #ifndef schandra 05/31/96 - attribute types for internal and external client name asurpur 05/30/96 - Changing the value of mode schandra 05/18/96 - OCI_TRANS_TWOPHASE -> 0x00000001 to 0x00100000 slari 05/30/96 - add callback function prototypes jbellemo 05/23/96 - remove ociisc schandra 04/23/96 - loosely-coupled branches asurpur 05/15/96 - New mode for ocicpw aroy 04/24/96 - making ocihandles opaque slari 04/18/96 - add missing defines schandra 03/27/96 - V8OCI - add transaction related calls dchatter 04/01/96 - add OCI_FILE options dchatter 03/21/96 - add oci2lda conversion routines dchatter 03/07/96 - add OCI piece definition slari 03/12/96 - add describe attributes slari 03/12/96 - add OCI_OTYPE_QUERY aroy 02/28/96 - Add column attributes slari 02/09/96 - add OCI_OBJECT slari 02/07/96 - add OCI_HYTPE_DSC aroy 01/10/96 - adding function code defines... dchatter 01/03/96 - define OCI_NON_BLOCKING dchatter 01/02/96 - Add Any descriptor dchatter 01/02/96 - Add Select List descriptor dchatter 12/29/95 - V8 OCI definitions dchatter 12/29/95 - Creation */ #ifdef __cplusplus extern "C" { #endif #ifndef ORATYPES #include #endif #ifndef OCIDFN #include #endif #ifndef OCI_ORACLE # define OCI_ORACLE /*--------------------------------------------------------------------------- Short names provided for platforms which do not allow extended symbolic names ---------------------------------------------------------------------------*/ #ifdef SLSHORTNAME /* Translation of the long function/type names to short names for IBM only */ /* maybe lint will use this too */ #define OCISessionEnd ocitac #define OCIResultSetToStmt ocirs2sh #define OCISessionBegin ociauth #define OCIServerAttach ociatch #define OCIDescriptorAlloc ocigdesc #define OCIServerDetach ocidtch #define OCIDescriptorFree ocifdesc #define OCIServerVersion ocivers #define OCIDescribeAny ocidsca #define OCIBindDynamic ocibda #define OCIBindByName ocibdn #define OCIBindByPos ocibdp #define OCIErrorGet ocigdr #define OCIBindArrayOfStruct ocibsa #define OCIEnvInit ociinit #define OCIBindObject ocibndt #define OCIHandleAlloc ocighndl #define OCIHandleFree ocifhndl #ifdef NEVER #define OCIStmtBindByPos ocibndp #define OCIStmtBindByName ocibndn #endif #define OCIAttrGet ocigattr #define OCIDefineByPos ocidfne #define OCIAttrSet ocisattr #define OCIDefineDynamic ociddf #define OCILdaToSvcCtx ocild2sv #define OCIDefineArrayOfStruct ocidarr #define OCIInitialize ocipi #define OCIDefineObject ocidndt #define OCIStmtExecute ociexec #define OCILobAppend ocilfap #define OCILobOpenFile ocifopn #define OCILobCloseFile ocifcls #define OCILobLocator ocilobd #define OCILobCopy ocilfcp #define OCILobFileCreate ocifcrt #define OCILobFileDelete ocifdel #define OCILobGetLength ocilfln #define OCILobWrite ocilfwr #define OCILobRead ocilfrd #define OCILobErase ocilfer #define OCILobTrim ocilftr #define OCIStmtFetch ocifch #define OCIStmtGetBindInfo ocigbp #define OCIStmtGetPieceInfo ocigpi #define OCIStmtPrepare ocireq #define OCIStmtSetPieceInfo ocispi #define OCISvcCtxToLda ocisv2ld #define OCITransCommit ocitxcm #define OCITransDetach ocitxdt #define OCITransForget ocitxfgt #define OCITransPrepare ocitxpre #define OCITransRollback ocitxrl #define OCIPasswordChange ocicpw #define OCITransStart ocitxst #define OCITransMultiPrepare ocitxmp #define OCIBreak ocibreak #define OCIParamGet ocigparm #define OCIParamSet ocisparm #define OCISecurityOpenWallet ocizwOpenWallet #define OCISecurityCloseWallet ocizwCloseWallet #define OCISecurityCreateWallet ocizwCreateWallet #define OCISecurityDestroyWallet ocizwDestroyWallet #define OCISecurityStorePersona ocizeStorePersona #define OCISecurityOpenPersona ocizeOpenPersona #define OCISecurityClosePersona ocizeClosePersona #define OCISecurityRemovePersona ocizeRemovePersona #define OCISecurityCreatePersona ocizeCreatePersona #define OCISecuritySetProtection ocizeSetProtection #define OCISecurityGetProtection ocizeGetProtection #define OCISecurityRemoveIdentity ociziRemoveIdentity #define OCISecurityCreateIdentity ociziCreateIdentity #define OCISecurityAbortIdentity ociziAbortIdentity #define OCISecurityFreeIdentity ociziFreeIdentity #define OCISecurityStoreTrustedIdentity ociziStoreTrustedIdentity #define OCISecuritySign ocizSign #define OCISecuritySignExpansion ocizxSignExpansion #define OCISecurityVerify ocizVerify #define OCISecurityValidate ocizValidate #define OCISecuritySignDetached ocizsd_SignDetached #define OCISecuritySignDetExpansion ocizxsd_SignDetachedExpansion #define OCISecurityVerifyDetached ocizved_VerifyDetached #define OCISecurity_PKEncrypt ocizkec_PKEncrypt #define OCISecurityPKEncryptExpansion ocizxkec_PKEncryptExpansion #define OCISecurityPKDecrypt ocizkdc_PKDecrypt #define OCISecurityEncrypt ocizEncrypt #define OCISecurityEncryptExpansion ocizxEncryptExpansion #define OCISecurityDecrypt ocizDecrypt #define OCISecurityEnvelope ocizEnvelope #define OCISecurityDeEnvelope ocizDeEnvelope #define OCISecurityKeyedHash ocizKeyedHash #define OCISecurityKeyedHashExpansion ocizxKeyedHashExpansion #define OCISecurityHash ocizHash #define OCISecurityHashExpansion ocizxHashExpansion #define OCISecuritySeedRandom ocizSeedRandom #define OCISecurityRandomBytes ocizrb_RandomBytes #define OCISecurityRandomNumber ocizrn_RandomNumber #define OCISecurityInitBlock ocizibInitBlock #define OCISecurityReuseBlock ocizrbReuseBlock #define OCISecurityPurgeBlock ocizpbPurgeBlock #define OCISecuritySetBlock ocizsbSetBlock #define OCISecurityGetIdentity ocizgi_GetIdentity #define OCIExtractInit ocixeini #define OCIExtractTerm ocixetrm #define OCIExtractReset ocixerst #define OCIExtractSetNumKeys ocixesnk #define OCIExtractSetKey ocixesk #define OCIExtractFromFile ocixeff #define OCIExtractFromStr ocixefs #define OCIExtractToInt ocixeti #define OCIExtractToBool ocixetb #define OCIExtractToStr ocixets #define OCIExtractToOCINum ocixeton #define OCIExtractToList ocixetl #define OCIExtractFromList ocixefl #define OCIDateTimeGetTime ocidt01_GetTime #define OCIDateTimeGetDate ocidt02_GetDate #define OCIDateTimeGetTimeZoneOffset ocidt03_GetTZ #define OCIDateTimeSysTimeStamp ocidt07_SysTS #define OCIDateTimeAssign ocidt08_Assign #define OCIDateTimeToText ocidt09_ToText #define OCIDateTimeFromText ocidt10_FromText #define OCIDateTimeCompare ocidt11_Compare #define OCIDateTimeCheck ocidt12_Check #define OCIDateTimeConvert ocidt13_Convert #define OCIDateTimeSubtract ocidt14_Subtract #define OCIDateTimeIntervalAdd ocidt15_IntervalAdd #define OCIDateTimeIntervalSub ocidt16_IntervalSub #define OCIIntervalSubtract ociint01_Subtract #define OCIIntervalAdd ociint02_Add #define OCIIntervalMultiply ociint03_Multiply #define OCIIntervalDivide ociint04_Divide #define OCIIntervalCompare ociint05_Compare #define OCIIntervalFromText ociint06_FromText #define OCIIntervalToText ociint07_ToText #define OCIIntervalToNumber ociint08_ToNumber #define OCIIntervalCheck ociint09_Check #define OCIIntervalAssign ociint10_Assign #define OCIIntervalGetYearMonth ociint11_GetYearMonth #define OCIIntervalSetYearMonth ociint12_SetYearMonth #define OCIIntervalGetDaySecond ociint13_GetDaySecond #define OCIIntervalSetDaySecond ociint14_SetDaySecond #define OCIIntervalFromNumber ociint15_FromNumber #define OCIFormatInit ocixs01_Init #define OCIFormatString ocixs02_Format #define OCIFormatTerm ocixs03_Term #define OCIFormatTUb1 ocixs04_TUb1 #define OCIFormatTUb2 ocixs05_TUb2 #define OCIFormatTUb4 ocixs06_TUb4 #define OCIFormatTUword ocixs07_TUword #define OCIFormatTUbig_ora ocixs08_TUbig_ora #define OCIFormatTSb1 ocixs09_TSb1 #define OCIFormatTSb2 ocixs10_TSb2 #define OCIFormatTSb4 ocixs11_TSb4 #define OCIFormatTSword ocixs12_TSword #define OCIFormatTSbig_ora ocixs13_TSbig_ora #define OCIFormatTEb1 ocixs14_TEb1 #define OCIFormatTEb2 ocixs15_TEb2 #define OCIFormatTEb4 ocixs16_TEb4 #define OCIFormatTEword ocixs17_TEword #define OCIFormatTChar ocixs18_TChar #define OCIFormatTText ocixs19_TText #define OCIFormatTDouble ocixs20_TDouble #define OCIFormatTDvoid ocixs21_TDvoid #define OCIFormatTEnd ocixs22_TEnd #define OCIFileInit ocifinit #define OCIFileTerm ocifterm #define OCIFileOpen ocifopen #define OCIFileClose ocifclose #define OCIFileRead ocifread #define OCIFileWrite ocifwrite #define OCIFileSeek ocifseek #define OCIFileExists ocifexists #define OCIFileGetLength ocifglen #define OCIFileFlush ocifflush /* OCIThread short name */ #define OCIThreadProcessInit ocitt01_ProcessInit #define OCIThreadInit ocitt02_Init #define OCIThreadTerm ocitt03_Term #define OCIThreadIsMulti ocitt04_IsMulti #define OCIThreadMutexInit ocitt05_MutexInit #define OCIThreadMutexDestroy ocitt06_MutexDestroy #define OCIThreadMutexAcquire ocitt07_MutexAcquire #define OCIThreadMutexRelease ocitt08_MutexRelease #define OCIThreadKeyInit ocitt09_KeyInit #define OCIThreadKeyDestroy ocitt10_KeyDestroy #define OCIThreadKeyGet ocitt11_KeyGet #define OCIThreadKeySet ocitt12_KeySet #define OCIThreadIdInit ocitt13_IdInit #define OCIThreadIdDestroy ocitt14_IdDestroy #define OCIThreadIdSet ocitt15_IdSet #define OCIThreadIdSetNull ocitt16_IdSetNull #define OCIThreadIdGet ocitt17_IdGet #define OCIThreadIdSame ocitt18_IdSame #define OCIThreadIdNull ocitt19_IdNull #define OCIThreadHndInit ocitt20_HndInit #define OCIThreadHndDestroy ocitt21_HndDestroy #define OCIThreadCreate ocitt22_Create #define OCIThreadJoin ocitt23_Join #define OCIThreadClose ocitt24_Close #define OCIThreadHandleGet ocitt25_HandleGet /* Translation between the old and new datatypes */ #define OCISession ociusrh #define OCIBind ocibndh #define OCIDescribe ocidsch #define OCIDefine ocidfnh #define OCIEnv ocienvh #define OCIError ocierrh #define OCILob ocilobd #define OCILobLength ocillen #define OCILobMode ocilmo #define OCILobOffset ociloff #define OCILobLocator ocilobd #define OCIBlobLocator ociblobl #define OCIClobLocator ociclobl #define OCIBFileLocator ocibfilel #define OCIParam ocipard #define OCIResult ocirstd #define OCISnapshot ocisnad #define OCIServer ocisrvh #define OCIStmt ocistmh #define OCISvcCtx ocisvch #define OCITrans ocitxnh #define OCICallbackInBind ocibicfp #define OCICallbackOutBind ocibocfp #define OCICallbackDefine ocidcfp #define OCICallbackLobRead ocilrfp #define OCICallbackLobWrite ocilwfp #define OCISecurity ociossh #define OCIComplexObject ocicorh #define OCIComplexObjectComp ocicord #define OCIRowid ociridd #endif /* ifdef SLSHORTNAME */ /*--------------------------------------------------------------------------- PUBLIC TYPES AND CONSTANTS ---------------------------------------------------------------------------*/ /*-----------------------------Handle Types----------------------------------*/ /* handle types range from 1 - 49 */ #define OCI_HTYPE_FIRST 1 /* start value of handle type */ #define OCI_HTYPE_ENV 1 /* environment handle */ #define OCI_HTYPE_ERROR 2 /* error handle */ #define OCI_HTYPE_SVCCTX 3 /* service handle */ #define OCI_HTYPE_STMT 4 /* statement handle */ #define OCI_HTYPE_BIND 5 /* bind handle */ #define OCI_HTYPE_DEFINE 6 /* define handle */ #define OCI_HTYPE_DESCRIBE 7 /* describe handle */ #define OCI_HTYPE_SERVER 8 /* server handle */ #define OCI_HTYPE_SESSION 9 /* authentication handle */ #define OCI_HTYPE_TRANS 10 /* transaction handle */ #define OCI_HTYPE_COMPLEXOBJECT 11 /* complex object retrieval handle */ #define OCI_HTYPE_SECURITY 12 /* security handle */ #define OCI_HTYPE_SUBSCRIPTION 13 /* subscription handle */ #define OCI_HTYPE_DIRPATH_CTX 14 /* direct path context */ #define OCI_HTYPE_DIRPATH_COLUMN_ARRAY 15 /* direct path column array */ #define OCI_HTYPE_DIRPATH_STREAM 16 /* direct path stream */ #define OCI_HTYPE_PROC 17 /* process handle */ #define OCI_HTYPE_LAST 17 /* last value of a handle type */ /*---------------------------------------------------------------------------*/ /*-------------------------Descriptor Types----------------------------------*/ /* descriptor values range from 50 - 255 */ #define OCI_DTYPE_FIRST 50 /* start value of descriptor type */ #define OCI_DTYPE_LOB 50 /* lob locator */ #define OCI_DTYPE_SNAP 51 /* snapshot descriptor */ #define OCI_DTYPE_RSET 52 /* result set descriptor */ #define OCI_DTYPE_PARAM 53 /* a parameter descriptor obtained from ocigparm */ #define OCI_DTYPE_ROWID 54 /* rowid descriptor */ #define OCI_DTYPE_COMPLEXOBJECTCOMP 55 /* complex object retrieval descriptor */ #define OCI_DTYPE_FILE 56 /* File Lob locator */ #define OCI_DTYPE_AQENQ_OPTIONS 57 /* enqueue options */ #define OCI_DTYPE_AQDEQ_OPTIONS 58 /* dequeue options */ #define OCI_DTYPE_AQMSG_PROPERTIES 59 /* message properties */ #define OCI_DTYPE_AQAGENT 60 /* aq agent */ #define OCI_DTYPE_LOCATOR 61 /* LOB locator */ #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_LAST 71 /* 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 */ /* ----- Temporary attribute value for UCS2 character set ID -------- */ #define OCI_UCS2ID 1000 /* UCS2 charset ID */ /*============================== End OCI Attribute Types ====================*/ /*---------------- Server Handle Attribute Values ---------------------------*/ /* OCI_ATTR_SERVER_STATUS */ #define OCI_SERVER_NOT_CONNECTED 0x0 #define OCI_SERVER_NORMAL 0x1 /*---------------------------------------------------------------------------*/ /*------------------------- Supported Namespaces ---------------------------*/ #define OCI_SUBSCR_NAMESPACE_ANONYMOUS 0 /* Anonymous Namespace */ #define OCI_SUBSCR_NAMESPACE_AQ 1 /* Advanced Queues */ #define OCI_SUBSCR_NAMESPACE_MAX 2 /* Max Name Space Number */ /*-------------------------Credential Types----------------------------------*/ #define OCI_CRED_RDBMS 1 /* database username/password */ #define OCI_CRED_EXT 2 /* externally provided credentials */ #define OCI_CRED_PROXY 3 /* proxy authentication */ /*---------------------------------------------------------------------------*/ /*------------------------Error Return Values--------------------------------*/ #define OCI_SUCCESS 0 /* maps to SQL_SUCCESS of SAG CLI */ #define OCI_SUCCESS_WITH_INFO 1 /* maps to SQL_SUCCESS_WITH_INFO */ #define OCI_RESERVED_FOR_INT_USE 200 /* reserved for internal use */ #define OCI_NO_DATA 100 /* maps to SQL_NO_DATA */ #define OCI_ERROR -1 /* maps to SQL_ERROR */ #define OCI_INVALID_HANDLE -2 /* maps to SQL_INVALID_HANDLE */ #define OCI_NEED_DATA 99 /* maps to SQL_NEED_DATA */ #define OCI_STILL_EXECUTING -3123 /* OCI would block error */ #define OCI_CONTINUE -24200 /* Continue with the body of the OCI function */ /*---------------------------------------------------------------------------*/ /*------------------DateTime and Interval check Error codes------------------*/ /* DateTime Error Codes used by OCIDateTimeCheck() */ #define OCI_DT_INVALID_DAY 0x1 /* Bad day */ #define OCI_DT_DAY_BELOW_VALID 0x2 /* Bad DAy Low/high bit (1=low)*/ #define OCI_DT_INVALID_MONTH 0x4 /* Bad MOnth */ #define OCI_DT_MONTH_BELOW_VALID 0x8 /* Bad MOnth Low/high bit (1=low) */ #define OCI_DT_INVALID_YEAR 0x10 /* Bad YeaR */ #define OCI_DT_YEAR_BELOW_VALID 0x20 /* Bad YeaR Low/high bit (1=low) */ #define OCI_DT_INVALID_HOUR 0x40 /* Bad HouR */ #define OCI_DT_HOUR_BELOW_VALID 0x80 /* Bad HouR Low/high bit (1=low) */ #define OCI_DT_INVALID_MINUTE 0x100 /* Bad MiNute */ #define OCI_DT_MINUTE_BELOW_VALID 0x200 /*Bad MiNute Low/high bit (1=low) */ #define OCI_DT_INVALID_SECOND 0x400 /* Bad SeCond */ #define OCI_DT_SECOND_BELOW_VALID 0x800 /*bad second Low/high bit (1=low)*/ #define OCI_DT_DAY_MISSING_FROM_1582 0x1000 /* Day is one of those "missing" from 1582 */ #define OCI_DT_YEAR_ZERO 0x2000 /* Year may not equal zero */ #define OCI_DT_INVALID_TIMEZONE 0x4000 /* Bad Timezone */ #define OCI_DT_INVALID_FORMAT 0x8000 /* Bad date format input */ /* Interval Error Codes used by OCIInterCheck() */ #define OCI_INTER_INVALID_DAY 0x1 /* Bad day */ #define OCI_INTER_DAY_BELOW_VALID 0x2 /* Bad DAy Low/high bit (1=low) */ #define OCI_INTER_INVALID_MONTH 0x4 /* Bad MOnth */ #define OCI_INTER_MONTH_BELOW_VALID 0x8 /*Bad MOnth Low/high bit (1=low) */ #define OCI_INTER_INVALID_YEAR 0x10 /* Bad YeaR */ #define OCI_INTER_YEAR_BELOW_VALID 0x20 /*Bad YeaR Low/high bit (1=low) */ #define OCI_INTER_INVALID_HOUR 0x40 /* Bad HouR */ #define OCI_INTER_HOUR_BELOW_VALID 0x80 /*Bad HouR Low/high bit (1=low) */ #define OCI_INTER_INVALID_MINUTE 0x100 /* Bad MiNute */ #define OCI_INTER_MINUTE_BELOW_VALID 0x200 /*Bad MiNute Low/high bit(1=low) */ #define OCI_INTER_INVALID_SECOND 0x400 /* Bad SeCond */ #define OCI_INTER_SECOND_BELOW_VALID 0x800 /*bad second Low/high bit(1=low) */ #define OCI_INTER_INVALID_FRACSEC 0x1000 /* Bad Fractional second */ #define OCI_INTER_FRACSEC_BELOW_VALID 0x2000 /* Bad fractional second Low/High */ /*------------------------Parsing Syntax Types-------------------------------*/ #define OCI_V7_SYNTAX 2 /* V815 language - for backwards compatibility */ #define OCI_V8_SYNTAX 3 /* V815 language - for backwards compatibility */ #define 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 Options--------------------------*/ #define OCI_FETCH_NEXT 0x02 /* next row */ #define OCI_FETCH_FIRST 0x04 /* first row of the result set */ #define OCI_FETCH_LAST 0x08 /* the last row of the result set */ #define OCI_FETCH_PRIOR 0x10 /* the previous row relative to current */ #define OCI_FETCH_ABSOLUTE 0x20 /* absolute offset from first */ #define OCI_FETCH_RELATIVE 0x40 /* offset relative to current */ #define OCI_FETCH_RESERVED_1 0x80 /* reserved for internal use */ /*---------------------------------------------------------------------------*/ /*------------------------Bind and Define Options----------------------------*/ #define OCI_SB2_IND_PTR 0x01 /* unused */ #define OCI_DATA_AT_EXEC 0x02 /* data at execute time */ #define OCI_DYNAMIC_FETCH 0x02 /* fetch dynamically */ #define OCI_PIECEWISE 0x04 /* piecewise DMLs or fetch */ #define OCI_DEFINE_RESERVED_1 0x08 /* reserved for internal use */ #define OCI_BIND_RESERVED_2 0x10 /* reserved for internal use */ #define OCI_DEFINE_RESERVED_2 0x20 /* reserved for internal use */ /*---------------------------------------------------------------------------*/ /*----------------------------- Various Modes ------------------------------*/ #define OCI_DEFAULT 0x00 /* the default value for parameters and attributes */ /*-------------OCIInitialize Modes / OCICreateEnvironment Modes -------------*/ #define OCI_THREADED 0x01 /* the application is in threaded environment */ #define OCI_OBJECT 0x02 /* the application is in object environment */ #define OCI_EVENTS 0x04 /* the application is enabled for events */ #define OCI_RESERVED1 0x08 /* Reserved for internal use */ #define OCI_SHARED 0x10 /* the application is in shared mode */ #define OCI_RESERVED2 0x20 /* Reserved for internal use */ /* The following *TWO* are only valid for OCICreateEnvironment call */ #define OCI_NO_UCB 0x40 /* No user callback called during init */ #define OCI_NO_MUTEX 0x80 /* the environment handle will not be */ /* protected by a mutex internally */ #define OCI_SHARED_EXT 0x100 /* Used for shared forms */ #define OCI_CACHE 0x200 /* used by iCache */ /*---------------------------------------------------------------------------*/ /*----------------------------- OCIEnvInit Modes ----------------------------*/ /* NOTE: NO NEW MODES SHOULD BE ADDED HERE BECAUSE THE RECOMMENDED METHOD * IS TO USE THE NEW OCICreateEnvironment MODES. */ #define OCI_ENV_NO_UCB 0x01 /* A user callback will not be called in OCIEnvInit() */ #define OCI_ENV_NO_MUTEX 0x08 /* the environment handle will not be protected by a mutex internally */ /*---------------------------------------------------------------------------*/ /*------------------------ Parse Modes --------------------------------------*/ #define OCI_NO_SHARING 0x01 /* turn off statement handle sharing */ /* This flag is only valid when process is in sharing mode */ /*---------------------------------------------------------------------------*/ /*----------------------- Execution Modes -----------------------------------*/ #define OCI_BATCH_MODE 0x01 /* batch the oci statement for execution */ #define OCI_EXACT_FETCH 0x02 /* fetch the exact rows specified */ #define OCI_KEEP_FETCH_STATE 0x04 /* unused */ #define OCI_SCROLLABLE_CURSOR 0x08 /* cursor scrollable */ #define OCI_DESCRIBE_ONLY 0x10 /* only describe the statement */ #define OCI_COMMIT_ON_SUCCESS 0x20 /* commit, if successful execution */ #define OCI_NON_BLOCKING 0x40 /* non-blocking */ #define OCI_BATCH_ERRORS 0x80 /* batch errors in array dmls */ #define OCI_PARSE_ONLY 0x100 /* only parse the statement */ #define OCI_EXACT_FETCH_RESERVED_1 0x200 /* reserved for internal use */ #define OCI_SHOW_DML_WARNINGS 0x400 /* return OCI_SUCCESS_WITH_INFO for del/upd with no where clause */ /*---------------------------------------------------------------------------*/ /*------------------------Authentication Modes-------------------------------*/ #define OCI_MIGRATE 0x0001 /* migratable auth context */ #define OCI_SYSDBA 0x0002 /* for SYSDBA authorization */ #define OCI_SYSOPER 0x0004 /* for SYSOPER authorization */ #define OCI_PRELIM_AUTH 0x0008 /* for preliminary authorization */ /*---------------------------------------------------------------------------*/ /*-----------------------------End Various Modes ----------------------------*/ /*------------------------Piece Information----------------------------------*/ #define OCI_PARAM_IN 0x01 /* in parameter */ #define OCI_PARAM_OUT 0x02 /* out parameter */ /*---------------------------------------------------------------------------*/ /*------------------------ Transaction Start Flags --------------------------*/ /* NOTE: OCI_TRANS_JOIN and OCI_TRANS_NOMIGRATE not supported in 8.0.X */ #define OCI_TRANS_NEW 0x00000001 /* starts a new transaction branch */ #define OCI_TRANS_JOIN 0x00000002 /* join an existing transaction */ #define OCI_TRANS_RESUME 0x00000004 /* resume this transaction */ #define OCI_TRANS_STARTMASK 0x000000ff #define OCI_TRANS_READONLY 0x00000100 /* starts a readonly transaction */ #define OCI_TRANS_READWRITE 0x00000200 /* starts a read-write transaction */ #define OCI_TRANS_SERIALIZABLE 0x00000400 /* starts a serializable transaction */ #define OCI_TRANS_ISOLMASK 0x0000ff00 #define OCI_TRANS_LOOSE 0x00010000 /* a loosely coupled branch */ #define OCI_TRANS_TIGHT 0x00020000 /* a tightly coupled branch */ #define OCI_TRANS_TYPEMASK 0x000f0000 #define OCI_TRANS_NOMIGRATE 0x00100000 /* non migratable transaction */ /*---------------------------------------------------------------------------*/ /*------------------------ Transaction End Flags ----------------------------*/ #define OCI_TRANS_TWOPHASE 0x01000000 /* use two phase commit */ /*---------------------------------------------------------------------------*/ /*------------------------- AQ Constants ------------------------------------ * NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE * The following constants must match the PL/SQL dbms_aq constants * NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE */ /* ------------------------- Visibility flags -------------------------------*/ #define OCI_ENQ_IMMEDIATE 1 /* enqueue is an independent transaction */ #define OCI_ENQ_ON_COMMIT 2 /* enqueue is part of current transaction */ /* ----------------------- Dequeue mode flags -------------------------------*/ #define OCI_DEQ_BROWSE 1 /* read message without acquiring a lock */ #define OCI_DEQ_LOCKED 2 /* read and obtain write lock on message */ #define OCI_DEQ_REMOVE 3 /* read the message and delete it */ #define OCI_DEQ_REMOVE_NODATA 4 /* delete message w'o returning payload */ /* ----------------- Dequeue navigation flags -------------------------------*/ #define OCI_DEQ_FIRST_MSG 1 /* get first message at head of queue */ #define OCI_DEQ_NEXT_MSG 3 /* next message that is available */ #define OCI_DEQ_NEXT_TRANSACTION 2 /* get first message of next txn group */ /* --------------------- Message states -------------------------------------*/ #define OCI_MSG_WAITING 1 /* the message delay has not yet completed */ #define OCI_MSG_READY 0 /* the message is ready to be processed */ #define OCI_MSG_PROCESSED 2 /* the message has been processed */ #define OCI_MSG_EXPIRED 3 /* message has moved to exception queue */ /* --------------------- Sequence deviation ---------------------------------*/ #define OCI_ENQ_BEFORE 2 /* enqueue message before another message */ #define OCI_ENQ_TOP 3 /* enqueue message before all messages */ /* ------------------------- Visibility flags -------------------------------*/ #define OCI_DEQ_IMMEDIATE 1 /* dequeue is an independent transaction */ #define OCI_DEQ_ON_COMMIT 2 /* dequeue is part of current transaction */ /* ------------------------ Wait --------------------------------------------*/ #define OCI_DEQ_WAIT_FOREVER -1 /* wait forever if no message available */ #define OCI_DEQ_NO_WAIT 0 /* do not wait if no message is available */ /* ------------------------ Delay -------------------------------------------*/ #define OCI_MSG_NO_DELAY 0 /* message is available immediately */ /* ------------------------- Expiration -------------------------------------*/ #define OCI_MSG_NO_EXPIRATION -1 /* message will never expire */ /* -------------------------- END AQ Constants ----------------------------- */ /* --------------------END DateTime and Interval Constants ------------------*/ /*-----------------------Object Types----------------------------------------*/ /*-----------Object Types **** Not to be Used **** --------------------------*/ /* Deprecated */ #define OCI_OTYPE_UNK 0 #define OCI_OTYPE_TABLE 1 #define OCI_OTYPE_VIEW 2 #define OCI_OTYPE_SYN 3 #define OCI_OTYPE_PROC 4 #define OCI_OTYPE_FUNC 5 #define OCI_OTYPE_PKG 6 #define OCI_OTYPE_STMT 7 /*---------------------------------------------------------------------------*/ /*=======================Describe Handle Parameter Attributes ===============*/ /* These attributes are orthogonal to the other set of attributes defined above. These attrubutes are tobe used only for the desscribe handle */ /*===========================================================================*/ /* Attributes common to Columns and Stored Procs */ #define OCI_ATTR_DATA_SIZE 1 /* maximum size of the data */ #define OCI_ATTR_DATA_TYPE 2 /* the SQL type of the column/argument */ #define OCI_ATTR_DISP_SIZE 3 /* the display size */ #define OCI_ATTR_NAME 4 /* the name of the column/argument */ #define OCI_ATTR_PRECISION 5 /* precision if number type */ #define OCI_ATTR_SCALE 6 /* scale if number type */ #define OCI_ATTR_IS_NULL 7 /* is it null ? */ #define OCI_ATTR_TYPE_NAME 8 /* name of the named data type or a package name for package private types */ #define OCI_ATTR_SCHEMA_NAME 9 /* the schema name */ #define OCI_ATTR_SUB_NAME 10 /* type name if package private type */ #define OCI_ATTR_POSITION 11 /* relative position of col/arg in the list of cols/args */ /* complex object retrieval parameter attributes */ #define OCI_ATTR_COMPLEXOBJECTCOMP_TYPE 50 #define OCI_ATTR_COMPLEXOBJECTCOMP_TYPE_LEVEL 51 #define OCI_ATTR_COMPLEXOBJECT_LEVEL 52 #define OCI_ATTR_COMPLEXOBJECT_COLL_OUTOFLINE 53 /* Only Columns */ #define OCI_ATTR_DISP_NAME 100 /* the display name */ /*Only Stored Procs */ #define OCI_ATTR_OVERLOAD 210 /* is this position overloaded */ #define OCI_ATTR_LEVEL 211 /* level for structured types */ #define OCI_ATTR_HAS_DEFAULT 212 /* has a default value */ #define OCI_ATTR_IOMODE 213 /* in, out inout */ #define OCI_ATTR_RADIX 214 /* returns a radix */ #define OCI_ATTR_NUM_ARGS 215 /* total number of arguments */ /* only named type attributes */ #define OCI_ATTR_TYPECODE 216 /* object or collection */ #define OCI_ATTR_COLLECTION_TYPECODE 217 /* varray or nested table */ #define OCI_ATTR_VERSION 218 /* user assigned version */ #define OCI_ATTR_IS_INCOMPLETE_TYPE 219 /* is this an incomplete type */ #define OCI_ATTR_IS_SYSTEM_TYPE 220 /* a system type */ #define OCI_ATTR_IS_PREDEFINED_TYPE 221 /* a predefined type */ #define OCI_ATTR_IS_TRANSIENT_TYPE 222 /* a transient type */ #define OCI_ATTR_IS_SYSTEM_GENERATED_TYPE 223 /* system generated type */ #define OCI_ATTR_HAS_NESTED_TABLE 224 /* contains nested table attr */ #define OCI_ATTR_HAS_LOB 225 /* has a lob attribute */ #define OCI_ATTR_HAS_FILE 226 /* has a file attribute */ #define OCI_ATTR_COLLECTION_ELEMENT 227 /* has a collection attribute */ #define OCI_ATTR_NUM_TYPE_ATTRS 228 /* number of attribute types */ #define OCI_ATTR_LIST_TYPE_ATTRS 229 /* list of type attributes */ #define OCI_ATTR_NUM_TYPE_METHODS 230 /* number of type methods */ #define OCI_ATTR_LIST_TYPE_METHODS 231 /* list of type methods */ #define OCI_ATTR_MAP_METHOD 232 /* map method of type */ #define OCI_ATTR_ORDER_METHOD 233 /* order method of type */ /* only collection element */ #define OCI_ATTR_NUM_ELEMS 234 /* number of elements */ /* only type methods */ #define OCI_ATTR_ENCAPSULATION 235 /* encapsulation level */ #define OCI_ATTR_IS_SELFISH 236 /* method selfish */ #define OCI_ATTR_IS_VIRTUAL 237 /* virtual */ #define OCI_ATTR_IS_INLINE 238 /* inline */ #define OCI_ATTR_IS_CONSTANT 239 /* constant */ #define OCI_ATTR_HAS_RESULT 240 /* has result */ #define OCI_ATTR_IS_CONSTRUCTOR 241 /* constructor */ #define OCI_ATTR_IS_DESTRUCTOR 242 /* destructor */ #define OCI_ATTR_IS_OPERATOR 243 /* operator */ #define OCI_ATTR_IS_MAP 244 /* a map method */ #define OCI_ATTR_IS_ORDER 245 /* order method */ #define OCI_ATTR_IS_RNDS 246 /* read no data state method */ #define OCI_ATTR_IS_RNPS 247 /* read no process state */ #define OCI_ATTR_IS_WNDS 248 /* write no data state method */ #define OCI_ATTR_IS_WNPS 249 /* write no process state */ #define OCI_ATTR_DESC_PUBLIC 250 /* public object */ /* Object Cache Enhancements : attributes for User Constructed Instances */ #define OCI_ATTR_CACHE_CLIENT_CONTEXT 251 #define OCI_ATTR_UCI_CONSTRUCT 252 #define OCI_ATTR_UCI_DESTRUCT 253 #define OCI_ATTR_UCI_COPY 254 #define OCI_ATTR_UCI_PICKLE 255 #define OCI_ATTR_UCI_UNPICKLE 256 #define OCI_ATTR_UCI_REFRESH 257 /* for type inheritance */ #define OCI_ATTR_IS_SUBTYPE 258 #define OCI_ATTR_SUPERTYPE_SCHEMA_NAME 259 #define OCI_ATTR_SUPERTYPE_NAME 260 /* for schemas */ #define OCI_ATTR_LIST_OBJECTS 261 /* list of objects in schema */ /* for database */ #define OCI_ATTR_NCHARSET_ID 262 /* char set id */ #define OCI_ATTR_LIST_SCHEMAS 263 /* list of schemas */ #define OCI_ATTR_MAX_PROC_LEN 264 /* max procedure length */ #define OCI_ATTR_MAX_COLUMN_LEN 265 /* max column name length */ #define OCI_ATTR_CURSOR_COMMIT_BEHAVIOR 266 /* cursor commit behavior */ #define OCI_ATTR_MAX_CATALOG_NAMELEN 267 /* catalog namelength */ #define OCI_ATTR_CATALOG_LOCATION 268 /* catalog location */ #define OCI_ATTR_SAVEPOINT_SUPPORT 269 /* savepoint support */ #define OCI_ATTR_NOWAIT_SUPPORT 270 /* nowait support */ #define OCI_ATTR_AUTOCOMMIT_DDL 271 /* autocommit DDL */ #define OCI_ATTR_LOCKING_MODE 272 /* locking mode */ /* for externally initialized context */ #define OCI_ATTR_APPCTX_SIZE 273 /* count of context to be init*/ #define OCI_ATTR_APPCTX_LIST 274 /* count of context to be init*/ #define OCI_ATTR_APPCTX_NAME 275 /* name of context to be init*/ #define OCI_ATTR_APPCTX_ATTR 276 /* attr of context to be init*/ #define OCI_ATTR_APPCTX_VALUE 277 /* value of context to be init*/ /*---------------------------End Describe Handle Attributes -----------------*/ /*---------------- Describe Handle Parameter Attribute Values ---------------*/ /* OCI_ATTR_CURSOR_COMMIT_BEHAVIOR */ #define OCI_CURSOR_OPEN 0 #define OCI_CURSOR_CLOSED 1 /* OCI_ATTR_CATALOG_LOCATION */ #define OCI_CL_START 0 #define OCI_CL_END 1 /* OCI_ATTR_SAVEPOINT_SUPPORT */ #define OCI_SP_SUPPORTED 0 #define OCI_SP_UNSUPPORTED 1 /* OCI_ATTR_NOWAIT_SUPPORT */ #define OCI_NW_SUPPORTED 0 #define OCI_NW_UNSUPPORTED 1 /* OCI_ATTR_AUTOCOMMIT_DDL */ #define OCI_AC_DDL 0 #define OCI_NO_AC_DDL 1 /* OCI_ATTR_LOCKING_MODE */ #define OCI_LOCK_IMMEDIATE 0 #define OCI_LOCK_DELAYED 1 /*---------------------------------------------------------------------------*/ /*---------------------------OCIPasswordChange-------------------------------*/ #define OCI_AUTH 0x08 /* Change the password but do not login */ /*------------------------Other Constants------------------------------------*/ #define OCI_MAX_FNS 100 /* max number of OCI Functions */ #define OCI_SQLSTATE_SIZE 5 #define OCI_ERROR_MAXMSG_SIZE 1024 /* max size of an error message */ #define OCI_LOBMAXSIZE MINUB4MAXVAL /* maximum lob data size */ #define OCI_ROWID_LEN 23 /*---------------------------------------------------------------------------*/ /*------------------------ Fail Over Events ---------------------------------*/ #define OCI_FO_END 0x00000001 #define OCI_FO_ABORT 0x00000002 #define OCI_FO_REAUTH 0x00000004 #define OCI_FO_BEGIN 0x00000008 #define OCI_FO_ERROR 0x00000010 /*---------------------------------------------------------------------------*/ /*------------------------ Fail Over Callback Return Codes ------------------*/ #define OCI_FO_RETRY 25410 /*---------------------------------------------------------------------------*/ /*------------------------- Fail Over Types ---------------------------------*/ #define OCI_FO_NONE 0x00000001 #define OCI_FO_SESSION 0x00000002 #define OCI_FO_SELECT 0x00000004 #define OCI_FO_TXNAL 0x00000008 /*---------------------------------------------------------------------------*/ /*-----------------------Function Codes--------------------------------------*/ #define OCI_FNCODE_INITIALIZE 1 /* OCIInitialize */ #define OCI_FNCODE_HANDLEALLOC 2 /* OCIHandleAlloc */ #define OCI_FNCODE_HANDLEFREE 3 /* OCIHandleFree */ #define OCI_FNCODE_DESCRIPTORALLOC 4 /* OCIDescriptorAlloc */ #define OCI_FNCODE_DESCRIPTORFREE 5 /* OCIDescriptorFree */ #define OCI_FNCODE_ENVINIT 6 /* OCIEnvInit */ #define OCI_FNCODE_SERVERATTACH 7 /* OCIServerAttach */ #define OCI_FNCODE_SERVERDETACH 8 /* OCIServerDetach */ /* unused 9 */ #define OCI_FNCODE_SESSIONBEGIN 10 /* OCISessionBegin */ #define OCI_FNCODE_SESSIONEND 11 /* OCISessionEnd */ #define OCI_FNCODE_PASSWORDCHANGE 12 /* OCIPasswordChange */ #define OCI_FNCODE_STMTPREPARE 13 /* OCIStmtPrepare */ /* unused 14- 16 */ #define OCI_FNCODE_BINDDYNAMIC 17 /* OCIBindDynamic */ #define OCI_FNCODE_BINDOBJECT 18 /* OCIBindObject */ /* 19 unused */ #define OCI_FNCODE_BINDARRAYOFSTRUCT 20 /* OCIBindArrayOfStruct */ #define OCI_FNCODE_STMTEXECUTE 21 /* OCIStmtExecute */ /* unused 22-24 */ #define OCI_FNCODE_DEFINEOBJECT 25 /* OCIDefineObject */ #define OCI_FNCODE_DEFINEDYNAMIC 26 /* OCIDefineDynamic */ #define OCI_FNCODE_DEFINEARRAYOFSTRUCT 27 /* OCIDefineArrayOfStruct */ #define OCI_FNCODE_STMTFETCH 28 /* OCIStmtFetch */ #define OCI_FNCODE_STMTGETBIND 29 /* OCIStmtGetBindInfo */ /* 30, 31 unused */ #define OCI_FNCODE_DESCRIBEANY 32 /* OCIDescribeAny */ #define OCI_FNCODE_TRANSSTART 33 /* OCITransStart */ #define OCI_FNCODE_TRANSDETACH 34 /* OCITransDetach */ #define OCI_FNCODE_TRANSCOMMIT 35 /* OCITransCommit */ /* 36 unused */ #define OCI_FNCODE_ERRORGET 37 /* OCIErrorGet */ #define OCI_FNCODE_LOBOPENFILE 38 /* OCILobFileOpen */ #define OCI_FNCODE_LOBCLOSEFILE 39 /* OCILobFileClose */ /* 40 was LOBCREATEFILE, unused */ /* 41 was OCILobFileDelete, unused */ #define OCI_FNCODE_LOBCOPY 42 /* OCILobCopy */ #define OCI_FNCODE_LOBAPPEND 43 /* OCILobAppend */ #define OCI_FNCODE_LOBERASE 44 /* OCILobErase */ #define OCI_FNCODE_LOBLENGTH 45 /* OCILobGetLength */ #define OCI_FNCODE_LOBTRIM 46 /* OCILobTrim */ #define OCI_FNCODE_LOBREAD 47 /* OCILobRead */ #define OCI_FNCODE_LOBWRITE 48 /* OCILobWrite */ /* 49 unused */ #define OCI_FNCODE_SVCCTXBREAK 50 /* OCIBreak */ #define OCI_FNCODE_SERVERVERSION 51 /* OCIServerVersion */ /* unused 52, 53 */ #define OCI_FNCODE_ATTRGET 54 /* OCIAttrGet */ #define OCI_FNCODE_ATTRSET 55 /* OCIAttrSet */ #define OCI_FNCODE_PARAMSET 56 /* OCIParamSet */ #define OCI_FNCODE_PARAMGET 57 /* OCIParamGet */ #define OCI_FNCODE_STMTGETPIECEINFO 58 /* OCIStmtGetPieceInfo */ #define OCI_FNCODE_LDATOSVCCTX 59 /* OCILdaToSvcCtx */ /* 60 unused */ #define OCI_FNCODE_STMTSETPIECEINFO 61 /* OCIStmtSetPieceInfo */ #define OCI_FNCODE_TRANSFORGET 62 /* OCITransForget */ #define OCI_FNCODE_TRANSPREPARE 63 /* OCITransPrepare */ #define OCI_FNCODE_TRANSROLLBACK 64 /* OCITransRollback */ #define OCI_FNCODE_DEFINEBYPOS 65 /* OCIDefineByPos */ #define OCI_FNCODE_BINDBYPOS 66 /* OCIBindByPos */ #define OCI_FNCODE_BINDBYNAME 67 /* OCIBindByName */ #define OCI_FNCODE_LOBASSIGN 68 /* OCILobAssign */ #define OCI_FNCODE_LOBISEQUAL 69 /* OCILobIsEqual */ #define OCI_FNCODE_LOBISINIT 70 /* OCILobLocatorIsInit */ /* 71 was lob locator size in beta2 */ #define OCI_FNCODE_LOBENABLEBUFFERING 71 /* OCILobEnableBuffering */ #define OCI_FNCODE_LOBCHARSETID 72 /* OCILobCharSetID */ #define OCI_FNCODE_LOBCHARSETFORM 73 /* OCILobCharSetForm */ #define OCI_FNCODE_LOBFILESETNAME 74 /* OCILobFileSetName */ #define OCI_FNCODE_LOBFILEGETNAME 75 /* OCILobFileGetName */ #define OCI_FNCODE_LOGON 76 /* OCILogon */ #define OCI_FNCODE_LOGOFF 77 /* OCILogoff */ #define OCI_FNCODE_LOBDISABLEBUFFERING 78 /* OCILobDisableBuffering */ #define OCI_FNCODE_LOBFLUSHBUFFER 79 /* OCILobFlushBuffer */ #define OCI_FNCODE_LOBLOADFROMFILE 80 /* OCILobLoadFromFile */ #define OCI_FNCODE_LOBOPEN 81 /* OCILobOpen */ #define OCI_FNCODE_LOBCLOSE 82 /* OCILobClose */ #define OCI_FNCODE_LOBISOPEN 83 /* OCILobIsOpen */ #define OCI_FNCODE_LOBFILEISOPEN 84 /* OCILobFileIsOpen */ #define OCI_FNCODE_LOBFILEEXISTS 85 /* OCILobFileExists */ #define OCI_FNCODE_LOBFILECLOSEALL 86 /* OCILobFileCloseAll */ #define OCI_FNCODE_LOBCREATETEMP 87 /* OCILobCreateTemporary */ #define OCI_FNCODE_LOBFREETEMP 88 /* OCILobFreeTemporary */ #define OCI_FNCODE_LOBISTEMP 89 /* OCILobIsTemporary */ #define OCI_FNCODE_AQENQ 90 /* OCIAQEnq */ #define OCI_FNCODE_AQDEQ 91 /* OCIAQDeq */ #define OCI_FNCODE_RESET 92 /* OCIReset */ #define OCI_FNCODE_SVCCTXTOLDA 93 /* OCISvcCtxToLda */ #define OCI_FNCODE_LOBLOCATORASSIGN 94 /* OCILobLocatorAssign */ #define OCI_FNCODE_UBINDBYNAME 95 #define OCI_FNCODE_AQLISTEN 96 /* OCIAQListen */ #define OCI_FNCODE_SVC2HST 97 /* reserved */ #define OCI_FNCODE_SVCRH 98 /* reserved */ /* 97 and 98 are reserved for Oracle internal use */ #define OCI_FNCODE_TRANSMULTIPREPARE 99 /* OCITransMultiPrepare */ #define OCI_FNCODE_MAXFCN 99 /* maximum OCI function code */ /*---------------------------------------------------------------------------*/ /*-----------------------Handle Definitions----------------------------------*/ typedef struct OCIEnv OCIEnv; /* OCI environment handle */ typedef struct OCIError OCIError; /* OCI error handle */ typedef struct OCISvcCtx OCISvcCtx; /* OCI service handle */ typedef struct OCIStmt OCIStmt; /* OCI statement handle */ typedef struct OCIBind OCIBind; /* OCI bind handle */ typedef struct OCIDefine OCIDefine; /* OCI Define handle */ typedef struct OCIDescribe OCIDescribe; /* OCI Describe handle */ typedef struct OCIServer OCIServer; /* OCI Server handle */ typedef struct OCISession OCISession; /* OCI Authentication handle */ typedef struct OCIComplexObject OCIComplexObject; /* OCI COR handle */ typedef struct OCITrans OCITrans; /* OCI Transaction handle */ typedef struct OCISecurity OCISecurity; /* OCI Security handle */ typedef struct OCISubscription OCISubscription; /* subscription handle */ /*-----------------------Descriptor Definitions------------------------------*/ typedef struct OCISnapshot OCISnapshot; /* OCI snapshot descriptor */ typedef struct OCIResult OCIResult; /* OCI Result Set Descriptor */ typedef struct OCILobLocator OCILobLocator; /* OCI Lob Locator descriptor */ typedef struct OCIParam OCIParam; /* OCI PARameter descriptor */ typedef struct OCIComplexObjectComp OCIComplexObjectComp; /* OCI COR descriptor */ typedef struct OCIRowid OCIRowid; /* OCI ROWID descriptor */ typedef struct OCIDateTime OCIDateTime; /* OCI DateTime descriptor */ typedef struct OCIInterval OCIInterval; /* OCI Interval descriptor */ typedef struct OCIUcb OCIUcb; /* OCI User Callback descriptor */ /*-------------------------- AQ Descriptors ---------------------------------*/ typedef struct OCIAQEnqOptions OCIAQEnqOptions; /* AQ Enqueue Options hdl */ typedef struct OCIAQDeqOptions OCIAQDeqOptions; /* AQ Dequeue Options hdl */ typedef struct OCIAQMsgProperties OCIAQMsgProperties; /* AQ Mesg Properties */ typedef struct OCIAQAgent OCIAQAgent; /* AQ Agent descriptor */ typedef struct OCIAQNfyDescriptor OCIAQNfyDescriptor; /* AQ Nfy descriptor */ /*---------------------------------------------------------------------------*/ /* Lob typedefs for Pro*C */ typedef struct OCILobLocator OCIClobLocator; /* OCI Character LOB Locator */ typedef struct OCILobLocator OCIBlobLocator; /* OCI Binary LOB Locator */ typedef struct OCILobLocator OCIBFileLocator; /* OCI Binary LOB File Locator */ /*---------------------------------------------------------------------------*/ /* Undefined value for tz in interval types*/ #define OCI_INTHR_UNK 24 /* These defined adjustment values */ #define OCI_ADJUST_UNK 10 #define OCI_ORACLE_DATE 0 #define OCI_ANSI_DATE 1 /*------------------------ Lob-specific Definitions -------------------------*/ /* * ociloff - OCI Lob OFFset * * The offset in the lob data. The offset is specified in terms of bytes for * BLOBs and BFILes. Character offsets are used for CLOBs, NCLOBs. * The maximum size of internal lob data is 4 gigabytes. FILE LOB * size is limited by the operating system. */ typedef ub4 OCILobOffset; /* * ocillen - OCI Lob LENgth (of lob data) * * Specifies the length of lob data in bytes for BLOBs and BFILes and in * characters for CLOBs, NCLOBs. The maximum length of internal lob * data is 4 gigabytes. The length of FILE LOBs is limited only by the * operating system. */ typedef ub4 OCILobLength; /* * ocilmo - OCI Lob open MOdes * * The mode specifies the planned operations that will be performed on the * FILE lob data. The FILE lob can be opened in read-only mode only. * * In the future, we may include read/write, append and truncate modes. Append * is equivalent to read/write mode except that the FILE is positioned for * writing to the end. Truncate is equivalent to read/write mode except that * the FILE LOB data is first truncated to a length of 0 before use. */ enum OCILobMode { OCI_LOBMODE_READONLY = 1, /* read-only */ OCI_LOBMODE_READWRITE = 2 /* read_write for internal lobs only */ }; typedef enum OCILobMode OCILobMode; /*---------------------------------------------------------------------------*/ /*----------------------------Piece Definitions------------------------------*/ /* if ocidef.h is being included in the app, ocidef.h should precede oci.h */ /* * since clients may use oci.h, ocidef.h and ocidfn.h the following defines * need to be guarded, usually internal clients */ #ifndef OCI_FLAGS #define OCI_FLAGS #define OCI_ONE_PIECE 0 /* one piece */ #define OCI_FIRST_PIECE 1 /* the first piece */ #define OCI_NEXT_PIECE 2 /* the next of many pieces */ #define OCI_LAST_PIECE 3 /* the last piece */ #endif /*---------------------------------------------------------------------------*/ /*--------------------------- FILE open modes -------------------------------*/ #define OCI_FILE_READONLY 1 /* readonly mode open for FILE types */ /*---------------------------------------------------------------------------*/ /*--------------------------- LOB open modes --------------------------------*/ #define OCI_LOB_READONLY 1 /* readonly mode open for ILOB types */ #define OCI_LOB_READWRITE 2 /* read write mode open for ILOBs */ /*----------------------- LOB Buffering Flush Flags -------------------------*/ #define OCI_LOB_BUFFER_FREE 1 #define OCI_LOB_BUFFER_NOFREE 2 /*---------------------------------------------------------------------------*/ /*--------------------------- OCI Statement Types ---------------------------*/ #define OCI_STMT_SELECT 1 /* select statement */ #define OCI_STMT_UPDATE 2 /* update statement */ #define OCI_STMT_DELETE 3 /* delete statement */ #define OCI_STMT_INSERT 4 /* Insert Statement */ #define OCI_STMT_CREATE 5 /* create statement */ #define OCI_STMT_DROP 6 /* drop statement */ #define OCI_STMT_ALTER 7 /* alter statement */ #define OCI_STMT_BEGIN 8 /* begin ... (pl/sql statement)*/ #define OCI_STMT_DECLARE 9 /* declare .. (pl/sql statement ) */ /*---------------------------------------------------------------------------*/ /*--------------------------- OCI Parameter Types ---------------------------*/ #define OCI_PTYPE_UNK 0 /* unknown */ #define OCI_PTYPE_TABLE 1 /* table */ #define OCI_PTYPE_VIEW 2 /* view */ #define OCI_PTYPE_PROC 3 /* procedure */ #define OCI_PTYPE_FUNC 4 /* function */ #define OCI_PTYPE_PKG 5 /* package */ #define OCI_PTYPE_TYPE 6 /* user-defined type */ #define OCI_PTYPE_SYN 7 /* synonym */ #define OCI_PTYPE_SEQ 8 /* sequence */ #define OCI_PTYPE_COL 9 /* column */ #define OCI_PTYPE_ARG 10 /* argument */ #define OCI_PTYPE_LIST 11 /* list */ #define OCI_PTYPE_TYPE_ATTR 12 /* user-defined type's attribute */ #define OCI_PTYPE_TYPE_COLL 13 /* collection type's element */ #define OCI_PTYPE_TYPE_METHOD 14 /* user-defined type's method */ #define OCI_PTYPE_TYPE_ARG 15 /* user-defined type method's argument */ #define OCI_PTYPE_TYPE_RESULT 16 /* user-defined type method's result */ #define OCI_PTYPE_SCHEMA 17 /* schema */ #define OCI_PTYPE_DATABASE 18 /* database */ /*---------------------------------------------------------------------------*/ /*----------------------------- OCI List Types ------------------------------*/ #define OCI_LTYPE_UNK 0 /* unknown */ #define OCI_LTYPE_COLUMN 1 /* column list */ #define OCI_LTYPE_ARG_PROC 2 /* procedure argument list */ #define OCI_LTYPE_ARG_FUNC 3 /* function argument list */ #define OCI_LTYPE_SUBPRG 4 /* subprogram list */ #define OCI_LTYPE_TYPE_ATTR 5 /* type attribute */ #define OCI_LTYPE_TYPE_METHOD 6 /* type method */ #define OCI_LTYPE_TYPE_ARG_PROC 7 /* type method w/o result argument list */ #define OCI_LTYPE_TYPE_ARG_FUNC 8 /* type method w/result argument list */ #define OCI_LTYPE_SCH_OBJ 9 /* schema object list */ #define OCI_LTYPE_DB_SCH 10 /* database schema list */ /*---------------------------------------------------------------------------*/ /*-------------------------- Memory Cartridge Services ---------------------*/ #define OCI_MEMORY_CLEARED 1 /*-------------------------- Pickler Cartridge Services ---------------------*/ typedef struct OCIPicklerTdsCtx OCIPicklerTdsCtx; typedef struct OCIPicklerTds OCIPicklerTds; typedef struct OCIPicklerImage OCIPicklerImage; typedef struct OCIPicklerFdo OCIPicklerFdo; typedef ub4 OCIPicklerTdsElement; /*---------------------------------------------------------------------------*/ /*--------------------------- User Callback Constants -----------------------*/ #define OCI_UCBTYPE_ENTRY 1 /* entry callback */ #define OCI_UCBTYPE_EXIT 2 /* exit callback */ #define OCI_UCBTYPE_REPLACE 3 /* replacement callback */ /*---------------------------------------------------------------------------*/ /*--------------------- NLS service type and constance ----------------------*/ #define OCI_NLS_DAYNAME1 1 /* Native name for Monday */ #define OCI_NLS_DAYNAME2 2 /* Native name for Tuesday */ #define OCI_NLS_DAYNAME3 3 /* Native name for Wednesday */ #define OCI_NLS_DAYNAME4 4 /* Native name for Thursday */ #define OCI_NLS_DAYNAME5 5 /* Native name for Friday */ #define OCI_NLS_DAYNAME6 6 /* Native name for for Saturday */ #define OCI_NLS_DAYNAME7 7 /* Native name for for Sunday */ #define OCI_NLS_ABDAYNAME1 8 /* Native abbreviated name for Monday */ #define OCI_NLS_ABDAYNAME2 9 /* Native abbreviated name for Tuesday */ #define OCI_NLS_ABDAYNAME3 10 /* Native abbreviated name for Wednesday */ #define OCI_NLS_ABDAYNAME4 11 /* Native abbreviated name for Thursday */ #define OCI_NLS_ABDAYNAME5 12 /* Native abbreviated name for Friday */ #define OCI_NLS_ABDAYNAME6 13 /* Native abbreviated name for for Saturday */ #define OCI_NLS_ABDAYNAME7 14 /* Native abbreviated name for for Sunday */ #define OCI_NLS_MONTHNAME1 15 /* Native name for January */ #define OCI_NLS_MONTHNAME2 16 /* Native name for February */ #define OCI_NLS_MONTHNAME3 17 /* Native name for March */ #define OCI_NLS_MONTHNAME4 18 /* Native name for April */ #define OCI_NLS_MONTHNAME5 19 /* Native name for May */ #define OCI_NLS_MONTHNAME6 20 /* Native name for June */ #define OCI_NLS_MONTHNAME7 21 /* Native name for July */ #define OCI_NLS_MONTHNAME8 22 /* Native name for August */ #define OCI_NLS_MONTHNAME9 23 /* Native name for September */ #define OCI_NLS_MONTHNAME10 24 /* Native name for October */ #define OCI_NLS_MONTHNAME11 25 /* Native name for November */ #define OCI_NLS_MONTHNAME12 26 /* Native name for December */ #define OCI_NLS_ABMONTHNAME1 27 /* Native abbreviated name for January */ #define OCI_NLS_ABMONTHNAME2 28 /* Native abbreviated name for February */ #define OCI_NLS_ABMONTHNAME3 29 /* Native abbreviated name for March */ #define OCI_NLS_ABMONTHNAME4 30 /* Native abbreviated name for April */ #define OCI_NLS_ABMONTHNAME5 31 /* Native abbreviated name for May */ #define OCI_NLS_ABMONTHNAME6 32 /* Native abbreviated name for June */ #define OCI_NLS_ABMONTHNAME7 33 /* Native abbreviated name for July */ #define OCI_NLS_ABMONTHNAME8 34 /* Native abbreviated name for August */ #define OCI_NLS_ABMONTHNAME9 35 /* Native abbreviated name for September */ #define OCI_NLS_ABMONTHNAME10 36 /* Native abbreviated name for October */ #define OCI_NLS_ABMONTHNAME11 37 /* Native abbreviated name for November */ #define OCI_NLS_ABMONTHNAME12 38 /* Native abbreviated name for December */ #define OCI_NLS_YES 39 /* Native string for affirmative response */ #define OCI_NLS_NO 40 /* Native negative response */ #define OCI_NLS_AM 41 /* Native equivalent string of AM */ #define OCI_NLS_PM 42 /* Native equivalent string of PM */ #define OCI_NLS_AD 43 /* Native equivalent string of AD */ #define OCI_NLS_BC 44 /* Native equivalent string of BC */ #define OCI_NLS_DECIMAL 45 /* decimal character */ #define OCI_NLS_GROUP 46 /* group separator */ #define OCI_NLS_DEBIT 47 /* Native symbol of debit */ #define OCI_NLS_CREDIT 48 /* Native sumbol of credit */ #define OCI_NLS_DATEFORMAT 49 /* Oracle date format */ #define OCI_NLS_INT_CURRENCY 50 /* International currency symbol */ #define OCI_NLS_LOC_CURRENCY 51 /* Locale currency symbol */ #define OCI_NLS_LANGUAGE 52 /* Language name */ #define OCI_NLS_ABLANGUAGE 53 /* Abbreviation for language name */ #define OCI_NLS_TERRITORY 54 /* Territory name */ #define OCI_NLS_CHARACTER_SET 55 /* Character set name */ #define OCI_NLS_LINGUISTIC_NAME 56 /* Linguistic name */ #define OCI_NLS_CALENDAR 57 /* Calendar name */ #define OCI_NLS_DUAL_CURRENCY 78 /* Dual currency symbol */ #define OCI_NLS_MAXBUFSZ 100 /* Max buffer size may need for OCINlsGetInfo */ #define OCI_NLS_BINARY 0x1 /* for the binary comparison */ #define OCI_NLS_LINGUISTIC 0x2 /* for linguistic comparison */ #define OCI_NLS_CASE_INSENSITIVE 0x10 /* for case-insensitive comparison */ #define OCI_NLS_UPPERCASE 0x20 /* convert to uppercase */ #define OCI_NLS_LOWERCASE 0x40 /* convert to lowercase */ typedef struct OCIMsg OCIMsg; typedef ub4 OCIWchar; /*--------------------------------------------------------------------------- PRIVATE TYPES AND CONSTANTS ---------------------------------------------------------------------------*/ /* None */ /*--------------------------------------------------------------------------- PUBLIC FUNCTIONS ---------------------------------------------------------------------------*/ /* see ociap.h or ocikp.h */ /*--------------------------------------------------------------------------- PRIVATE FUNCTIONS ---------------------------------------------------------------------------*/ /* None */ #endif /* OCI_ORACLE */ /* more includes */ #ifndef OCI1_ORACLE #include #endif #ifndef ORO_ORACLE #include #endif #ifndef ORI_ORACLE #include #endif #ifndef ORL_ORACLE #include #endif #ifndef ORT_ORACLE #include #endif #ifndef OCIEXTP_ORACLE #include #endif #if defined(__STDC__) || defined(__cplusplus) #include #include #else #include #include #endif #ifndef OCI8DP_ORACLE #include /* interface definitions for the direct path api */ #endif #ifndef OCIEXTP_ORACLE #include #endif #ifdef __cplusplus } #endif /* __cplusplus */