(PHP 5, PHP 7, PECL OCI8 >= 1.1.0) Returns the type of a statement string oci_statement_type ( resource $statement ) Returns a keyword identifying the type of the OCI8 statement. Parameters: statement A valid OCI8 statement identifier from oci_parse(). Returns: Returns the type of statement as one of the following strings. Statement type Retu

(PHP 5, PHP 7, PECL OCI8 >= 1.1.0) Sets number of rows to be prefetched by queries bool oci_set_prefetch ( resource $statement, int $rows ) Sets the number of rows to be buffered by the Oracle Client libraries after a successful query call to oci_execute() and for each subsequent internal fetch request to the database. For queries returning a large number of rows, performance can be significantly improved by increasing th

(PHP 5.3.2, PHP 7, PECL OCI8 >= 1.4.0) Sets the module name bool oci_set_module_name ( resource $connection, string $module_name ) Sets the module name for Oracle tracing. The module name is registered with the database when the next 'roundtrip' from PHP to the database occurs, typically when an SQL statement is executed. The name can subsequently be queried from database administration views such as V$SESSION. It can

(PHP 5.3.2, PHP 7, PECL OCI8 >= 1.4.0) Sets the database edition bool oci_set_edition ( string $edition ) Sets the database "edition" of objects to be used by a subsequent connections. Oracle Editions allow concurrent versions of applications to run using the same schema and object names. This is useful for upgrading live systems. Call oci_set_edition() before calling oci_connect(), oci_pconnect() or oci_new_connect()

(PHP 5.3.2, PHP 7, PECL OCI8 >= 1.4.0) Sets the client information bool oci_set_client_info ( resource $connection, string $client_info ) Sets the client information for Oracle tracing. The client information is registered with the database when the next 'roundtrip' from PHP to the database occurs, typically when an SQL statement is executed. The client information can subsequently be queried from database administrat

(PHP 5.3.2, PHP 7, PECL OCI8 >= 1.4.0) Sets the client identifier bool oci_set_client_identifier ( resource $connection, string $client_identifier ) Sets the client identifier used by various database components to identify lightweight application users who authenticate as the same database user. The client identifier is registered with the database when the next 'roundtrip' from PHP to the database occurs, typically wh

(PHP 5.3.2, PHP 7, PECL OCI8 >= 1.4.0) Sets the action name bool oci_set_action ( resource $connection, string $action_name ) Sets the action name for Oracle tracing. The action name is registered with the database when the next 'roundtrip' from PHP to the database occurs, typically when an SQL statement is executed. The action name can subsequently be queried from database administration views such as V$SESSION. It c

(PHP 5, PHP 7, PECL OCI8 >= 1.1.0) Returns the Oracle Database version string oci_server_version ( resource $connection ) Returns a string with the Oracle Database version and available options Parameters: connection Returns a string with the Oracle Database version and available options Returns: Returns the version information as a string or

(PHP 5, PHP 7, PECL OCI8 >= 1.1.0) Rolls back the outstanding database transaction bool oci_rollback ( resource $connection ) Reverts all uncommitted changes for the Oracle connection and ends the transaction. It releases all locks held. All Oracle SAVEPOINTS are erased. A transaction begins when the first SQL statement that changes data is executed with oci_execute() using the OCI_NO_AUTO_COMMIT flag. Further data chan

(PHP 5, PHP 7, PECL OCI8 >= 1.1.0) Returns field's value from the fetched row mixed oci_result ( resource $statement, mixed $field ) Returns the data from field in the current row, fetched by oci_fetch(). For details on the data type mapping performed by the OCI8 extension, see the datatypes supported by the driver Parameters: statement Returns the data from field in t