Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Posts
    12

    Red face Unanswered: Problem while executing DBMS_AQ.LISTEN

    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 ?
    kaushik mitra

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Privs acquired via ROLE do NOT apply within PL/SQL procedures.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2004
    Posts
    12
    Thanks anacedent,
    But I have already given execute privilige separately on dbms_aq package to public. Still it shows same error.
    kaushik mitra

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    > I have already given execute privilige separately on dbms_aq package

    But the error you posted is NOT on that package.

    You should continue to GRANT RISE on EAST to SUN.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jan 2004
    Posts
    12

    Reply

    t shows the following error message while executing DBMS_AQ package.

    ORA-01031: insufficient privileges

    It shows that error occured at DBMS_AQ package line no 577.

    Can any one tell me about the content of that line. I am unable to explore that. Or to which object I have to give which privilege ?

    Regds,
    Kaushik.
    Last edited by k_mitra100; 10-31-07 at 02:27.
    kaushik mitra

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •