Subject Re: [Firebird-Architect] RFC: Please unify stored procedure execution
Author Martijn Tonies
> Tuesday, December 21, 2004, 1:07:48 AM, you wrote:
> RR> I see the need to unifying the way stored procedures are handled.
> I agree with Vlad, here is nothing to handle. I can call
> procedure with suspend as exec proc and as select * from proc,
> this is my decision and I rule SQL statements in my program.
> RR> a) provide a new SQL statement, for example CALL, that when applied to
> for what?

Did you read the proposal?

Java uses a generic syntax to call stored procedures, the driver translates
this to a call for the actual database engine and it should return a
if there's more than 1 row. With Firebird, you don't know IF this actually
happens because you don't know if you should call it with SELECT or

With regards,

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