Re: Automatic form generation using F45gen32.exe

You could make a DOS batch file that has each F45gen32 executable prefaced by "start /WAIT"
For example:

start /WAIT f45gen32.exe module=mymod userid=scott/tiger batch=YES start /WAIT f45gen32.exe module=mymod2 userid=scott/tiger batch=YES

Each f45gen32 should complete before the batch file moves to the next line.

I actually use Microsoft's NMAKE utility for a similar purpose, but I don't need to put the "start /WAIT" in, since f45gen32 seems to stop processing of the makefile until it's done. Shrug.

• Art Clarke aclarke_at_us.oracle.com

Clayton Mitchell (clayton_mitchell_at_vela.ca) wrote:
> Has anyone been able to generate forms sequentially and automatically
> using a SQL*Plus script, DOS batch file or other script tool? I need to
> build an automatic form, library and menu generator to generate 16
> forms, 21 libraries and 12 menus. There is one for the Macintosh
> (called Oracle Command) which works quite well. But there does not seem
> to be an equivalent Windows version. If a DOS batch file is used, each
> form generation session is created, but the batch file moves on to the
> next one before the first one is finished. This causes the machine to
> fill with F45gen32 sessions which then start to GPF. The same thing
> happens with a SQL*Plus script using the HOST command.
> Only 4 F45gen32 sessions can be run on the machine at one time without
> difficulty.
> Is there an option on SQL*Plus or elsewhere that would allow running
> F45gen32 synchronously, allowing each session to finish before starting
> a new one, or a way to detect when a session is completed? A possible
> hack solution is to build a timing function on the database and call it
> from the generate script to slow down the speed the script starts new
> sessions.
> Any suggestions would be appreciated.
Received on Thu Apr 24 1997 - 00:00:00 CEST