PHP & Oracle: SQL doesn't return query in PHP Oracle call, but have result in SqlDeveloper

Question

I have a PHP calling Oracle database. The issue is that when I'm using SQLDeveloper to query the database with the given SQL, I can get the correct results. Now I have an existing PHP application that reads SQL from an XML. Other SQLs successfully returns rows, but when I used the given SQL it did not return any rows. Is there something wrong in my SQL which cannot be accepted in PHP Oracle? Or are there case where tables in Oracle that cannot be queried? Thank you.

SQL in XML file:

Select "PROJECT_NAME" From TABLE_A
Where EXISTS (                         
   SELECT "DATA ID", "DATA NAME" FROM TABLE_B
   WHERE  TABLE_B."DATA LEVEL" = 3
   AND TABLE_B."DATA TYPE" = 'TYPEA')
AND TABLE_A.COLUMN1 is null

PHP Code:

<?php 
echo '<br> sql: ' . $report_sql;
$stmt = oci_parse($conn, $report_sql);
oci_execute($stmt, OCI_DEFAULT);
echo '<div style="width:450px;"> <table id="tableBD1" class="display" cellspacing="0" width="100%">';
echo '<thead>
            <tr >
                <th>Project Name</th>
            </tr>
        </thead>';

echo '<tbody>';

while ($row=oci_fetch_array($stmt,OCI_BOTH)) 
{
  echo "<tr><td> <a href='#'>". $row['PROJECT_NAME'] . "</a> </td>";
}

echo '</tbody>';
echo '</table> </div>';

oci_free_statement($stmt);
?>

where is $report_sql? or is it exactly the same as the sql above? I think it could be syntax error — user3036342
– user3036342, Commented May 9, 2014 at 9:14

vdolez · Accepted Answer · 2014-05-09 09:37:08Z

1

I think the problem may come from how you retrieve and handle your result row in PHP. Also I've faced similar issues using SDO_GEOMETRY with oracle in PHP.

I suggest you try to print your row before trying to print a specific field. It might be a good idea to make the request and it's treatment indepent. Sorry I don't have the reputation to only comment your question.

answered May 9, 2014 at 9:37

vdolez

1,1411 gold badge16 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP & Oracle: SQL doesn't return query in PHP Oracle call, but have result in SqlDeveloper

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related