Thread: store procedure

hello list,
i´m new in stores procedure and i want to do one writed in pl/pqsl, that it
returns a table.
i´m accesing from odbc.

how the store procedure returns the table to process it in the programming
languaje(vb)? what type it returns?

can you send me an example.

thanks

Juan

On Mon, 9 Apr 2001, Juan wrote:

> hello list,
> i�m new in stores procedure and i want to do one writed in pl/pqsl, that it
> returns a table.
> i�m accesing from odbc.
>
> how the store procedure returns the table to process it in the programming
> languaje(vb)? what type it returns?

Juan --

At present, there is no reasonable way for a procedure to return a result
set (like a table).

Could you write a view that returns the data that you want?

--
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington