Home » SQL & PL/SQL » SQL & PL/SQL » Showing "Insufficient Privileges" while executing DBMS_AQL.LISTEN (Oracle 10g - - Unix)
Showing "Insufficient Privileges" while executing DBMS_AQL.LISTEN [message #277150] Mon, 29 October 2007 02:10 Go to next message
Messages: 28
Registered: October 2007
Location: Kolkata
Junior Member
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.

agent_list => l_agent_list
, wait => dbms_aq.forever
, agent => l_agent

Lastly it throws following error:

ORA-01031: insufficient privileges

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: 63912
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).

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

Current Time: Sun Oct 23 17:56:48 CDT 2016

Total time taken to generate the page: 0.09397 seconds