Re: REF CURSOR returning a PL/SQL Table.

Galen

When you use the TABLE expression to CAST a result set, you need to use an alias:-

Instead of:-

    query := 'select * from TABLE ( cast (l_data as groupSize3Array ))';

Try:-

    query := 'select t.* from TABLE ( cast (l_data as groupSize3Array )) t';

Also, the groupSize3Array MUST be created on the database and not be a PL/SQL declared type for the CAST expression to work.

HTH Adrian Received on Tue Feb 05 2002 - 02:37:42 CST