TYPES.CURSORTYPE DECLARATION ERROR

From: ggarrison <ggarrisonsr_at_hotmail.com>
Date: Thu, 24 Jun 1999 21:02:34 -0800
Message-ID: <930286956.4038@www.remarq.com>

Using PO8. This function does not compile and raises the following 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

I'm assuming there is a problem with the scope of the dbms_output package.

Any ideas - thanks in advance

Received on Fri Jun 25 1999 - 00:02:34 CDT