Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

View select queries produce no results

contemplatorApr 19 2015 — edited Apr 21 2015

I followed the "Using PHP OCI8 and Oracle" instruction on Installing PHP and the Oracle 11g Instant Client for Linux and Windows. It works perfectly.

I selected my own table:

$stid = oci_parse($conn, 'select * from person');

and all my table rows appeared.

I then created a view from that table, and selected it:

$stid = oci_parse($conn, 'select * from vw_person');

The query executed without errors, but no rows have appeared.

The views displays a few rows when I query it in the SQL Command Line.

I tried: changing the spelling and adding "/" but just got ORA errors. Which means the connection is sound.

I changed it back, even tried selecting one column, but no errors appeared nor any rows.

help?

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 19 2015
Added on Apr 19 2015
3 comments
1,832 views