[PHP-DB] Oracle - Executing Stored QUERIES
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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Oracle - Executing Stored QUERIES
On Fri, Apr 05, 2002 at 01:08:20PM +0100, Chris Andrew wrote: 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)? what is a pre-stored query? tc -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php