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