"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
alike.


Dmitry