Subject Re: [Firebird-Architect] Re: RFC: Please unify stored procedure execution
Author Dmitry Yemanov
"Roman Rokytskyy" <rrokytskyy@...> wrote:
> This is not specified. I suspect that API for Oracle or MS SQL is
> different. As a hint, if I know correctly, there is no SELECT * FROM
> in Oracle - all procedures are called with CALL.

Table expressions:

select * from table ( my_function )

where my_function is a PL/SQL function returning a nested table or an array.

Perhaps not exactly what we have in our selectable procedures, but something