Hello, Roman!

Tuesday, December 21, 2004, 2:14:00 PM, you wrote:

RR> Wrong. Programmer writes following code:

RR> CallableStatement stmt = connection.prepareCall(sql);

RR> stmt.registerOutParameter(2, Types.INTEGER);
RR> stmt.setInt(1, 1);
RR> boolean hasResultSet = stmt.execute();

RR> At this point me, as driver developer, has to decide whether to use
RR> SELECT * FROM or EXECUTE PROCEDURE. How?

by procedure code. This code have nothing about what you call - pure
select, update, delete or execute. You can execute anything (and DDL
too). You can write select from proc or execute procedure proc. This is yours,
database developer, decision. Based on - procedure output params
existance and suspend inside procedure code.

--
Dmitri Kouzmenko, www.ibase.ru, (095) 953-13-34