Re: ORA-01031: insufficient privileges when open a Cursor
Date: Wed, 30 Sep 2009 14:02:35 -0700 (PDT)
Message-ID: <4bf65735-e9e2-42ef-8e4a-df43a93c93c0_at_d10g2000yqh.googlegroups.com>
On Sep 30, 4:15 pm, valigula <valig..._at_gmail.com> wrote:
snip
> > >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.
> Thanks for your time, but actually I can execute the procedure, and
> even debug it. Also i can execute the procedure as a script with no
> problem. Or in another database and it works.
>
> Never seem that behaviour before so i wanted it to share it. So we all
> can learn.
So you can run it standalone as a procedure but it is failing inside a package?
What are the differences in ownership between the 2 versions? Received on Wed Sep 30 2009 - 16:02:35 CDT