12 Replies Latest reply: Aug 23, 2014 10:28 PM by Harisudhan Selvaraj RSS

    what is the best way to read database iteratively?

    Harisudhan Selvaraj

      Hi All,


      I am new to Oracle 11g SOA Suite. I am looking for a steps on how to read the Database iteratively using BPEL process and write it on to a file using File Adapter.


      Here is the scenario: Look through all the values in ONLY ONE of the columns in the table for CURRENTDATE, get the entire record and pass it on File Adapter for write operation. I need to do it for all the records in the table which satisfies COLUMN VALUE = CURRENT DATE.


      Please advise.