Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Oracle pipelined table function table row type query
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 toSCOTT.TEST1 Received on Sun May 13 2007 - 08:51:21 CDT
![]() |
![]() |