oci_num_rows(ocirowcount) is always showing 0 records in PHP with Oracle

[mahmoodtyagi]

oci_num_rows(ocirowcount) is always showing 0 records(while having more rows) in PHP with Oracle to fetch total no of records.
Code wrote as follows:

$qry2="select * from USER";
$smt2=ociparse($conn,$qry2);
$r=ociexecute($smt2);
echo 'Total Rows='.ocirowcount($smt2);

Output show always: Total Rows=0

[ronverdonk]

Note: This function does not return number of rows selected! For SELECT statements this function will return the number of rows, that were fetched to the buffer with oci_fetch*() functions.

Should be the reason.

Ronald