I am using the stream dispatcher, and able to execute the sql procedure and also able to create the rule but could not able to received the data....
I have written the sql procedure as
CREATE TABLE rfid(tagid varchar2(128));
CREATE OR REPLACE PROCEDURE event_process(ev IN EDGE.EDG_EVENT) IS
INSERT INTO rfid values(ev.id);
able to create the rule.... but not getting any data on the table...
Kindly let me know if you have any idea on the same....
In my Database i have received a error saying
STREAMS Warning: received error ORA-26663 while dropping apply EDG_APPLY for the queue "EDGE"."EDG_EVENT_Q". Please run dbms_apply_adm.drop_apply manually.