How do I use stored procedures with JayBird?
Jaybird does 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 independent of 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. Examples The following example is a stripped-down version of code taken from the project source code tests in the directory: client-java/src/test/org/firebirdsql/jdbc/TestFBCallableStatement.java It cr
