Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle pipelined table function table row type query

Oracle pipelined table function table row type query

From: Barry Bulsara <bbulsara23_at_hotmail.com>
Date: 13 May 2007 06:51:21 -0700
Message-ID: <1179064281.880920.89590@p77g2000hsh.googlegroups.com>

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 Received on Sun May 13 2007 - 08:51:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US