Does HOST command work at all in command window?

[MartinP]

What ever I type with a host command it always does the same thing (seems to be a dir in some directory).
So if I type:
SQL> HOST set
I'd expect to see output of all environment-variable, instead I see that list of directories.
Or,
SQL> HOST dir *.sql /s
I'd expect to see a list of all .sql file here and below.
In an odd quirk of consistency instead, I see the same old list of directories!?

What gives?
Is it expected to work at all?

What I really wanted to do was change the current directory so I can run scripts for various locations (given that scripts cal other scipts).

 

[Worker]

It works as you describe for me:

SQL> host dir *.sql /s

 Volume in drive C has no label
 Volume Serial Number is 5C90-BBE6

Directory of C:\PROGRA~1\PLSQLD~1

AFTERC~1 SQL        48 10/07/08  12:45p
LOGIN    SQL        34 12/09/01  12:00a
        2 file(s)         82 bytes

Directory of C:\PROGRA~1\PLSQLD~1\DEMO

EMPLOYEE SQL       194 11/29/98  12:00a
        1 file(s)        194 bytes

Directory of C:\PROGRA~1\PLSQLD~1\OFS\SQL

OFS      SQL      2758 12/05/05  12:00a
OFS_INIT SQL        70 12/05/05  12:00a
        2 file(s)       2828 bytes

Total files listed:
        5 file(s)       3104 bytes
                  1023932928 bytes free

Using "host cd \" seemed to work (no errors), but a subsequent host command didn't pick up on the new directory.

 

[MartinP]

Hey thanks for the reply!

So do you think the HOST command works?

For me it seems to do the same thing (like "dir *.sql") every time, no matter what command I pass to it.

I'd say that HOST does not work?
It doesnt seem to work as I'd expect.

 

[Marco Kalter]

Can you let me know your windows version and your PL/SQL Developer version?

 

[MartinP]

PL/SQL Developer
Version 7.1.5.1398
Windows XP Professional 5.1 Build 2600 (Service Pack 3)