Oracle + PHP + long process

Hi all,

Oracle 10g RAC on Linux, with an end-user interface via Apache/PHP/AdoDB on a separate Linux box.

I need to create a PHP web interface to allow an end-user to run a PL/SQL stored proc that will do a force refresh of a series of materialized views following the loading (through another PHP interface) of additional flat file data into the underlying tables. I want to allow multiple data uploads and then do a single refresh, so I won't be able to use fast refresh or other internal database trigger mechanisms.

My real problem is that the time taken to execute the stored proc is likely to considerably exceed the max script execution time for PHP, and I don't want the end-user interface to just sit there bubbling away waiting for the Oracle processes to return a response anyway.

I am considering creating a "master" PL/SQL stored procedure which would use the Oracle DBMS_SCHEDULER package to run a nearly-immediate job as a "background" (to the PHP interface) process.

Is this the way to go, or are there other better solutions that I am overlooking?

TIA Geoff M Received on Thu Oct 05 2006 - 00:03:17 CDT