PL/SQL & Recordsets

You can use PL/SQL functions in SQL statements and you can return recordsets with PL/SQL. Is there any way to combine the two in the FROM clause of a SQL statement?
function foo(a in number);
select *
from table1, foo(3)
where table1.field1 = foo.field1
Thanks.Hello,

use unnested collection types to create a nested table and a view that accesses the unnested collection types.

Then you can use the view to access your function.

If you need more help see the docu or contact me at www.alligatorsql.com

Hope that helps ?

Manfred Peter
(Alligator Company GmbH)
http://www.alligatorsql.com