oci_fetch

PHP 5, PHP 7, PHP 8, PECL OCI8 >= 1.1.0
oci_fetch - Fetches the next row from a query into internal buffers
Manual
Code Examples

oci_fetch( resource$statement ): bool

Fetches the next row from a query into internal buffers accessible either with oci_result, or by using variables previously defined with oci_define_by_name.

See oci_fetch_array for general information about fetching data.

Parameters

statement

A valid OCI8 statement identifier created by oci_parse and executed by oci_execute, or a REF CURSOR statement identifier.

Return Values

Returns true on success or false if there are no more rows in the statement.

Notes

Note:

Will not return rows from Oracle Database Implicit Result Sets. Use oci_fetch_array instead.

Related Functions

  • oci_define_by_name - Associates a PHP variable with a column for query fetches
  • oci_fetch_all - Fetches multiple rows from a query into a two-dimensional array
  • oci_fetch_array - Returns the next row from a query as an associative or numeric array
  • oci_fetch_assoc - Returns the next row from a query as an associative array
  • oci_fetch_object - Returns the next row from a query as an object
  • oci_fetch_row - Returns the next row from a query as a numeric array
  • oci_result - Returns field's value from the fetched row

Example of oci_fetch

Show all examples for oci_fetch

Edit/Test in Sandbox
PHP Version:


Function oci_fetch:

Oracle OCI8 Functions

Most used PHP functions