|Subject||Re: Re: [Firebird-Architect] RFC: Please unify stored procedure execution|
> > In IB/Fb, there is only 1 type of call to a procedure. But, in Javaspeak,
> > when you "call" a procedure, it can be a procedure on any databaseengine.
> > Next, this procedure can return output parameters OR it can return adifferent
> > 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 ? ;-)use
> > To convert this generic Java-calling mechanism to Firebird, you should
> > either EXEC or SELECT (when you want to return a resultset). The problemresultset.
> > is, that with Firebird, you cannot really know if it returns a
> > That isIndeed, it isn't. It's probably also an ADO driver problem, .NET driver
> > 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 ;)
problem and a SQL specification problem.
Just because you can work it out doesn't mean everyone else can.
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL