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: 65084
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: Sat Jul 22 15:50:55 CDT 2017

Total time taken to generate the page: 0.04302 seconds