PL/SQL (MOSC)

MOSC Banner

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center