Link to home
Start Free TrialLog in
Avatar of tomvv
tomvv

asked on

ftp script

What is an ftp script to send file from one host to another..

Could u tell me at what occasions..
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Please pay attention to the zones you ask your questions in.  ftp is not an Oracle command so it should really not be asked in an Oracle zone.

ftp us a stand-alone unix command.  It does not need to be part of a script.

>>Could u tell me at what occasions..

When you have a file on one server and you need to get it to another server.

A quick Google will tell you everything you ever wanted to know about this command.
FTP is a file transfer protocol (in fact, that's what the acronym stands for)

most operating systems offer a command line tool to do so.  There are also gui tools to do it.

If you are asking how to do a file transfer via ftp within Oracle, you can do so with the package described here...  example scripts for its use are included


https://www.experts-exchange.com/Database/Oracle/A_3043-How-to-FTP-with-Oracle-PL-SQL.html
Just want to clarify.  ftp is not a unix command.  It exists on most every operating system.

Technically, it is a protocol, but there is usually a command of the same name.

Some systems do not run the daemon to accept ftp connections as it is less secure than newer protocols.  That is really up to the security policy of the company.
ASKER CERTIFIED SOLUTION
Avatar of David VanZandt
David VanZandt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The ftp "command" is actually a little ftp client program that uses the FTP protocol to transfer files and directory listings to and from an ftp server program.  The ftp server program is usually running on another computer.

People sometimes mistakenly refer to ftp client commands as "FTP commands" for example the client has a command "put" for uploading a file but it actually sends multiple FTP commands to the server like TYPE, PORT and STOR.

The command line ftp client program on windows is out of date in that it can't do passive mode data transfers or SSL encrypted connections.  One good replacement is a supported commerical program named Robo-FTP.  It has a lot more script commands and can even send SQL statements to your database via ODBC.  There are also some shareware scriptable FTP clients.  WinSCP, for example, has basic scripting capabilities.  Sometimes basic scripting is all you need.