As per METALINK doc LAD Addon Localizations R12 Integration Solution (Doc ID 960846.1)
SQL> DECLARE
2 lagent SYS.aq$_agent;
3 subscriber_exist EXCEPTION;
4 PRAGMA EXCEPTION_INIT (subscriber_exist, 24034)
5 ;
6 BEGIN
7 lagent := SYS.aq$_agent ('WF_BPEL_Q', NULL, 0);
8 DBMS_AQADM.add_subscriber (queue_name => 'APPS.WF_BPEL_Q',
9 subscriber => lagent,
rule => '1=1');
EXCEPTION
10 11 WHEN subscriber_exist THEN
12 13 just
14 add the rule if subscriber exists
15 DBMS_
16 AQADM.alter_subscriber (queue_name => 'APPS.WF_BPEL_Q',
17 subscriber => lagent,
18 rule => '1=1');
19 END;
20 /
lagent SYS.aq$_agent;
*
ERROR at line 2:
ORA-06550: line 2, column 22:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
:= . ( @ % ; not null range default character
Please suggest