Home » SQL & PL/SQL » SQL & PL/SQL » I want function for FTP file to other server.
I want function for FTP file to other server. [message #253138] Sun, 22 July 2007 22:45 Go to next message
poy_sian
Messages: 7
Registered: July 2007
Location: Thailand
Junior Member
I have a problem. Can u help me?
I have 2 servers for collect data. Server A is database server and server B is backup server but both server is keep in diferent place(Thailand-Hongkong). I want to put file in both server then i think to use FTP to help my problem.

Please help me for suggest FTP solution or the new solution.

Re: I want function for FTP file to other server. [message #253139 is a reply to message #253138] Sun, 22 July 2007 22:50 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>Please help me for suggest FTP solution or the new solution.
Use either ftp or scp.
Re: I want function for FTP file to other server. [message #253140 is a reply to message #253138] Sun, 22 July 2007 22:57 Go to previous messageGo to next message
poy_sian
Messages: 7
Registered: July 2007
Location: Thailand
Junior Member
Use either ftp or scp.

FTP is the first solution to proof.


best regard
Poy_sian
Re: I want function for FTP file to other server. [message #253145 is a reply to message #253138] Sun, 22 July 2007 23:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How is this a PL/SQL Expert question?

Regards
Michel
Re: I want function for FTP file to other server. [message #253148 is a reply to message #253145] Sun, 22 July 2007 23:34 Go to previous messageGo to next message
poy_sian
Messages: 7
Registered: July 2007
Location: Thailand
Junior Member
Michel Cadot wrote on Sun, 22 July 2007 23:28
How is this a PL/SQL Expert question?

Regards
Michel



I need PL/SQL function to use FTP.

Thanks.
Re: I want function for FTP file to other server. [message #253155 is a reply to message #253148] Mon, 23 July 2007 00:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So why don't you mention this in your question?

What is your Oracle version?

Regards
Michel
Re: I want function for FTP file to other server. [message #253180 is a reply to message #253138] Mon, 23 July 2007 01:13 Go to previous messageGo to next message
poy_sian
Messages: 7
Registered: July 2007
Location: Thailand
Junior Member
Oracle Database 8i and form developer 6i


best regard
poy_sian
Re: I want function for FTP file to other server. [message #253198 is a reply to message #253180] Mon, 23 July 2007 01:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which 8i?

Regards
Michel
Re: I want function for FTP file to other server. [message #253206 is a reply to message #253198] Mon, 23 July 2007 02:35 Go to previous messageGo to next message
poy_sian
Messages: 7
Registered: July 2007
Location: Thailand
Junior Member
Michel Cadot wrote on Mon, 23 July 2007 01:54
Which 8i?

Regards
Michel



Oracle database8i Enterprise Edition 8.1.5.0.0
Re: I want function for FTP file to other server. [message #253212 is a reply to message #253206] Mon, 23 July 2007 02:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try to find a FTP Java class (search on Web, especially on AskTom), include it in the database and create a PL/SQL wrapper.

Btw, 8.1.5 was desupported more than 6 years ago maybe it is time to change for a newer version.

Regards
Michel
Re: I want function for FTP file to other server. [message #253380 is a reply to message #253212] Mon, 23 July 2007 12:23 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
http://www.orafaq.com/scripts/plsql/ftpclient.txt
Re: I want function for FTP file to other server. [message #253381 is a reply to message #253380] Mon, 23 July 2007 12:28 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
http://technology.amis.nl/blog/?p=1247
Previous Topic: How to correct ORA-01830: date format picture ends before converting entire input string error?
Next Topic: select fields in a join
Goto Forum:
  


Current Time: Fri Dec 02 14:28:17 CST 2016

Total time taken to generate the page: 0.15566 seconds