[Wsf-general] Data service - Stored Procedures

[Sanjiva Weerawarana]

James Clark wrote:
> On Thu, 2007-03-01 at 06:36 -0500, Diluka Moratuwage wrote:
>> Hi all,
>>
>>   When considering the extensibility of the dataservice, we can
>> also think of including the support for stored procedures. If
>> we use stored procedurs, for complex queries, as well as for services
>> that include, multiple types of sql statements it would become a
>> good solution.
> 
> Can't queries and other SQL statements call out to stored procedures?

I think you can but then that call becomes part of the query and not part 
of the result AFAIK.

> I'm not seeing that we need to do anything special in the config file to
> support stored procedures.

I think we probably will need some syntax to help users say just invoke 
this SP and take the results and send it back.

However, I'd like to keep focused on getting queries supported just right 
(including with the real REST binding) and then start thinking about how 
to do SPs.

Sanjiva.
-- 
Sanjiva Weerawarana, Ph.D.
Founder, Chairman & CEO; WSO2, Inc.; http://www.wso2.com/
email: sanjiva at wso2.com; cell: +94 77 787 6880; fax: +1 509 691 2000

"Oxygenating the Web Service Platform."