Re: Oracle AQ, problems defining dbms_aq.enqueue_options_t

"Andy Hassall" <andy_at_andyh.co.uk> wrote in message news:e5778157e3fp9ug16dujd2dlqu2g25e0bf_at_4ax.com...
> On Thu, 12 May 2005 18:19:46 +0200, "Sindre Idsal" <sindre_at_idsal.no>
> wrote:
>
>>I'm trying to learn how to use Oracle Advanced Queuing. And at the moment
>>I'm using Oracle 9.2.0.1
>>I'm writing a simple PL/SQL stored procedure that is supposed to send a
>>message to a message queue and the beginning of the code goes like this:
>>....
>> enqueue_options dbms_aq.enqueue_options_t;
>>......
>>When compiling the procedure I get messages indicating that this
>>"dbms_aq.enqueue_options_t" is not understood.
>>Can anyone tell me what is wrong here ? Is "enqueue_options_t" supposed to
>>be a type belonging to package dbms_aq ? -- Or is there something missing
>>in my Oracle installation ?
>
> (All together now...) privileges held by a user through roles are not
> available from definer-rights stored procedures, so the typical solution
> is to
> grant the privilege (i.e. execute on dbms_aq) directly to the user owning
> the
> stored procedure.
>
> --
> Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
> <http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool

Hello
I'm a little late responding to your help-- sorry. But anyway -- granting execute on dbms_aq solved the problem. Thanks for helping me

Regards Sindre Idsal Received on Fri Jun 10 2005 - 10:26:50 CDT