[PHP-DB] Query on Oracle Views

2001-08-06 Thread Rankin, Randy
I am connecting to an Oracle 8 server using OCI, PHP and Apache on a RH Linux 7.1 box. All works well until I try to query an Oracle dynamic view like the following: $query = "SELECT instance_name, host_name FROM v$instance"; When I execute this query, the server returns the following error.

Re: [PHP-DB] Query on Oracle Views

2001-08-06 Thread Paul Burney
on 8/6/01 5:33 PM, Rankin, Randy at [EMAIL PROTECTED] wrote: > When I execute this query, the server returns the following error. > Warning: OCIStmtExecute: ORA-00942: table or view does not exist in > /usr/local/apache/htdocs/oracle/oraprod.php on line 17 > > My suspicion is that PHP thinks tha