Host call to sqlplus from forms4.5

From: Tony Brown <tb_at_arete.demon.co.uk>
Date: Fri, 19 Feb 1999 09:26:47 +0000
Message-ID: <8MWHdDAX5Sz2Ew$e_at_arete.demon.co.uk>

[Quoted] [Quoted] 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 [Quoted] hanging there. It would be nice to call sqlplus code without any windows at all.

[Quoted] 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 Fri Feb 19 1999 - 10:26:47 CET