10 Replies Latest reply on Aug 10, 2017 6:22 AM by Hari Selva

    How to consume JMS message and write on to DB using OSB?

    Hari Selva

      Hi Experts,

       

      I have a requirement to consume JMS message and write it on to the DB table.  Stored Proc on the DB which receives the XMLType element, it responsible for reading the XMLType input and write on to the DB.

       

      My requirement is to consume the JMS messages, convert it to xml and calls the DB Adapter at the business layer.

       

      Currently, I have pipeline pair and  RouteNode with Routing flow. Please help me to proceed further. I dont know how to convert the JMS message to XML in OSB.

       

      Please advise.

       

      Here is the PKG Spec:

      CREATE OR REPLACE PACKAGE PACKAGENAME_PKG AS

      PROCEDURE PROCNAME_PROC (XML_DATA IN XMLTYPE);

      END PACKAGENAME_PKG;

       

      Please advise.

       

      Thanks