Re: Background PL/SQL processing in a Form
Date: 1998/02/27
Message-ID: <6d6s23$33b_at_info.csufresno.edu>#1/1
In article <34F4B250.1FA92794_at_capital.net>,
Rick Alexander <alexandr_at_capital.net> wrote:
> I have a form which picks a query (from a pre-selected query list);
> writes the output to a file; selects a printer; then prints the
> file. This is handled via a PL/SQL procedure. Now I want to give
> the users a backround option. (Example: Make the selections; run it
> in the background. The form would not wait for the query to finish;
> before control is regained. Some queries take hours...)
>
> Does anyone have any thoughts on how to handle backround processing
> on a PL/SQL procedure.
>
> Thanks Rick Alexander
> Email: alexandr_at_capital.net
I can think of two options:
1. Use Run_Product with the Asynchronous parameter to start a new
Forms session and run the query from the second form. The problem is,
I don't think you can automatically switch back to the original form
from the newly started form--the user would have to use the Windows
Alt-Tab sequence to switch (you ARE using Windows, right?)
2. Use DBMS_PIPE to start a batch process on the server. But then you would need some method of storing the results from that process, and then retrieving them later in the form--maybe using another database table???
Good luck,
Steve Cosner
http://members.aol.com/stevec5088
Downloadable Quick Access utility form: Display and update any table. Received on Fri Feb 27 1998 - 00:00:00 CET