OraFAQ Forum: SQL & PL/SQL » I want function for FTP file to other server.

Home » SQL & PL/SQL » SQL & PL/SQL » I want function for FTP file to other server.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

I want function for FTP file to other server. [message #253138]

Sun, 22 July 2007 22:45

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.

Report message to a moderator

Re: I want function for FTP file to other server. [message #253139 is a reply to message #253138]

Sun, 22 July 2007 22:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Please help me for suggest FTP solution or the new solution.
Use either ftp or scp.

Report message to a moderator

Re: I want function for FTP file to other server. [message #253140 is a reply to message #253138]

Sun, 22 July 2007 22:57

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

Report message to a moderator

Re: I want function for FTP file to other server. [message #253145 is a reply to message #253138]

Sun, 22 July 2007 23:28

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

How is this a PL/SQL Expert question?

Regards
Michel

Report message to a moderator

Re: I want function for FTP file to other server. [message #253148 is a reply to message #253145]

Sun, 22 July 2007 23:34

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.

Report message to a moderator

Re: I want function for FTP file to other server. [message #253155 is a reply to message #253148]

Mon, 23 July 2007 00:37

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So why don't you mention this in your question?

What is your Oracle version?

Regards
Michel

Report message to a moderator

Re: I want function for FTP file to other server. [message #253180 is a reply to message #253138]

Mon, 23 July 2007 01:13

poy_sian
Messages: 7
Registered: July 2007
Location: Thailand

Junior Member

Oracle Database 8i and form developer 6i

best regard
poy_sian

Report message to a moderator

Re: I want function for FTP file to other server. [message #253198 is a reply to message #253180]

Mon, 23 July 2007 01:54

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Which 8i?

Regards
Michel

Report message to a moderator

Re: I want function for FTP file to other server. [message #253206 is a reply to message #253198]

Mon, 23 July 2007 02:35

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

Report message to a moderator

Re: I want function for FTP file to other server. [message #253212 is a reply to message #253206]

Mon, 23 July 2007 02:40

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator