PHP: oci_num_fields - Manual (original) (raw)

(PHP 5, PHP 7, PHP 8, PECL OCI8 >= 1.1.0)

oci_num_fields — Returns the number of result columns in a statement

Description

Parameters

statement

A valid OCI statement identifier.

Return Values

Returns the number of columns as an int.

Examples

Example #1 oci_num_fields() example

<?php// Create the table with: // CREATE TABLE mytab (id NUMBER, quantity NUMBER);$conn = oci_connect("hr", "hrpwd", "localhost/XE"); if (!$conn) { $m = oci_error(); trigger_error(htmlentities($m['message']), E_USER_ERROR); }$stid = oci_parse($conn, "SELECT * FROM mytab"); oci_execute($stid, OCI_DESCRIBE_ONLY); // Use OCI_DESCRIBE_ONLY if not fetching rows$ncols = oci_num_fields($stid); for ($i = 1; <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>i</mi><mo><</mo><mo>=</mo></mrow><annotation encoding="application/x-tex">i <= </annotation></semantics></math>i<=ncols; $i++) { echo oci_field_name($stid, <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>i</mi><mo stretchy="false">)</mo><mi mathvariant="normal">.</mi><mi mathvariant="normal">"</mi><mi mathvariant="normal">"</mi><mi mathvariant="normal">.</mi><mi>o</mi><mi>c</mi><msub><mi>i</mi><mi>f</mi></msub><mi>i</mi><mi>e</mi><mi>l</mi><msub><mi>d</mi><mi>t</mi></msub><mi>y</mi><mi>p</mi><mi>e</mi><mo stretchy="false">(</mo></mrow><annotation encoding="application/x-tex">i) . " " . oci_field_type(</annotation></semantics></math>i)."".ocifieldtype(stid, $i) . " \n"; }// Outputs: // ID NUMBER // QUANTITY NUMBERoci_free_statement($stid); oci_close($conn);?>

Found A Problem?

jnield at impole dot com ¶

26 years ago

The following is not immediately obvious:

If you need the number of columns in a REF CURSOR returned from a PL/SQL procedure, you need to use OCINumColumns() on the cursor handle returned by OCINewCursor after it is bound and executed, not the statement handle. Same applies for OCIColumnName() and friends.