Re: Why cannot perform select * within a proc

Thanks for the input but still having a problem with scope I believe. The following is a function and the errors:

FUNCTION PO8.F_TESTSELECT RETURN types.cursortype as

l_cursor types.cursorType;
begin
open l_cursor for select ename, empno from emp order by ename;
return l_cursor;
end;

PLS-00201: identifier 'TYPES.CURSORTYPE' must be declared PL/SQL: Compilation unit analysis terminated

Thanks again

• Posted from RemarQ - http://www.remarq.com - Discussions Start Here (tm) ****