Oracle - Executing Stored QUERIES
| From: | Chris Andrew | Date: | Fri, 05 Apr 2002 12:08:20 +0000 |
| Subject: | Oracle - Executing Stored QUERIES | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18244@lists.php.net to get a copy of this message | ||
Hi,
Please tell me this is possible:
I have a bunch of stored queries on an Oracle machine. Using PHP from a
separate RedHat box, I want to run these stored queries.
My PHP is compiled with oracle support, and I can issue regular SQL to the
Oracle box - such as "SELECT foo FROM bar". This works no problem.
But - surely there must be a way to issue some kind of SQL statement that
will run a pre-stored query (not procedure)?
The only other thing I thought of doing was to install sqlplus (oracles
client) and calling that on the command line - or something along those
lines?
Any ideas greatly appreciated.
Chris