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 -> Re: Oracle pipelined table function table row type query

Re: Oracle pipelined table function table row type query

From: <sybrandb_at_hccnet.nl>
Date: Sun, 13 May 2007 16:41:11 +0200
Message-ID: <6r8e4313oh3ocoku1q8g4fk773r1km0k7o@4ax.com>


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
Received on Sun May 13 2007 - 09:41:11 CDT

Original text of this message

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