Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SOA Fails to Pick Up Events Generated from EDN when using PL/SQL API

Saileshan Subhakaran-OracleAug 9 2016 — edited Aug 12 2016

Hi ,

while calling a event from PL/SQL API after using the below code..

still composite is not able to pick the event.

DECLARE
  NAMESPACE VARCHAR2(200);
  LOCAL_NAME VARCHAR2(200);
  PAYLOAD CLOB;
BEGIN
  NAMESPACE := 'http://schema.emerson.com/eth/events/edl/Event_TransactionSubmission';
  LOCAL_NAME := 'EMR240_TransactionSubmission1';
  PAYLOAD := to_clob('<business-event xmlns:ns1="http://schema.emerson.com/eth/events/edl/Event_TransactionSubmission" xmlns="http://oracle.com/fabric/businessEvent"><name>ns1:EMR240_TransactionSubmission1</name><content><ns0:TransactionSubmission1 xmlns:ns0="http://schema.emerson.com/eth/events"><ns0:tradingPartnerSystemID>nipunsuri</ns0:tradingPartnerSystemID></ns0:TransactionSubmission1></content></business-event>');
  DEV_SOAINFRA.edn_publish_event(NAMESPACE => NAMESPACE, LOCAL_NAME => LOCAL_NAME, PAYLOAD => PAYLOAD);
  commit;
END;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 9 2016
Added on Aug 9 2016
10 comments
1,291 views