1 Reply Latest reply: Dec 12, 2012 2:38 AM by François Degrelle RSS

    i have create a stored procedure based on event

    969443
      Hi All,

      Create a stored procedure for an event

      My event is EDN_PUBLISH_EVENT( NAMESPACE => NAMESPACE, LOCAL_NAME => LOCAL_NAME, PAYLOAD => PAYLOAD);
      I have tested for VM
      i got an error ------------>object SOAINFRA.EDN_PUBLISH_EVENT does not exist



      DECLARE
      NAMESPACE VARCHAR2(200);
      LOCAL_NAME VARCHAR2(200);
      PAYLOAD CLOB;
      BEGIN
      NAMESPACE := 'http://schemas.oracle.com/events/edl/Ordersevent';
      LOCAL_NAME := 'ordersevent';
      PAYLOAD := to_clob('xsd:element name="orders""
      xmlns:ob="http://schemas.oracle.com/events/edl/Ordersevent">
      <eb:name>ob:OrderEvent<or:orders
      xmlns:or="http://schemas.oracle.com/ws/2006/01/policy"
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
      <order_id>101</order_id>
      <cust_id>10001</cust_id>
      <order_date>10/06/12</order_date>
      <order_total>5000000</order_total>
      </or:orders></xsd:element>');
      EDN_PUBLISH_EVENT( NAMESPACE => NAMESPACE, LOCAL_NAME => LOCAL_NAME, PAYLOAD => PAYLOAD);
      END;
      /

      Regards,
      Vinay