Subject Re: Re[2]: [Firebird-Architect] RFC: Please unify stored procedure execution
Author Martijn Tonies
> > In IB/Fb, there is only 1 type of call to a procedure. But, in Java
> > when you "call" a procedure, it can be a procedure on any database
> > 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
> columns ? ;-)
> > To convert this generic Java-calling mechanism to Firebird, you should
> > 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
> > 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 ;)

Indeed, it isn't. It's probably also an ADO driver problem, .NET driver
problem and a SQL specification problem.

Just because you can work it out doesn't mean everyone else can.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions