Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Need Help with Cursors
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