|Subject||Re: [Firebird-Architect] RFC: Please unify stored procedure execution|
> > Because there's no way to KNOW if a procedure is select-able. IsPlease use then example posted by Martijn - SELECT with procedure with
> > it?
> There is way - existence of outputs.
outputs without SUSPEND in its body. You get empty result set.
> Roman propose always return resultset, even if SP has noThe problem is that people have to change their applications to
> 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.
provide a hint to a driver to use SELECT.