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,
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