cast question

From: Ed Zappulla <zappullae_at_rcn.com>
Date: Fri, 5 Feb 1999 08:10:21 -0500
Message-ID: <79eqh7$35f$1@winter.news.rcn.net>

Can anyone tell me what is wrong with the following code? note vendor is a table with a key vend_id numbe

SQLWKS> declare
     2>  type x is table of number;
     3>  z x;
     4>
     5>  y number := 0;
     6> begin
     7>  z := x();
     8>  z.extend();
     9>  z(1) := 1;
    10>
    11>  select vend_id into y from THE(select cast(z as x) from dual) a;
    12>
    13> end;
    14>
 select vend_id into y from THE(select cast(z as x) from dual) a;
                                                               *
ORA-06550: line 11, column 50:

PLS-00382: expression is of wrong type
ORA-06550: line 11, column 2:
PL/SQL: SQL Statement ignored Received on Fri Feb 05 1999 - 07:10:21 CST