ORA-01031: insufficient privileges when open a Cursor

From: valigula <valigula_at_gmail.com>
Date: Wed, 30 Sep 2009 08:58:17 -0700 (PDT)
Message-ID: <a0314a2e-c108-4ab4-93c3-aa7d1fb9751b_at_g23g2000yqh.googlegroups.com>

Hi all,

I am facgin an issue when trying to run a procedure inside a package. The procedure goes to the exception when get to the open cursor command. I am able to debug the procedure and seems that all the rights are correctly set.
BTW this is a Oracle 9i.

SQL> show parameter cursors;

NAME                                 TYPE        VALUE

------------------------------------ -----------
open_cursors integer 250 session_cached_cursors integer 0

Thanks in advance Received on Wed Sep 30 2009 - 10:58:17 CDT

Original text of this message