Skip to Main Content

Oracle Database Discussions

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!

FTPing multiple files in Server using Unix

921311Jan 22 2014 — edited Jan 24 2014

Hi,

I have a scenario:

Firstly there was 1 file in the FTP server and that get loaded using SQL loader tables

There is a unix Shell Script where the Program to download the file from FTP Server to local using Fnd_Request.Submit_Request and then if its FTP successfully Submit Sql Loader Import concurrent runs and loads the data into interface table

Now there is requirement where there would be 2 files in the FTP Server..

How to process where there are 2 files in the Server and i have to FTP the 2 files and load into SQL lader same table

Any help will be needful for me

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 21 2014
Added on Jan 22 2014
26 comments
2,021 views