Resource Types
Examples
OCI8
PHP Manual

# 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.

`OCI_DEFAULT` (integer)
  Statement execution mode. Statement is not committed automatically when using this mode.
`OCI_DESCRIBE_ONLY` (integer)
  Statement execution mode. Use this mode if you don't want to execute the query, but get the select-list's description.
`OCI_COMMIT_ON_SUCCESS` (integer)
  Statement execution mode. Statement is automatically committed after oci_execute() call.
`OCI_EXACT_FETCH` (integer)
  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. Cursor is cancelled after the desired rows are fetched and may result in reduced server-side resource usage.
`OCI_SYSDATE` (integer)
`OCI_B_BFILE` (integer)
  Used with oci_bind_by_name() when binding BFILEs.
`OCI_B_CFILEE` (integer)
  Used with oci_bind_by_name() when binding CFILEs.
`OCI_B_CLOB` (integer)
  Used with oci_bind_by_name() when binding CLOBs.
`OCI_B_BLOB` (integer)
  Used with oci_bind_by_name() when binding BLOBs.
`OCI_B_ROWID` (integer)
  Used with oci_bind_by_name() when binding ROWIDs.
`OCI_B_CURSOR` (integer)
  Used with oci_bind_by_name() when binding cursors, previously allocated with oci_new_descriptor().
`OCI_B_NTY` (integer)
  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_BIN` (integer)
`SQLT_BFILEE` (integer)
  The same as `OCI_B_BFILE`.
`SQLT_CFILEE` (integer)
  The same as `OCI_B_CFILEE`.
`SQLT_CLOB` (integer)
  The same as `OCI_B_CLOB`.
`SQLT_BLOB` (integer)
  The same as `OCI_B_BLOB`.
`SQLT_RDD` (integer)
  The same as `OCI_B_ROWID`.
`SQLT_NTY` (integer)
  The same as `OCI_B_NTY`.
`SQLT_LNG` (integer)
  Used with oci_bind_by_name() to bind LONG values.
`SQLT_LBI` (integer)
  Used with oci_bind_by_name() to bind LONG RAW values.
`SQLT_BIN` (integer)
  Used with oci_bind_by_name() to bind RAW values.
`SQLT_NUM` (integer)
  Used with oci_bind_array_by_name() to bind arrays of NUMBER.
`SQLT_INT` (integer)
  Used with oci_bind_array_by_name() to bind arrays of INTEGER.
`SQLT_AFC` (integer)
  Used with oci_bind_array_by_name() to bind arrays of CHAR.
`SQLT_CHR` (integer)
  Used with oci_bind_array_by_name() to bind arrays of VARCHAR2. Also used with oci_bind_by_name().
`SQLT_VCS` (integer)
  Used with oci_bind_array_by_name() to bind arrays of VARCHAR.
`SQLT_AVC` (integer)
  Used with oci_bind_array_by_name() to bind arrays of CHARZ.
`SQLT_STR` (integer)
  Used with oci_bind_array_by_name() to bind arrays of STRING.
`SQLT_LVC` (integer)
  Used with oci_bind_array_by_name() to bind arrays of LONG VARCHAR.
`SQLT_FLT` (integer)
  Used with oci_bind_array_by_name() to bind arrays of FLOAT.
`SQLT_ODT` (integer)
  Used with oci_bind_array_by_name() to bind arrays of LONG.
`SQLT_BDOUBLE` (integer)
`SQLT_BFLOAT` (integer)
`OCI_FETCHSTATEMENT_BY_COLUMN` (integer)
  Default mode of oci_fetch_all().
`OCI_FETCHSTATEMENT_BY_ROW` (integer)
  Alternative mode of oci_fetch_all().
`OCI_ASSOC` (integer)
  Used with oci_fetch_all() and oci_fetch_array() to get an associative array as a result.
`OCI_NUM` (integer)
  Used with oci_fetch_all() and oci_fetch_array() to get an enumerated array as a result.
`OCI_BOTH` (integer)
  Used with oci_fetch_all() and oci_fetch_array() to get an array with both associative and number indices.
`OCI_RETURN_NULLS` (integer)
  Used with oci_fetch_array() to get empty array elements if field's value is `NULL`.
`OCI_RETURN_LOBS` (integer)
  Used with oci_fetch_array() to get value of LOB instead of the descriptor.
`OCI_DTYPE_FILE` (integer)
  This flag tells oci_new_descriptor() to initialize new FILE descriptor.
`OCI_DTYPE_LOB` (integer)
  This flag tells oci_new_descriptor() to initialize new LOB descriptor.
`OCI_DTYPE_ROWID` (integer)
  This flag tells oci_new_descriptor() to initialize new ROWID descriptor.
`OCI_D_FILE` (integer)
  The same as `OCI_DTYPE_FILE`.
`OCI_D_LOB` (integer)
  The same as `OCI_DTYPE_LOB`.
`OCI_D_ROWID` (integer)
  The same as `OCI_DTYPE_ROWID`.
`OCI_SYSOPER` (integer)
  Used with oci_connect() to connect as SYSOPER using external credentials (oci8.privileged_connect should be enabled for this).
`OCI_SYSDBA` (integer)
  Used with oci_connect() to connect as SYSDBA using external credentials (oci8.privileged_connect should be enabled for this).
`OCI_LOB_BUFFER_FREE` (integer)
  Used with OCI-Lob->flush to free buffers used.
`OCI_TEMP_CLOB` (integer)
  Used with OCI-Lob->writeTemporary to indicate explicilty that temporary CLOB should be created.
`OCI_TEMP_BLOB` (integer)
  Used with OCI-Lob->writeTemporary to indicate explicilty that temporary BLOB should be created.

Resource Types
Examples
OCI8
PHP Manual