Query on Oracle Views
| From: | Rankin, Randy | Date: | Tue, 07 Aug 2001 00:33:17 +0000 |
| Subject: | Query on Oracle Views | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-11099@lists.php.net to get a copy of this message | ||
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.
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 the '$' in the table name is the
beginning of a variable. Does anyone know how to get around this so that I
can execute a query with a table name like v$instance?
TIA,
Randy Rankin