Re: Host call to sqlplus from forms4.5

[Quoted] Try HOST ('plus33 -s .....',no_screen)

Georgette P Cornio

Tony Brown wrote:

> We are calling sqlplus from within forms 4.5, running on Win 95/NT and
> when we call it (using Host) we get two msdos windows popping up. One
> for the shell and one for sqlplus.
>
> I have two questions:
>
> 1. Can we remove the msdos windows in any way. We have tried the
> following:
>
> HOST ('sqlplus -s ....')
> HOST ('plus33 -s .....')
> HOST ('start /m plus33 -s')
> HOST ('start /m batchfile.bat') where batchfile has the sqlplus
>
> The plus33 and start /m reduce the windows to 1 but it is still left
> hanging there. It would be nice to call sqlplus code without any windows
> at all.
>
> 2. Is there a way we can know when the sqlplus has completed so that we
> don't continue in forms until the script completed successfully.
>
> email responses preferred as I don't always get time to monitor the
> newsgroups.
>
> Thanks in Advance
>
> Tony Brown
> Arete Software Limited
> Tel : +44 (0) 1344 867706
> Fax : +44 (0) 1344 867714
> Email : tb_at_arete.demon.co.uk
Received on Sun Feb 21 1999 - 06:57:03 CET