SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Download a file from ftp

544866Dec 12 2006 — edited Dec 12 2006

Hi,
I have to update a file everyday.For that I download that file from our ftp server and then I run that file(this file is basically a insert script) as a script on sql prompt.
Now I want to automate this whole work.So may I know how to download a file from ftp server,and open it through EDIT PLUS and then run it on sql prompt.
Plz telme the solution.
Thanks,
Ritesh

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 9 2007

Added on Dec 12 2006

5 comments

640 views