4D v16

Summary of constants

Home

 
4D v16
Summary of constants

Summary of constants    


 

 

The following tables list 4D for OCI constants grouped by theme. For detailed information about these constants, please refer to the OCI documentation provided by the Oracle corporation.

ConstantValueComment
OCI_ATTR_AGENT_ADDRESS65Protocol-specific address of recipient
OCI_ATTR_AGENT_NAME64Name of message producer or consumer
OCI_ATTR_AGENT_PROTOCOL66Protocol to interpret address and propagate message
OCI_ATTR_ALLOC_DURATION37Sets value of allocation duration
OCI_ATTR_APPCTX_ATTR276Specifies attribute name of externally initialized context
OCI_ATTR_APPCTX_LIST274Gets application context list descriptor
OCI_ATTR_APPCTX_NAME275Specifies namespace of externally initialized context
OCI_ATTR_APPCTX_SIZE273Initializes externally initialized context array size with number of attributes
OCI_ATTR_APPCTX_VALUE277Specifies value of externally initialized context
OCI_ATTR_ATTEMPTS59Specifies number of attempts made to dequeue message
OCI_ATTR_AUTOCOMMIT_DDL271Specifies if autocommit mode required for DDL statements
OCI_ATTR_BUF_ADDR76Buffer address of beginning of stream data
OCI_ATTR_BUF_SIZE77Size of stream data in bytes
OCI_ATTR_CACHE115Number of sequence numbers cached
OCI_ATTR_CACHE_CLIENT_CONTEXT251Cache for user constructed instances
OCI_ATTR_CACHE_MAX_SIZE35Sets maximum client-side object cache size as a percentage of optimal size
OCI_ATTR_CACHE_OPT_SIZE34Sets optimal client-side object cache size in bytes
OCI_ATTR_CATALOG_LOCATION268Position of catalog in table
OCI_ATTR_CHAR_COUNT15Sets number of characters in character type data
OCI_ATTR_CHARSET20Character set value
OCI_ATTR_CHARSET_FORM32Character set form of bind handle
OCI_ATTR_CHARSET_ID31Character set ID of bind handle
OCI_ATTR_CLUSTERED105Indicates table is clustered
OCI_ATTR_COL_COUNT82Last column of last row processed
OCI_ATTR_COLLECTION_ELEMENT227Handle to collection element
OCI_ATTR_COLLECTION_TYPECODE217Type code of collection
OCI_ATTR_COMPOBJ_COLL_OUTOFLIN53Indicates whether to fetch collection attributes in out-of-line type object
(refer to OCI_ATTR_COMPLEXOBJECT_COLL_OUTOFLINE)
OCI_ATTR_COMPOBJ_LEVEL52Depth level for complex object retrieval
(refer to OCI_ATTR_COMPLEXOBJECT_LEVEL)
OCI_ATTR_COMPOBJCOMP_TYP50Type of Ref to follow for complex object retrieval
(refer to OCI_ATTR_COMPLEXOBJECTCOMP_TYPE)
OCI_ATTR_COMPOBJCOMP_TYP_LEVEL51Depth level for following Refs
(refer to OCI_ATTR_COMPLEXOBJECTCOMP_TYPE_LEVEL)
OCI_ATTR_CONSUMER_NAME50Name of consumer
OCI_ATTR_CORRELATION58Specifies identifier for message
OCI_ATTR_CURSOR_COMMIT_BEHAVIOR266Specifies effect of Commit on cursors
OCI_ATTR_DATA_SIZE1Maximum size in bytes of external data for column
OCI_ATTR_DATA_TYPE2Gets or sets external data type of column
OCI_ATTR_DATEFORMAT75Date conversion mask for column
OCI_ATTR_DELAY56Specifies number of seconds to delay message
OCI_ATTR_DEQ_MODE51Specifies locking behavior associated with dequeue
OCI_ATTR_DEQ_MSGID54Specifies identifier of message to be dequeued
OCI_ATTR_DESC_PUBLIC250Specifies object name to be looked up as a public synonym
OCI_ATTR_DIRPATH_FILE139Database file to load into
OCI_ATTR_DIRPATH_INDEX_MAINT_METHOD138Performs index row insertion
OCI_ATTR_DIRPATH_MODE78Mode of direct path context
OCI_ATTR_DIRPATH_NOLOG79NOLOG attribute determines whether image redo or invalidation redo is generated
OCI_ATTR_DIRPATH_PARALLEL80Allows same direct path segment to be loaded concurrently
OCI_ATTR_DIRPATH_SORTED_INDEX137Index that data is sorted on
OCI_ATTR_DIRPATH_STORAGE_INITI140Initial extent size
OCI_ATTR_DIRPATH_STORAGE_NEXT141Next extent size
OCI_ATTR_DISP_NAME100Display name
OCI_ATTR_DISP_SIZE3Display size
OCI_ATTR_DML_ROW_OFFSET74Returns offset (into DML array) where error occurred
OCI_ATTR_DURATION132Duration of temporary table
OCI_ATTR_ENCAPSULATION235Encapsulation level of method
OCI_ATTR_ENQ_TIME62Specifies time message was enqueued
OCI_ATTR_ENV5Returns environment context associated with server context
OCI_ATTR_EXCEPTION_QUEUE61Specifies name of exception queue
OCI_ATTR_EXPIRATION57Specifies expiration of message
OCI_ATTR_EXTERNAL_NAME26Specifies external global database name
OCI_ATTR_FDO39Format Descriptor object attribute
OCI_ATTR_FNCODE1Returns OCI function code
OCI_ATTR_FOCBK43Sets failover callback
OCI_ATTR_FSPRECISION0Specifies fractional seconds precision of datetime or interval
OCI_ATTR_HAS_DEFAULT212Indicates whether argument has a default
OCI_ATTR_HAS_FILE226Type contains a BFILE attribute
OCI_ATTR_HAS_LOB225Type contains a LOB attribute
OCI_ATTR_HAS_NESTED_TABLE224Type contains a nested table attribute
OCI_ATTR_HAS_RESULT240Indicates whether argument has a result
OCI_ATTR_HEAPALLOC30Current size of memory allocated from environment handle
OCI_ATTR_HW_MARK117High-water mark (in Number format)
OCI_ATTR_IN_V8_MODE44Determines whether application has switched to Oracle release 7 mode
OCI_ATTR_INCR114Increment (in Oracle Number format)
OCI_ATTR_INDEX_ONLY107Indicates table is index-only
OCI_ATTR_INITIAL_CLIENT_ROLES100Specifies initial client role(s) when the application server connects
OCI_ATTR_INTERNAL_NAME25Sets client database name recorded when performing global transactions
OCI_ATTR_IOMODE213Indicates the argument mode (IN, OUT, IN/OUT)
OCI_ATTR_IS_CONSTANT239Indicates method is a constant
OCI_ATTR_IS_CONSTRUCTOR241Indicates method is a constructor
OCI_ATTR_IS_DESTRUCTOR242Indicates method is a destructor
OCI_ATTR_IS_INCOMPLETE_TYPE219Indicates an incomplete type
OCI_ATTR_IS_INLINE238Indicates method is inline
OCI_ATTR_IS_INVOKER_RIGHTS133Indicates procedure or function has invoker's rights
OCI_ATTR_IS_MAP244Indicates method is a map method
OCI_ATTR_IS_NULL7Indicates whether null values are permitted for column
OCI_ATTR_IS_OPERATOR243Indicates method is an operator
OCI_ATTR_IS_ORDER245Indicates method is an order method
OCI_ATTR_IS_PREDEFINED_TYPE221Indicates a predefined type
OCI_ATTR_IS_RNDS246Indicates "Read No Data State" is set for method
OCI_ATTR_IS_RNPS247Indicates "Read No Process State" is set for method
OCI_ATTR_IS_SELFISH236Indicates method is selfish
OCI_ATTR_IS_SUBTYPE258Indicates a subtype
OCI_ATTR_IS_SYSTEM_GENERATED_TYPE223Indicates a system-generated type
OCI_ATTR_IS_SYSTEM_TYPE220Indicates a system type
OCI_ATTR_IS_TEMPORARY130Indicates table is temporary
OCI_ATTR_IS_TRANSIENT_TYPE222Indicates a transient type
OCI_ATTR_IS_TYPED131Indicates table is typed
OCI_ATTR_IS_VIRTUAL237Indicates method is virtual
OCI_ATTR_IS_WNDS248Indicates "Write No Data State" is set for method
OCI_ATTR_IS_WNPS249Indicates "Write No Process State" is set for method
OCI_ATTR_LEVEL211Data type levels
OCI_ATTR_LFPRECISION0Leading field precision of interval
OCI_ATTR_LINK111Database link name of synonym translation
OCI_ATTR_LIST_ARGUMENTS108List of arguments at next level
OCI_ATTR_LIST_COLUMNS103Column list
OCI_ATTR_LIST_OBJECTS261List of objects in schema
OCI_ATTR_LIST_SCHEMAS263List of schemas in database
OCI_ATTR_LIST_SUBPROGRAMS109Subprogram list
OCI_ATTR_LIST_TYPE_ATTRS229List of type attributes
OCI_ATTR_LIST_TYPE_METHODS231List of type methods
OCI_ATTR_LOBEMPTY45Sets internal LOB locator to empty
OCI_ATTR_LOCKING_MODE272Locking mode for database
OCI_ATTR_LTYPE128Specifies list type
OCI_ATTR_MAP_METHOD232Map method of type
OCI_ATTR_MAX113Maximum value (in Oracle Number format)
OCI_ATTR_MAX_CATALOG_NAMELEN267Maximum length of catalog (database) name
OCI_ATTR_MAX_COLUMN_LEN265Maximum length of column name
OCI_ATTR_MAX_PROC_LEN264Maximum length of procedure name
OCI_ATTR_MAXDATA_SIZE33Sets maximum number of bytes allowed in buffer on server side
OCI_ATTR_MEMPOOL_APPNAME90Name or pathname of executable
OCI_ATTR_MEMPOOL_HOMENAME91Directory name where executables using same instance are located
OCI_ATTR_MEMPOOL_INSTNAME89User-defined name to identify an instance of shared subsystem
OCI_ATTR_MEMPOOL_MODEL92Model of shared pool
OCI_ATTR_MEMPOOL_SIZE88Size of shared pool in bytes
OCI_ATTR_MIGSESSION86Specifies session identified for session handle
OCI_ATTR_MIN112Minimum value (in Oracle Number format)
OCI_ATTR_MODES93Modes
OCI_ATTR_MSG_PROP72Message properties
OCI_ATTR_MSG_STATE63Specifies state of message at time of dequeue
OCI_ATTR_NAME4Name of table to be loaded into
OCI_ATTR_NAVIGATION52Specifies position of message retrieved
OCI_ATTR_NCHAR21NCHAR type
OCI_ATTR_NCHARSET_ID262Database national character set ID from server handle
OCI_ATTR_NESTED_PREFETCH_MEMOR14Memory limit for nested rows
OCI_ATTR_NESTED_PREFETCH_ROWS12Prefetch rows of nested table
OCI_ATTR_NFY_MSGID71Message ID
OCI_ATTR_NOCACHE87Specifies whether temporary LOB is read into buffer cache of server
OCI_ATTR_NONBLOCKING_MODE3Determines blocking mode
OCI_ATTR_NOWAIT_SUPPORT270Determines whether database supports NOWAIT clause
OCI_ATTR_NUM_ARGS215Total number of arguments
OCI_ATTR_NUM_ATTRS120Number of attributes
OCI_ATTR_NUM_COLS102Number of columns
OCI_ATTR_NUM_DML_ERRORS73Returns number of errors in DML operation
OCI_ATTR_NUM_ELEMS234Number of elements in an array
OCI_ATTR_NUM_PARAMS121Number of elements in list
OCI_ATTR_NUM_ROWS81Number of rows loaded/to be allocated
OCI_ATTR_NUM_TYPE_ATTRS228Number of type attributes
OCI_ATTR_NUM_TYPE_METHODS230Number of type methods
OCI_ATTR_OBJ_ID136Object or schema ID
OCI_ATTR_OBJ_NAME134Database name or object name in schema
OCI_ATTR_OBJ_SCHEMA135Schema name where object is located
OCI_ATTR_OBJECT2Returns True if environment initialized in object mode
OCI_ATTR_OBJID122Object ID
OCI_ATTR_ORDER116Specifies whether sequence is ordered
OCI_ATTR_ORDER_METHOD233Order method of type
OCI_ATTR_ORIGINAL_MSGID69ID of message in last queue that generated this message
OCI_ATTR_OVERLOAD210Specifies whether position is overloaded
OCI_ATTR_OVERLOAD_ID125Overloading ID number
OCI_ATTR_PARAM124Points to root of description
OCI_ATTR_PARAM_COUNT18Returns number of parameters in describe handle
OCI_ATTR_PARSE_ERROR_OFFSET129Returns parse error offset for statement
OCI_ATTR_PARTITIONED106Indicates table is partitioned
OCI_ATTR_PASSWORD23Specifies password to use for authentication
OCI_ATTR_PDPRC17Specifies packed decimal precision
OCI_ATTR_PDSCL16Specifies scale for packed decimal values
OCI_ATTR_PIN_DURATION38Sets default value for pin durations
OCI_ATTR_PINOPTION36Sets pin default value
OCI_ATTR_POSITION11Position of argument in list
OCI_ATTR_POSTPROCESSING_CALLBA40Callback to process outbind data
OCI_ATTR_POSTPROCESSING_CONTEX41Callback context to process outbind data
OCI_ATTR_PRECISION5Gets or sets precision
OCI_ATTR_PREFETCH_MEMORY13Sets memory level for top-level rows to be prefetched
OCI_ATTR_PREFETCH_ROWS11Sets number of top-level rows to be prefetched
OCI_ATTR_PRIORITY55Specifies message priority
OCI_ATTR_PROXY_CREDENTIALS99Specifies use of application server credentials for proxy authentication
OCI_ATTR_PTYPE123Type of information described by parameter
OCI_ATTR_QUEUE_NAME70Queue name of notification
OCI_ATTR_RADIX214Returns radix (if Number type)
OCI_ATTR_RDBA104Data block address of segment header
OCI_ATTR_RECIPIENT_LIST60List of recipients (queue subscribers by default)
OCI_ATTR_REF_TDO110Returns Ref of type descriptor object (TDO)
OCI_ATTR_RELATIVE_MSGID48Specifies identifier of message in sequence deviation operation
OCI_ATTR_ROW_COUNT9Returns number of rows successfully processed
OCI_ATTR_ROWID19Returns ROWID descriptor
OCI_ATTR_ROWS_RETURNED42Number of rows to be returned in current iteration
OCI_ATTR_SAVEPOINT_SUPPORT269Specifies whether database supports savepoints
OCI_ATTR_SCALE6Scale of numeric type attributes
OCI_ATTR_SCHEMA_NAME9Returns schema name
OCI_ATTR_SENDER_ID68Identifies original sender of message
OCI_ATTR_SEQUENCE_DEVIATION49Specifies whether message should be dequeued before other message(s) already in queue
OCI_ATTR_SERVER6Gets or sets server context attribute
OCI_ATTR_SERVER_GROUP85Specifies server group
OCI_ATTR_SERVER_STATUS143Returns current status of server handle
OCI_ATTR_SESSION7Gets or sets authentication context attribute
OCI_ATTR_SESSLANG46Session language handle
OCI_ATTR_SHARED_HEAPALLOC84Returns size of memory currently allocated from shared pool
OCI_ATTR_SQLCODE4Returns code of last SQL command processed
OCI_ATTR_SQLFNCODE10Returns function code of SQL command associated with statement
OCI_ATTR_STATEMENT144Returns text of SQL statement
OCI_ATTR_STMT_TYPE24Type of statement associated with handle
OCI_ATTR_STREAM_OFFSET83Offset into stream buffer of last processed row
OCI_ATTR_SUB_NAME10Name of partition or subpartition to be loaded
OCI_ATTR_SUBSCR_CALLBACK95Subscription callback
OCI_ATTR_SUBSCR_CTX96Context to pass to user callback
OCI_ATTR_SUBSCR_NAME94Subscription name
OCI_ATTR_SUBSCR_NAMESPACE98Namespace where subscription handle is used
OCI_ATTR_SUBSCR_PAYLOAD97Buffer that corresponds to payload sent with notification
OCI_ATTR_SUPERTYPE_NAME260Name of supertype
OCI_ATTR_SUPERTYPE_SCHEMA_NAME259Name of schema containing supertype
OCI_ATTR_TABLESPACE126Tablespace where table resides
OCI_ATTR_TDO127Sets object or collection attribute type
OCI_ATTR_TIMESTAMP119Timestamp of object
OCI_ATTR_TRANS8Gets or sets transaction context attribute
OCI_ATTR_TRANS_LOCK28Locks transaction
OCI_ATTR_TRANS_NAME29Gets or sets text string which identifies transaction
OCI_ATTR_TRANS_TIMEOUT142Gets or sets timeout interval value
OCI_ATTR_TYPE_NAME8Type name
OCI_ATTR_TYPE_SCHEMA118Schema name of type
OCI_ATTR_TYPECODE216Type code
OCI_ATTR_UCI_CONSTRUCT252Construct user constructed instance
OCI_ATTR_UCI_COPY254Copy user constructed instance
OCI_ATTR_UCI_DESTRUCT253Destroy user constructed instance
OCI_ATTR_UCI_PICKLE255Pickle user constructed instance
OCI_ATTR_UCI_REFRESH257Refresh user constructed instance
OCI_ATTR_UCI_UNPICKLE256Unpickle user constructed instance
OCI_ATTR_UNK101Unknown attribute
OCI_ATTR_USERNAME22Specifies user name for authentication
OCI_ATTR_VERSION218Database version
OCI_ATTR_VISIBILITY47Specifies transactional behavior for message
OCI_ATTR_WAIT53Specifies wait time if no message matching search criteria is currently available
OCI_ATTR_XID27Gets or sets XID which identifies transaction

ConstantValueComment
SQLT_AFC96Specifies CHAR data type
SQLT_AVC97Specifies CHARZ data type
SQLT_BDOUBLE22Specifies BINARY_DOUBLE (native double) data type
SQLT_BFILE114Specifies binary FILE LOB data type
SQLT_BFILEE114Specifies binary file LOB data type
SQLT_BFLOAT21Specifies BINARY_FLOAT (native float) data type
SQLT_BIN23Specifies RAW data type
SQLT_BLOB113Specifies binary LOB descriptor data type
SQLT_CFILE115Specifies character file LOB data type
SQLT_CFILEE115Specifies character file LOB data type
SQLT_CHR1Specifies VARCHAR2 data type
SQLT_CLOB112Specifies character LOB data type
SQLT_CUR102Cursor type
SQLT_DAT12Specifies DATE data type
SQLT_DATE184Specifies ANSI DATE descriptor data type
SQLT_FILE114Specifies binary FILE descriptor data type
SQLT_FLT4Specifies FLOAT data type
SQLT_INT3Specifies INTEGER data type
SQLT_INTERVAL_DS190Specifies INTERVAL DAY TO SECOND descriptor data type
SQLT_INTERVAL_YM189Specifies INTERVAL YEAR TO MONTH data type
SQLT_LAB105MLSLABEL data type
SQLT_LBI24Specifies LONG RAW data type
SQLT_LNG8Specifies LONG data type
SQLT_LVB95Specifies LONG VARRAW data type
SQLT_LVC94Specifies LONG VARCHAR data type
SQLT_NCO122Specifies COLLECTION data type
SQLT_NON10Specifies unknown (none) data type
SQLT_NTY108Specifies named data type
SQLT_NUM2Specifies NUMBER data type
SQLT_ODT156Specifies OCI DATE data type
SQLT_OSL106Specific OS label type
SQLT_PDN7Specifies Packed Decimal Numeric (PDN) data type
SQLT_RDD104Specifies ROWID descriptor data type
SQLT_REF110Specifies REF data type
SQLT_RID11Specifies ROWID data type
SQLT_RSET116Specifies result set data type
SQLT_SLS91Specifies Sign Leading Separate (SLS) data type
SQLT_STR5Specifies NULL-terminated STRING data type
SQLT_TIME185Specifies TIME data type
SQLT_TIME_TZ186Specifies TIME WITH TIME ZONE data type
SQLT_TIMESTAMP187Specifies TIMESTAMP descriptor data type
SQLT_TIMESTAMP_LTZ232Specifies TIMESTAMP WITH LOCAL TIME ZONE descriptor data type
SQLT_TIMESTAMP_TZ188Specifies TIMESTAMP WITH TIME ZONE data type
SQLT_UIN68Specifies UNSIGNED data type
SQLT_VBI15Specifies VARRAW data type
SQLT_VCS9Specifies VARCHAR data type
SQLT_VNU6Specifies VARNUM data type
SQLT_VST155Specifies OCI STRING data type

ConstantValueComment
OCI_DTYPE_AQAGENT60Specifies generation of Advanced Queuing agent descriptor
OCI_DTYPE_AQDEQ_OPTIONS58Specifies generation of Advanced Queuing dequeue options descriptor
OCI_DTYPE_AQENQ_OPTIONS57Specifies generation of Advanced Queuing enqueue options descriptor
OCI_DTYPE_AQMSG_PROPERTIES59Specifies generation of Advanced Queuing message properties descriptor
OCI_DTYPE_AQNFY_DESCRIPTOR64Specifies generation of Advanced Queuing notification descriptor
(refer to OCI_DTYPE_AQNFY)
OCI_DTYPE_COMPLEXOBJECTCOMP55Specifies generation of complex object retrieval descriptor
OCI_DTYPE_DATE65Specifies generation of ANSI DATE descriptor
OCI_DTYPE_FILE56Specifies generation of FILE value type locator
OCI_DTYPE_FIRST50Specifies first descriptor type
OCI_DTYPE_INTERVAL_DS63Specifies generation of INTERVAL DAY TO SECOND descriptor
OCI_DTYPE_LAST71Specifies last descriptor type
OCI_DTYPE_LOB50Specifies generation of LOB value type locator
OCI_DTYPE_LOCATOR61Specific descriptor type locator
OCI_DTYPE_PARAM53Specifies generation of read-only parameter descriptor
OCI_DTYPE_ROWID54Specifies generation of ROWID descriptor
OCI_DTYPE_RSET52Specifies result set descriptor
OCI_DTYPE_SNAP51Specifies generation of snapshot descriptor
OCI_DTYPE_TIME66Specifies generation of TIME descriptor
OCI_DTYPE_TIME_TZ67Specifies generation of TIME WITH TIME ZONE descriptor
OCI_DTYPE_TIMESTAMP68Specifies generation of TIMESTAMP descriptor
OCI_DTYPE_TIMESTAMP_LTZ70Specifies generation of TIMESTAMP WITH LOCAL TIME ZONE descriptor
OCI_DTYPE_TIMESTAMP_TZ69Specifies generation of TIMESTAMP WITH TIME ZONE descriptor
OCI_DTYPE_UCB71Specifies generation of user callback descriptor

ConstantValueComment
OCI_BATCH_ERRORS128Collects information about any errors that occurred
OCI_BATCH_MODE1Batch OCI statement for execution
OCI_COMMIT_ON_SUCCESS32Selectively commits transactions at end of each statement
OCI_DESCRIBE_ONLY16Returns select-list description without executing statement
OCI_EXACT_FETCH2Used when application knows exact number of rows to be fetched in advance
OCI_KEEP_FETCH_STATE4Result set rows of statement are kept during transaction migration
OCI_NON_BLOCKING64Non-blocking statement execution mode
OCI_PARSE_ONLY256Allows user to parse query prior to execution
OCI_SCROLLABLE_CURSOR8Specifies cursor is scrollable
OCI_SHOW_DML_WARNINGS1024Returns diagnostic information

ConstantValueComment
OCI_HTYPE_BIND5OCI bind handle
OCI_HTYPE_COMPLEXOBJECT11OCI complex object retrieval (COR) handle
OCI_HTYPE_DEFINE6OCI define handle
OCI_HTYPE_DESCRIBE7OCI describe handle
OCI_HTYPE_DIRPATH_COLUMN_ARRAY15OCI direct path column array handle
OCI_HTYPE_DIRPATH_CTX14OCI direct path context handle
OCI_HTYPE_DIRPATH_STREAM16OCI direct path stream handle
OCI_HTYPE_ENV1OCI environment handle
OCI_HTYPE_ERROR2OCI error handle
OCI_HTYPE_FIRST1First OCI handle
OCI_HTYPE_LAST17Last OCI handle
OCI_HTYPE_PROC17OCI process handle
OCI_HTYPE_SECURITY12OCI security handle
OCI_HTYPE_SERVER8OCI server handle
OCI_HTYPE_SESSION9OCI user session handle
OCI_HTYPE_STMT4OCI statement handle
OCI_HTYPE_SUBSCRIPTION13OCI subscription handle
OCI_HTYPE_SVCCTX3OCI service context handle
OCI_HTYPE_TRANS10OCI transaction handle

ConstantValueComment
BIND_IN0Direction for IN binds
BIND_IO2Direction for IN OUT binds
BIND_OUT1Direction for OUT binds
OCI_CRED_EXT2Authenticate using external credentials
OCI_CRED_RDBMS1Authenticate using database user name and password pair as credentials
OCI_STMT_ALTER7ALTER statement
OCI_STMT_BEGIN8BEGIN... (PL/SQL) statement
OCI_STMT_CREATE5CREATE statement
OCI_STMT_DECLARE39DECLARE... (PL/SQL) statement
OCI_STMT_DELETE3DELETE statement
OCI_STMT_DROP6DROP statement
OCI_STMT_INSERT4INSERT statement
OCI_STMT_SELECT1SELECT statement
OCI_STMT_UPDATE2UPDATE statement

ConstantValueComment
OCI_CACHE512Specifies use of cache
OCI_DATA_AT_EXEC2Defines total size of data that can be provided at runtime
OCI_DEFAULT0Default mode
OCI_DYNAMIC_FETCH2Fetches data dynamically at runtime
OCI_EVENTS4Utilizes publish-subscribe notifications
OCI_NO_MUTEX128No mutexing in this mode
OCI_NO_SHARING1Disables sharing mode for SQL statement
OCI_NO_UCB64Suppresses calling of dynamic callback routine
OCI_OBJECT2Uses object features
OCI_PIECEWISE4Operation on one of many pieces
OCI_SHARED16Uses shared data structures
OCI_SHARED_EXT256Used for shared forms
OCI_THREADED1Uses threaded environment

ConstantValueComment
OCI_PTYPE_ARG10Argument of function or procedure
OCI_PTYPE_COL9Column of table or view
OCI_PTYPE_DATABASE18Database
OCI_PTYPE_FUNC4Function
OCI_PTYPE_LIST11Column list, argument list, or subprogram list
OCI_PTYPE_PKG5Package
OCI_PTYPE_PROC3Procedure
OCI_PTYPE_SCHEMA17Schema
OCI_PTYPE_SEQ8Sequence
OCI_PTYPE_SYN7Synonym
OCI_PTYPE_TABLE1Table
OCI_PTYPE_TYPE6Type
OCI_PTYPE_TYPE_ARG15Argument of type method
OCI_PTYPE_TYPE_ATTR12Attribute of type
OCI_PTYPE_TYPE_COLL13Collection type information
OCI_PTYPE_TYPE_METHOD14Method of type
OCI_PTYPE_TYPE_RESULT16Results of method
OCI_PTYPE_UNK0Unknown schema object
OCI_PTYPE_VIEW2View

ConstantValueComment
OCI_CONTINUE24200Indicates callback function wants normal processing to resume
OCI_ERROR-1Returns additional information after function failure
OCI_INVALID_HANDLE-2Invalid handle was passed
OCI_NEED_DATA99Application needs to provide runtime data
OCI_NO_DATA100Indicates there is no further data
OCI_STILL_EXECUTING-3123Current operation could not be completed immediately
OCI_SUCCESS0Function completed successfully
OCI_SUCCESS_WITH_INFO1Indicates function completed successfully and returns additional diagnostic information

 
 

 
PROPERTIES 

Product: 4D
Theme: Summary of constants

 
HISTORY 

 
ARTICLE USAGE

4D for OCI ( 4D v16)