Home » SQL & PL/SQL » SQL & PL/SQL » pl/sql with ftp (Oracle 10g,windows 2003 server,linux as4)
pl/sql with ftp [message #406342] Wed, 03 June 2009 08:03 Go to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
HI....

Is there any option other than ftp to transfor files from one server to another....using pl/sql.

As we can use pl/sql with ftp to transfor files.....our ftp server is not working properly due to some config issues....

Based on that i can create one directory....and one procedure to collect the content of that file and update one clob column....

Regards
Sriram
Re: pl/sql with ftp [message #406343 is a reply to message #406342] Wed, 03 June 2009 08:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I recommend you to fix your ftp configuration problem.
Even if Oracle is able to do ftp, why do you think it will not have the same problem?
Why do you think you have to buy Oracle to ftp when there are so many free tools for this?

As Oracle supports TCP, it is able to do FTP but of course you need to configure in the same way.

Regards
Michel
Re: pl/sql with ftp [message #406347 is a reply to message #406342] Wed, 03 June 2009 08:38 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If you were desperate enough, you could read them in with UTL_FILE and pass the data over a database link to another oracle database at the far end that would write them back out using UTL_FILE, but I'd question your sanity if you tried it.
Re: pl/sql with ftp [message #406348 is a reply to message #406347] Wed, 03 June 2009 09:07 Go to previous message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Thanks All and i will get to you when its done. Smile
Previous Topic: xml indexes in 11g
Next Topic: print in one line or in one variable
Goto Forum:
  


Current Time: Thu Feb 13 14:13:57 CST 2025