|
Hi all.
I am using the package dbms_aq in
a pl/sql program and it's working fine but when i
changed the same program into a trigger
it's showing the error
PLS-00201: identifier 'SYS.DBMS_AQ' must be
declared.
I have granted execute permission
on dbms_aq to that user . Do i need to grant any more
permission at access
dbms_aq in a trigger .......??? If
so which privilege or role should i grant ??
Please help.............
Thanks in advance
regards,
shibu
Oracle DBA
Acusis - Bangalore
|
