Using bulk collect with union-statement

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.

How can I do this ?
Putting both statements together for eliminate union could be an option, but the "real" statement is very difficult and I have some similiar statements. With union the statement is more clear.

Thanks a lot. Received on Mon Jul 25 2005 - 09:30:27 CDT