store procedure

Started by Juanabout 25 years ago2 messagesgeneral
Jump to latest
#1Juan
jcorta@tribctas.gba.gov.ar

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

#2Joel Burton
jburton@scw.org
In reply to: Juan (#1)
Re: store procedure

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