DBMS_AQ.dequeue via dbms_scheduler
hi
found strange problem
till Oracle 19.3 all working fine after installing patch 19.11.0.0.210420
have a problem with run DBMS_AQ.dequeue via dbms_scheduler job .
for example create the job with folowing script:
begin
dbms_scheduler.create_program
(
program_name=>'test_process',
program_action=>'test_daemon.daemon',
program_type=>'STORED_PROCEDURE',
number_of_arguments=>1, enabled=>FALSE
) ;
dbms_scheduler.DEFINE_PROGRAM_ARGUMENT(
program_name=>'test_process',
argument_position=>1,
argument_type=>'NUMBER',
DEFAULT_VALUE=>1);
dbms_scheduler.enable('test_process');
end;
/
run via job the following:
DBMS_AQ.dequeue(queue_name => own || '.TEST_QUEUE',
dequeue_options => l_dequeue_options,
message_properties => l_message_properties,