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:
https://soalicious.blogspot.com/2020/06/database-create-sequence.html
No comments:
Post a Comment