Predefined Constants

Inhoudsopgave

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`	See `OCI_NO_AUTO_COMMIT`.
`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 transaction is not automatically committed when using this mode. For readability in new code, use this value instead of the older, equivalent `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`	Used with oci_bind_by_name() to bind RAW values.
`OCI_B_BLOB`	Used with oci_bind_by_name() when binding BLOBs.
`OCI_B_BOL`	Used with oci_bind_by_name() to bind a PL/SQL BOOLEAN variable.
`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`	Not supported.
`SQLT_BFILEE`	The same as `OCI_B_BFILE`.
`SQLT_BFLOAT`	Not supported.
`SQLT_BIN`	The same as `OCI_B_BIN`.
`SQLT_BLOB`	The same as `OCI_B_BLOB`.
`SQLT_BOL`	The same as `OCI_B_BOL`.
`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`	Not supported.
`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`.

Zoek een PHP-functie

Vertaling niet beschikbaar

De PHP-handleiding is nog niet in het Nederlands vertaald, dus het scherm is in het Engels. Als u wilt, kunt u het ook in het Frans of in het Duits raadplegen.

Als je de moed voelt, kun je je vertaling aanbieden ;-)

Nederlandse vertaling

U hebt gevraagd om deze site in het Nederlands te bezoeken. Voor nu wordt alleen de interface vertaald, maar nog niet alle inhoud.

Als je me wilt helpen met vertalingen, is je bijdrage welkom. Het enige dat u hoeft te doen, is u op de site registreren en mij een bericht sturen waarin u wordt gevraagd om u toe te voegen aan de groep vertalers, zodat u de gewenste pagina's kunt vertalen. Een link onderaan elke vertaalde pagina geeft aan dat u de vertaler bent en heeft een link naar uw profiel.

Bij voorbaat dank.

Document heeft de 30/01/2003 gemaakt, de laatste keer de 26/10/2018 gewijzigd
Bron van het afgedrukte document:https://www.gaudry.be/nl/php-rf-oci8.constants.html

De infobrol is een persoonlijke site waarvan de inhoud uitsluitend mijn verantwoordelijkheid is. De tekst is beschikbaar onder CreativeCommons-licentie (BY-NC-SA). Meer info op de gebruiksvoorwaarden en de auteur.

Referenties

Manuel PHP : http://php.net

Deze verwijzingen en links verwijzen naar documenten die geraadpleegd zijn tijdens het schrijven van deze pagina, of die aanvullende informatie kunnen geven, maar de auteurs van deze bronnen kunnen niet verantwoordelijk worden gehouden voor de inhoud van deze pagina.
De auteur Deze site is als enige verantwoordelijk voor de manier waarop de verschillende concepten, en de vrijheden die met de referentiewerken worden genomen, hier worden gepresenteerd. Vergeet niet dat u meerdere broninformatie moet doorgeven om het risico op fouten te verkleinen.

Inhoudsopgave Haut