Re: Need Help with Cursors

Is your grant to the table via a role ? If so get the owner to provide a direct grant to you.

Ken F.

Michelle Warner <delonda_at_radium.ncsc.mil> wrote in article <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
>
>
Received on Tue Feb 10 1998 - 00:00:00 CST