> In IB/Fb, there is only 1 type of call to a procedure. But, in Java speak,
> when you "call" a procedure, it can be a procedure on any database engine.
> Next, this procedure can return output parameters OR it can return a
> resultset. (eg: a MS SQL procedure). So, Java has a facility to return a
> resultset from a stored procedure call.

And MSSQL procedure can return both outputs and resultset. Does
Java has problem with it ? And how about multiply resultsets with different
columns ? ;-)

> To convert this generic Java-calling mechanism to Firebird, you should use
> either EXEC or SELECT (when you want to return a resultset). The problem
> is, that with Firebird, you cannot really know if it returns a resultset.
> That is
> the problem.

If SP has outputs - do SELECT else do EXECUTE. What is wrong with it ?
If SP has no SUSPEND - this is not a "generic Java-calling mechanism"
problem ;)

Regards,
Vlad