"host" works to get you to unix but, I was tryin got do something like:

select ......;
host << EOF
ftp somehost
bin
put somefile
bye
exit
EOF
select .....


But as Joe pointed out, I believe you must call a script from the host command...

>>> Todd Pepling <[Email Address Removed] 09/30/03 09:22AM >>>
"host" works for me (SQL*Plus 9.2.0.1.0). On Unix "!" is alternative
syntax.

-----Original Message-----
From: Michael Porter [mailto:[Email Address Removed]
Sent: Tuesday, September 30, 2003 9:08 AM
To: LazyDBA.com Discussion
Subject: FTP from inside sqlplus... I can't get it to work anymore...


I use to have a script that would be able to use the "host" command to drop
to Unix shell and then ftp a file and then pop back up to sqlplus. I can't
seem to get it to work and I know it can be done. HELP me before I jump!

THX
Mike




Oracle LazyDBA home page