Im on oracle 8.1.7
How can i send a file on a ftp site with oracle.
Printable View
Im on oracle 8.1.7
How can i send a file on a ftp site with oracle.
Could you please make your question a bit more clear.
is there like a dbms.ftp
like there is for mail
i dont want to use ftp script and run it,
i want to use only oracle.
You can user UTL_TCP package provided by oracle.
HTH
np70
You could write a C/Java/Perl program that would do the work for you and then invoke it from oracle. Volla!
Sam
Question to NP70, since TCP and FTP are two different protocol structures, how would you achieve FTP over UTL_TCP
Interested to know more ...
Sam
Sam,
I think TCP is protocol. and you can have either http or ftp
connection to particular port using TCP.(e.g. port 80 for http)
np70
NP70,
Thanx for fixing my ignorence. http://www.plauder-smilies.de/yellows/ohwe.gif
Yes, you are correct, FTP layer is on top of the TCP as a result, you could use the TCP.
Sam
could anyone give me an example with the UTL_TCP package
Steeve123,
i have closed your thread http://www.dbasupport.com/forums/new...threadid=15229 as it was a redundant post on this topic. Please refrain from posting multiple posts on the same topic.
Ans, to your question: refer ,
http://www.oradoc.com/ora816/server....tcp.htm#998101
Sam
u can use the "HOST" cmd in oracle scripts to run DOS-shell ftp scripts ...
this way u dont need any packages.