This discussion is archived
1 Reply Latest reply: Jul 4, 2007 5:54 AM by Marcelinho RSS

data population thru rule....

568547 Newbie
Currently Being Moderated
I have created the sql script and also written and called the rule it is not giving any error but after passing the data also I am not able receive any data... kindly suggest

My sql procedure is
The sql script is

name of the sql is rfid.sql

CREATE TABLE rfid(tagid varchar2(128));
CREATE OR REPLACE PROCEDURE event_process(ev IN EDGE.EDG_EVENT) IS
BEGIN
INSERT INTO rfid values(ev.id);
COMMIT;
END event_process;


/

MY rule is


call edg_utl.add_rule('test1',':event.type=200',NULL,NULL,'rfid','call');


kindly suggest any idea....
  • 1. Re: data population thru rule....
    Marcelinho Newbie
    Currently Being Moderated
    The name of your callback procedure is missing in add_rule!

    Here´s a sample:

    edg_utl.add_rule(ruleName => 'MyRule', condition => ':event.type = 200', param => 'edg_utl.testProc', command => 'call');

    Look at the README in the edge server dir: ..\j2ee\home\applications\edge\edge\sample\StreamsSample