Home » SQL & PL/SQL » SQL & PL/SQL » Showing "Insufficient Privileges" while executing DBMS_AQL.LISTEN (Oracle 10g - 10.2.0.1.0 - Unix)
Showing "Insufficient Privileges" while executing DBMS_AQL.LISTEN [message #277150] Mon, 29 October 2007 02:10 Go to next message
k_mitra100
Messages: 28
Registered: October 2007
Location: Kolkata
Junior Member
hi,
I am executing DBMS_AQ.LISTEN procdure from a package placed in a text index schema.

DBMS_AQ.LISTEN accepts arguments as follows :
1. l_agent_list(1) := sys.aq$_agent( LOWER( USER ),c_queue_name,NULL );
2. dbms_aq.forever

It hanged for a long period on the following line of code.

dbms_aq.listen
(
agent_list => l_agent_list
, wait => dbms_aq.forever
, agent => l_agent
);


Lastly it throws following error:

dbms_utility.format_error_stack():
ORA-01031: insufficient privileges

dbms_utility.format_error_backtrace():
ORA-06512: at "SYS.DBMS_AQ", line 577


Can anyone pls help me out ?
Re: Showing "Insufficient Privileges" while executing DBMS_AQL.LISTEN [message #277156 is a reply to message #277150] Mon, 29 October 2007 02:14 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use SQL*Plus and copy and paste what you have.

In addition, read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Always post your Oracle version (4 decimals).

Regards
Michel
Previous Topic: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Next Topic: query
Goto Forum:
  


Current Time: Fri Dec 09 21:08:50 CST 2016

Total time taken to generate the page: 0.06044 seconds