Re: Using bulk collect with union-statement

On 2005-07-25, lemmchen <lemmi.lemmchen_at_gmx.net> wrote:
> Hello,
>
> I have stored procedure with a statement like this:
>
> TYPE mylist IS TABLE OF table%ROWTYPE;
> enums mylist ;
>
> select name from table
> where ...
> union
> select name from table
> where ..
>
> I want to put result using BULK COLLECT INTO
> into enums -collection. But when try this with my union-statement,
> always a get an error.

And the error is....?

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/