12 Replies Latest reply on Aug 24, 2014 3:28 AM by Hari Selva

    what is the best way to read database iteratively?

    Hari Selva

      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.