Thursday, October 17, 2019

12c OSB - Create business service using DB package and procedure

Drag and drop db adapter in external service
 Select the DB connection. If it is not created, create it using the pencil button.
 Select "call a Stored Procedure or function" option.
 Select the schema
 Select the package and procedure under that schema

 Right click on a folder⇾Service Bus⇾Generate Business Service
 Choose the created JCA  DB adapter

Click Finish

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