Hello, Martijn!

Tuesday, December 21, 2004, 1:02:17 PM, you wrote:

>> RR> a) provide a new SQL statement, for example CALL, that when applied to
>>
>> for what?

MT> Did you read the proposal?

message I've replied has not proposal. there was request to unify
SP call.

MT> Java uses a generic syntax to call stored procedures, the driver translates
MT> this to a call for the actual database engine and it should return a
MT> resultset if there's more than 1 row.

nice.

MT> if there's more than 1 row. With Firebird, you don't know IF this actually
MT> happens because you don't know if you should call it with SELECT or
MT> EXEC.

There is only one call type of stored procedures. EXECUTE PROCEDURE.

SELECT * from StoredProc is not a "stored procedure call". It is
a select statement that uses output from stored procedure to return
it as a result set. Ability to select from SP is just IB/FB feature,
and feature of SELECT statement.

--
Dmitri Kouzmenko