1 Reply Latest reply: Jul 4, 2007 7:54 AM by Marcelinho RSS

    data population thru rule....

    568547
      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
          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