> > 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 ;)

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
Server
Upscene Productions
http://www.upscene.com