Home » RDBMS Server » Server Administration » How do I pipe HOST output to a file from within a SQL script?
How do I pipe HOST output to a file from within a SQL script? [message #371792] Wed, 06 December 2000 13:46
Michele
Messages: 77
Registered: December 2000
Member
I call several HOST commands within a SQL script and it will pipe the first command's output to a file with no problems, but all HOST commands after that one fail. I've tried piping them to separate files and appending them to one file and it still fails.

sample code:
HOST df > /tmp/unix.txt
HOST ls -la $ORACLE_HOME >> /tmp/unix.txt
HOST ps -e >> /tmp/unix.txt
Previous Topic: Paging through a resultset
Next Topic: Functions parameter list
Goto Forum:
  


Current Time: Thu May 02 06:42:14 CDT 2024