Re: Batch Execute from Forms Trigger

Amin Adatia (KnowTech Solutions Inc) wrote:

> Is it possible to have a procedure execute in batch mode as opposed to
> on-line from within a When-Button_Pressed trigger ?
>
> I have a data extract routine that could potentially run for 8 hours
> depending on the selection parameters. The client environment is Windows95
> or Windows 3.11 and the server is HP Unix and Oracle 7.3

For such a expensive routine. Better create a stored procedure on Oracle and invoke it using sql*Plus, maybe.

It will save a lot of network traffic + better on performance + not to occupies a pc.

Enjoy,
Michael Received on Tue Oct 22 1996 - 00:00:00 CEST