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

From: valigula <valigula_at_gmail.com>
Date: Thu, 1 Oct 2009 02:48:53 -0700 (PDT)
Message-ID: <c3abbd8f-46ff-4b6c-b43b-149a80914c02_at_w36g2000yqm.googlegroups.com>

On Sep 30, 11:02 pm, John Hurley <johnbhur..._at_sbcglobal.net> wrote:
> 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?

Thanks, it was an issue with the rights, i am migrating some schemas from on one our databases into development and did not set the user rights correctly.

Thanks Received on Thu Oct 01 2009 - 04:48:53 CDT