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

Error while Rule Creation

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

8

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
Nasim