Hi,

> Sure, I'm familiar with with select procedures, e.g. the following procedure will return a result set.
> (...)
> The other type of procedure returns a single value/row and is called with EXECUTE
>
> From what I can gather, SQL Server and MySQL offers a combination of both in the same procedure.

I don't see this possibility in MySQL.

> So my question is, is this possible with firebird?

No. If you want to return a (possibly multi-row) output set *and* a single value, you have create a selectable SP with an extra output parameter for the single return value. Of course, this "single" value will then be repeated as many times as there are rows - and if the output set has zero rows, it won't be returned at all.


Hope this helps,
Paul Vinkenoog