Re: Selecting nvarchar2 from a table function results in ORA-12714

Bobsparks_at_excite.com wrote:
> Here is concise test case it shows that while the function works from
> the sql prompt it cannot be compiled into a procedure once the type has
> a nvarchar2

Seems to me, from your example, it doesn't work as a VARCHAR2 either. Why are you making a point of NVARCHAR2?

The error message returned is:
2/1 PLS-00201: identifier 'TYPES.CURSORTYPE' must be declared

Seems like that indicates a direction to go.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)