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

OIC - How to Retrieve Email Attachments Using Microsoft Graph API: Automating Payment File Processing

Retrieving Email Attachments Using Microsoft Graph API: Automating Payment File Storage in Object Storage Use Case: A finance team needs t...