No Oracle DB fetch results in PHP, why?

Question

PHP

For some reason, the function does not work oci_fetch ();when a query is executed in Oracle SQL Developer, the data is returned, but not in PHP.
Code example:

$username = 'user';
$password = 'pass';
$db = 'db';

$connect = OCILogon($username, $password, $db, 'AL32UTF8'); 

$select = "
select row
from scheme.table
";

$query = OCI_Parse($connect, $select);

// Возвращает  true 
oci_define_by_name($query, 'ROW', $row);

// Возвращает  true 
oci_execute($query);

// Возвращает false 
while (oci_fetch($query)) {
    echo $row;
}

oci_free_statement($query);
oci_close($connect);

Moreover, other requests work and return something, but this one does not.
The table has 100% data.
Why can this happen?

Answer 1

If you do not understand the problem, then try using PDO.

Answer 2

Is it really a table and not a view? Is there some kind of feature in the database, like row-by-line access control or DBMS_RULE? Isn't the table in question a kind of global temporary table ?