Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Problem with reschedule procedure for queues

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