Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need Help with Cursors
>Subject: Need Help with Cursors
>From: Michelle Warner <delonda_at_radium.ncsc.mil>
>Date: 2/10/98 7:34PM GMT
>Message-id: <34E0ABAC.E00640F_at_radium.ncsc.mil>
>
>I have a CURSOR inside a procedure and I am receiving compilation errors
>for the table I am trying to query from. The error is that the table
>(identifier) is not declared. The structure of the procedure is similar
>to this:
>
>create or replace procedure name (input IN varchar2)
>IS
>
>CURSOR c1 IS
>SELECT col1
>FROM table
>WHERE col1 = input;
>
>BEGIN
>.....
>END;
>
>I can get to this table from within sqlplus so I am guessing that it is
>in my schema/scope.
>However, the table is not owned by me.
>
>Thanks in advance.
>
>Michelle Warner
>
>
>
>
>
>
>
>
It looks as though your access to the table is granted via a role.
Unfortunately stored procedures/functions/packages do not recognise privileges
granted to roles, you need the privilege specifically granted to the owner of
the stored procedure etc.
HTH
Rob
Received on Tue Feb 10 1998 - 00:00:00 CST