Re: Oracle pipelined table function table row type query

On 13 May 2007 06:51:21 -0700, Barry Bulsara <bbulsara23_at_hotmail.com> wrote:

>
>Hi all, 10.1EE on W2K. I am attempting to write a pipelined table
>function that returns a type typTest. I want typTest to be a row type
>of an existing table, not a new object definition, but I keep getting
>errors. Does anyone have any suggestions.
>
>Thank you
>Barry
>
>CREATE OR REPLACE TYPE typTest AS TABLE OF test1%ROWTYPE;
>/
>
>Errors for TYPE TYPTEST:
>
>LINE/COL ERROR
>--------
>-----------------------------------------------------------------
>0/0 PL/SQL: Compilation unit analysis terminated
>1/26 PLS-00329: schema-level type has illegal reference to
>SCOTT.TEST1
Upgrade to something supported.
Read doc 112680.1 on Metaclunk.

-- 
Sybrand Bakker
Senior Oracle DBA