Sunday, March 6, 2022

OIC - How to read file size up to 1 GB in oracle integratio

By default, we can only read 10 MB file. To read a file size upto 1GB file we have to follow the below steps:


  1. List the files using FTP connection
  2. Loop the list of files using For Each action
  3. Download the each file into a stage (VFS) location.
  4. Read file records in chunk using read in segments. Each record contains 200 records.
  5. Read the file using a sample csv file format.


List files using FTP connection

Download the file using FTP connection

Take a For each and loop each file

Map each file from list response to download request

Read file in segments

No comments:

Post a Comment

Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...