Subject Re: Stored Procedures
Author Roman Rokytskyy
Hi,

> The documentation / FAQ seem to indicate this is not supported yet.
>
> Also if it is not supported yet around about how long until it will
> be supported ?

We do not fully support escaped syntax for procedure calls (output
parameters are not supported). However if you use native Firebird
syntax, stored procedures are fully supported.

Native Firebird syntax:

EXECUTE PROCEDURE proc_name(?, ?, ?, ...) for executable procedures;
SELECT * FROM proc_name(?, ?, ...) for selectable procedures.

{call proc_name(?, ?, ...)} is translated into EXECUTE PROCEDURE
proc_name(?, ?, ?, ...) without any analysis. This means that:

a) it is not usable for selectable stored procedures;
b) positions of output params are independend from input params (in
JDBC they're not) and start with 1.

When you use native syntax, stored procedures can be called both from
PreparedStatement and from CallableStatement, in case of escaped
syntax - only from CallableStatement.

Best regards,
Roman Rokytskyy