Re: Returning resultset from stored procedure

You can create a view in wich the select clause contains a column that is the
result of your function,

eg. : Create View functionresult (res) as select yourfunction from sys.dual;

afterwards you can perform a select in your client on that view,

eg.: Select res from functionresult;

yitbsal_at_statcan.ca heeft geschreven in bericht <75egta$jo6$1_at_nnrp1.dejanews.com>...
>Hi,
>
>I would like to be able to create a stored procedure that does one 'select'
>statement and returns the resultset via an OUT parameter to the calling
>function (say, a VB or Delphi) program. I would like the VB or Delphi
 client
>to receive the data in a resultset, in the same way that it would by
 running
>the SQL query itself. Is this possible?
>
>From what I understand, I can't use the table datatype, because it can only
>contain one column. Of course, I can use several tables, but then it would
>be messy for the client software.
>
>Why do I want to do this? Essentially, I would like the client to be able
 to
>call stored procedures to return data instead of bothering with the SQL
>itself. These stored procedures would consist of small bits of code and an
>SQL query.
>
>Thanks,
>Salaam Yitbarek
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Dec 18 1998 - 00:00:00 CST