This discussion is archived
1 Reply Latest reply: Dec 12, 2012 12:38 AM by FrançoisDegrelle RSS

i have create a stored procedure based on event

969443 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points