HOWTO: STORED PROCEDURE RETURNING MANY ROWS

I look for a way to write a stored procedure, that returns more than 1 "row"s.

I want to do something like

select MyProc('A','B','C') from dual;

and get

ID TEXT
1 1stRow
2 2ndRow
3 3rdRow
.
999 999thRow

and so on.

If Possible it would be nice to do something like

select * from MyProc('A','B','C')

or

select * from MyProc('A','B','C') X
join MyTable Y on X.ID=Y.ID

Is there a way? (Oracle 9/11)

-- 
wenn email, dann AndreasMosmann <bei> web <punkt> de