Re: ORA-01031: insufficient privileges when open a Cursor

From: John Hurley <>
Date: Wed, 30 Sep 2009 14:02:35 -0700 (PDT)
Message-ID: <>

On Sep 30, 4:15 pm, valigula <> wrote:


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

Original text of this message