[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 that