Subject Re: Re[4]: [Firebird-Architect] RFC: Please unify stored procedure execution
Author Martijn Tonies
Hello Dmitry,

> Tuesday, December 21, 2004, 3:49:23 PM, you wrote:
> MT> Because there's no way to KNOW if a procedure is select-able. Is it?
> Martin, what problems will we have if we say that IB/FB can not
> return result set from procedures? I mean, from standard EXEC PROC?
> How this will affect Java applications, J2EE and so on?
> It is not hard to comment, that if Java developer want to get
> resultset from procedure, he just need to make simple select
> statement instead of direct procedure call.

Although that's a whole different story...

I guess it depends on the application. If this is a simple port of
one application to another database engine, it might remove the
"generics" that Java provides with JDBC ( this is why Roman
wants to implement it transparently anyway ).

It's not that it matters IF Fb can return a resultset, there simply
should be a way to KNOW if there's a resultset.

Currently, you don't.

With regards,

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