1 Reply Latest reply: Jul 4, 2007 8:15 AM by Marcelinho-Oracle RSS

    Error while Rule Creation

      I am getting two issues while creating the sql script as well as rule creations...

      1) I am trying to create a table and insert the tag id on this whoes event.type is 200. while executing the script @rfid.sql I am getting this error

      SQL> @rfid.sql

      Table created.


      and it is getting hanged at 8.

      2) I am trying to execute the a sql script which is "call edg_utl.add_rule('collect',':event.type=200',NULL,NULL,'rfid','call');"

      While executing this command I am getting this error.
      SQL> call edg_utl.add_rule('collect',':event.type=200',NULL,NULL,'rfid','call');

      call edg_utl.add_rule('collect',':event.type=200',NULL,NULL,'rfid','call')
      ERROR at line 1:
      ORA-24172: rule set EDGE.EDG_RULESET has errors
      ORA-06512: at "SYS.DBMS_RULE_ADM", line 179
      ORA-06512: at "EDGE.EDG_UTL", line 117
      ORA-06512: at "EDGE.EDG_UTL", line 68
      ORA-06512: at line 1

      I have installed the sds and sdr during the oses installation.

      Any suggestion on the problem will be great help.

      Thanks and regards