Thursday, October 5, 2023

OIC - Create a Reusable integration to pass Request Payload into Database table as clob type

Usecase: Here, we will create a reusable component or integration which will take any data XML or Json or etc as binary data and simply save as Text to database table as clob type.

Follow my below blog how to save XML or Json file into stage and then save the request payload into Database table as clob type.

Logic flow:

  1. Create a database table with payload column as clob type.
  2. Create a rest trigger and database connection.
  3. Create an app driven integration and configure the rest trigget and request payload format as binary.
  4. Configure the database table to insert the payload.
  5. Map the binary request payload to database payload using  decodebase64(encodeReferenceToBase64(Stream Reference) functions (Basically we are converting the stream reference to base64 data and then decode the base64 data).

Table create:



Payload CLOB,

Integration_Name VARCHAR2(100),

Integration_Identifier VARCHAR2(100));

Detailed steps with screenshots:

Integration flow:

Configure rest to pass binary data

Configure database to insert 

Map the stream ref to database table payload column.


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