this works for me ....

/home14/quartz32 >cat .1
sqlplus quartz32/[Email Address Removed] << !
host echo "open 202.41.7.5" >>11
host echo "user quartz32 james007" >>11
host echo "ls -rtl" >>11
host echo "close" >>11
host echo quit >>11
host ftp -in <11
!

Thanks and Regards,
Mohit Mahajan

Version 3.0.2 ,
Quartz , Ground Floor,
Tata Consultancy Services
447 , Phase V ,
Udyog Vihar .
Gurgaon




"Michael
Porter" To: "LazyDBA.com Discussion" <[Email Address Removed]
<[Email Address Removed] cc:
q.com> Subject: RE: FTP from inside sqlplus... I can't get it to work
anymore...
09/30/2003
06:56 PM






"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] 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 documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html





Oracle LazyDBA home page