Wednesday, July 19, 2023

OIC - How to access Database sequence value in Oracle Integration

Usecase: Here, I will show you how to get the database sequence value in Oracle Integration.

Logic steps: 

  • Create a sequence as required in the database.
  • Create a database connection
  • In the integration canvas , drag and drop the db adapter and configure as follow:
    • Choose operation as "Run a SQL Statment"
    • Provide sql query as select OIC_USER."Invoice_SEQ".nextval from dual and validate

Implementation steps with screenshots:

For create sequence , you can follow below blog:

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...