Re: Running SQL*Plus via "start" command in Oracle forms does not work on windows 2000

On Windows 2000, you should use HOST('cmd /c '||your command). This will open a dos box and invoke your command. To keep the box open after execution (for debug purposes) use cmd /k.

Robbert

"Suresh Bhat" <oracleguru_at_lycos.com> schreef in bericht news:9c64199c.0210281442.2ed66596_at_posting.google.com...
> Running SQL*Plus from forms via "start" command
>
> Oracle forms 6.0.8.10.3 windows 2000, RDBMS 7.3.4.10.3(UNIX server).
>
> I had used the following code to run SQL*Plus on windows NT and it had
> worked but now with windows 2000, it does not work. Nothing happens.
>
> It still works for the users that have windows NT.
>
> :global.var := 'start /MAX \\ntapps\oracle6i\orant\bin\plus80w.exe '||
> :global.username||'/'||:global.password||'_at_'||:global.instance||
> ' _at_\\ntapps\oracle6i\scripts\x.sql';
> host(:global.var);
>
> How can I make this code work in Oracle forms on windows 2000 ?
>
> Thanks.
>
> Suresh Bhat
Received on Thu Nov 07 2002 - 21:39:31 CET