Database Software

Hi,

I am trying to create a event based job as below. It is giving ORA-24172 error. I did some googling and searched the documentation but not able to figure out the cause for this error. Please help.



begin
dbms_aqadm.create_queue_table(queue_table=>'scheduler_queue_table',
queue_payload_type=>'EVT_QTYPE',
multiple_consumers=>true);
end;
/

begin
dbms_aqadm.create_queue(queue_name=>'scheduler_queue',
queue_table=>'scheduler_queue_table', retention_time=>0);
dbms_aqadm.start_queue('scheduler_queue');
end;
/

begin
dbms_scheduler.create_program(program_name=>'read_scheduler_queue',
program_type=>'STORED_PROCEDURE',
program_action=>'pkg_scheduler.start_process_chain',
number_of_arguments => 1);
end;
/

BEGIN
DBMS_SCHEDULER.DEFINE_METADATA_ARGUMENT(
program_name =>'read_scheduler_queue',
argument_position => 1,
metadata_attribute => 'EVENT_MESSAGE'
);
END;
/

begin
dbms_scheduler.create_job('read_scheduler_queue_job',
program_name=>'read_scheduler_queue',
event_condition=>'tab.user_data.event_name = ''FILE_ARRIVAL'' OR tab.user_data.event_name = ''REWORK_REQUEST''',
queue_spec=>'SCHEDULER_QUEUE');
end;
/

12:34:01 SQL Command:>begin
12:34:04 2 dbms_scheduler.enable('read_scheduler_queue');
12:34:04 3 dbms_scheduler.enable('read_scheduler_queue_job');
12:34:04 4 end;
12:34:04 5 /
begin
*
ERROR at line 1:
ORA-24172: rule set . has errors
ORA-06512: at "SYS.DBMS_ISCHED", line 2751
ORA-06512: at "SYS.DBMS_SCHEDULER", line 1794
ORA-06512: at line 3