Re: PL/SQL access from c++ like accessing a table

On Fri, 18 Jun 2004 14:21:11 +0200, "Moritz Klein" <mklein_at_students.uni-mainz.de> wrote:

>Is it possible to to something like "select * from procedure_x(var1,var2)"
>and get a result-set similar to doing "select * from table_x"?

 Yes, with a small change to syntax. Look up "pipelined table functions", which were new in 9i, from which you'll be able to use:

    select * from table(your_function(var1,var2))

--
Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool
http://www.andyh.co.uk         / http://www.andyhsoftware.co.uk/space