How to use results from sqlplus host command

Hi All,
Is it possible to place the results of sqlplus host command into a variable ? Or even into an array of variables?

Here are 3 examples:

1 item returned: host pwd

1 row, multiple items: host uptime

multiple rows: host ls

How can I use the return values in sqlplus?

TIA!

One way : ask for HOST pwd > resultfile.txt , and later run a PL/SQL routine to read resultfile.txt via UTL_FILE.

Regards,

Chiappa

Quote:

---

Originally posted by PFC
Hi All,
Is it possible to place the results of sqlplus host command into a variable ? Or even into an array of variables?

Here are 3 examples:

1 item returned: host pwd

1 row, multiple items: host uptime

multiple rows: host ls

How can I use the return values in sqlplus?

TIA!

---

Another possibility (at least under 9i) is to use Hetergeneous services to let sqlplus access the output of the host command (done to a file with '>') as an external table.