Subject | Re: Re[2]: [Firebird-Architect] RFC: Please unify stored procedure execution |
---|---|
Author | Vlad Horsun |
Post date | 2004-12-21T13:21:43Z |
> Because there's no way to KNOW if a procedure is select-able. Is it?There is way - existence of outputs.
> As far as I can tell, a procedure without "suspend" never returns values.This is IB\FB feature. Other servers has its own features.
> So using "select" when there are output parameters is not sufficient.
> Using EXEC that would return a resultset (if available) would be veryWhat if resultset is not availaible ?
> easy to use... IMO of course.
Roman propose always return resultset, even if SP has no SUSPEND.
But this can break existing applications. Therefore there are another
proposition -
use new special syntax for such call's. Ok... what else from JDBC\ADO\OLEDB\etc
don't fit in FB's SQL dialect ? Will we make new syntax for every new client
access
layer ?
If JDBC will follow simple rule about how to call our SP's and documented
it i see no problem, sorry.
Regards,
Vlad