Predefined Constants

The constants below are defined by this extension, and will only be available when the extension has either been compiled into PHP or dynamically loaded at runtime.

**OCI8 Function and Method Modes**
Constant	Description
OCI_ASSOC	Used with oci_fetch_all() and oci_fetch_array() to get results as an associative array.
OCI_BOTH	Used with oci_fetch_all() and oci_fetch_array() to get results as an array with both associative and number indices.
OCI_COMMIT_ON_SUCCESS	Statement execution mode for oci_execute() call. Automatically commit changes when the statement has succeeded.
OCI_CRED_EXT	Used with oci_connect() for using Oracles' External or OS authentication. Introduced in PHP 5.3 and PECL OCI8 1.3.4.
OCI_DEFAULT	Statement execution mode for oci_execute(). The transaction is not automatically committed when using this mode. From PHP 5.3.2 (PECL OCI8 1.4) onwards, `OCI_NO_AUTO_COMMIT` is preferred instead of `OCI_DEFAULT`.
OCI_DESCRIBE_ONLY	Statement execution mode for oci_execute(). Use this mode if you want meta data such as the column names but don't want to fetch rows from the query.
OCI_EXACT_FETCH	Obsolete. Statement fetch mode. Used when the application knows in advance exactly how many rows it will be fetching. This mode turns prefetching off for Oracle release 8 or later mode. The cursor is canceled after the desired rows are fetched which may result in reduced server-side resource usage.
OCI_FETCHSTATEMENT_BY_COLUMN	Default mode of oci_fetch_all().
OCI_FETCHSTATEMENT_BY_ROW	Alternative mode of oci_fetch_all().
OCI_LOB_BUFFER_FREE	Used with OCI-Lob->flush to free buffers used.
OCI_NO_AUTO_COMMIT	Statement execution mode for oci_execute(). The statement is not committed automatically when using this mode. For readability in new code, use this value instead of the obsolete `OCI_DEFAULT` constant. Introduced in PHP 5.3.2 (PECL OCI8 1.4).
OCI_NUM	Used with oci_fetch_all() and oci_fetch_array() to get results as an enumerated array.
OCI_RETURN_LOBS	Used with oci_fetch_array() to get the data value of the LOB instead of the descriptor.
OCI_RETURN_NULLS	Used with oci_fetch_array() to get empty array elements if the row items value is `NULL`.
OCI_SEEK_CUR	Used with OCI-Lob->seek to set the seek position.
OCI_SEEK_END	Used with OCI-Lob->seek to set the seek position.
OCI_SEEK_SET	Used with OCI-Lob->seek to set the seek position.
OCI_SYSDATE	Obsolete.
OCI_SYSDBA	Used with oci_connect() to connect with the SYSDBA privilege. The `php.ini` setting oci8.privileged_connect should be enabled to use this.
OCI_SYSOPER	Used with oci_connect() to connect with the SYSOPER privilege. The `php.ini` setting oci8.privileged_connect should be enabled to use this.
OCI_TEMP_BLOB	Used with OCI-Lob->writeTemporary to indicate that a temporary BLOB should be created.
OCI_TEMP_CLOB	Used with OCI-Lob->writeTemporary to indicate that a temporary CLOB should be created.

**OCI8 Bind and Define Types**
Constant	Description
OCI_B_BFILE	Used with oci_bind_by_name() when binding BFILEs.
OCI_B_BIN
OCI_B_BLOB	Used with oci_bind_by_name() when binding BLOBs.
OCI_B_CFILEE	Used with oci_bind_by_name() when binding CFILEs.
OCI_B_CLOB	Used with oci_bind_by_name() when binding CLOBs.
OCI_B_CURSOR	Used with oci_bind_by_name() when binding cursors, previously allocated with oci_new_descriptor().
OCI_B_INT	Used with oci_bind_array_by_name() to bind arrays of INTEGER.
OCI_B_NTY	Used with oci_bind_by_name() when binding named data types. Note: in PHP < 5.0 it was called `OCI_B_SQLT_NTY`.
OCI_B_NUM	Used with oci_bind_array_by_name() to bind arrays of NUMBER.
OCI_B_ROWID	Used with oci_bind_by_name() when binding ROWIDs.
SQLT_AFC	Used with oci_bind_array_by_name() to bind arrays of CHAR.
SQLT_AVC	Used with oci_bind_array_by_name() to bind arrays of VARCHAR2.
SQLT_BDOUBLE
SQLT_BFILEE	The same as `OCI_B_BFILE`.
SQLT_BFLOAT
SQLT_BIN	Used with oci_bind_by_name() to bind RAW values.
SQLT_BLOB	The same as `OCI_B_BLOB`.
SQLT_CFILEE	The same as `OCI_B_CFILEE`.
SQLT_CHR	Used with oci_bind_array_by_name() to bind arrays of VARCHAR2. Also used with oci_bind_by_name().
SQLT_CLOB	The same as `OCI_B_CLOB`.
SQLT_FLT	Used with oci_bind_array_by_name() to bind arrays of FLOAT.
SQLT_INT	The same as `OCI_B_INT`.
SQLT_LBI	Used with oci_bind_by_name() to bind LONG RAW values.
SQLT_LNG	Used with oci_bind_by_name() to bind LONG values.
SQLT_LVC	Used with oci_bind_array_by_name() to bind arrays of LONG VARCHAR.
SQLT_NTY	The same as `OCI_B_NTY`.
SQLT_NUM	The same as `OCI_B_NUM`.
SQLT_ODT	Used with oci_bind_array_by_name() to bind arrays of LONG.
SQLT_RDD	The same as `OCI_B_ROWID`.
SQLT_RSET	The same as `OCI_B_CURSOR`.
SQLT_STR	Used with oci_bind_array_by_name() to bind arrays of STRING.
SQLT_UIN
SQLT_VCS	Used with oci_bind_array_by_name() to bind arrays of VARCHAR.

**OCI8 Descriptor Types**
Constant	Description
OCI_DTYPE_FILE	This flag tells oci_new_descriptor() to initialize a new FILE descriptor.
OCI_DTYPE_LOB	This flag tells oci_new_descriptor() to initialize a new LOB descriptor.
OCI_DTYPE_ROWID	This flag tells oci_new_descriptor() to initialize a new ROWID descriptor.
OCI_D_FILE	The same as `OCI_DTYPE_FILE`.
OCI_D_LOB	The same as `OCI_DTYPE_LOB`.
OCI_D_ROWID	The same as `OCI_DTYPE_ROWID`.

Runtime Configuration

Examples

OCI8

PHP Manual

docs.sk

comprehensive documentation repository

PHP Manual

Predefined Constants