> 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
resultset
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
EXEC.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com