The answer to your question is YES and NO. Yes because you can do a
select from a procedure and No because you do have to specify the
paramaters when creating the procedure and select into those
parameters in order to return something. You can't just do a straight
select and have it come back like in SQL Server. Doing this also
limits you to 1 result set per stored procedure.

Are there any plans to add the ability to run straight selects in
stored procs and have them return rather than having to populate
parameters?

Giulio

--- In firebird-support@yahoogroups.com, Wayne Barker <wayne@c...> wrote:
> In Interbase \ Firebird is it possible to write a Stored Proc that
can return a result set - like in SQL Server or can Interbase \
Firebird only return Output parameters and return codes?
>
> The utility that i am using to manipulate the Database only allows
me to return output params and return error codes - That is why i am
asking.