Forum Stats

  • 3,769,708 Users
  • 2,253,013 Discussions
  • 7,875,157 Comments

Discussions

Problem with reschedule procedure for queues

rootsman
rootsman Member Posts: 233 Bronze Badge

Guys,

We are trying to create reschedule procedure for our AQ queues with condition like if there are more then 30 or more messages on wait. Our main problem is that we cannot pass parameter well (queue name) so we hit a wall on this part:

DECLARE

P_QUEUE         VARCHAR2 (100);

Piece of code which is problem

P_QUEUE :=trim('AQADMIN.')||trim(flatRec.ime);

                       

                BEGIN

                    SYS.DBMS_AQADM.STOP_QUEUE ( QUEUE_NAME => ''''||P_QUEUE||'''');

                END;

And message is

ORA-24000: invalid value 'AQADMIN.TRAN_FLATANN_S_QUEUE', QUEUE_NAME should be of the form [SCHEMA.]NAME

Where is syntax problem? We tried to put several combinations there but all of them raise above error.

Please advice