We have improved PROCEDURES scheme loaders to obtain the text of stored procedures in PROCEDURE_DEFINITION

All DB servers are supported:

• InterBase: v4.x, v5.x, v6.x, v7.x, v8.x (2007), v9 (2009)
• Firebird: 0.9, 1.0, 1.5.x, 2.1.x, 2.5
• Yaffil

If you use Firebird 2.1, we recommend you to upgrade to FB 2.1.2 or above (see Bug Tracker, CORE-2008)..

Stored procedure call command «exec SP» was improved

Sample procedure:

CREATE PROCEDURE SP_TEST (A INTEGER=2)
 AS
  BEGIN
  ...
  END

In previous IBProvider versions exec SP_TEST command transformed to EXECUTE PROCEDURE SP_TEST (see property ado_exec_sp). Call of prepare() for this command worked fine but IN-parameters was not built.

In new IBProvider v3.0.0.8195 stored procedure call:

exec SP_TEST

will be transformed using IN-parameters list to the following sql-command:

EXECUTE PROCEDURE SP_TEST(?)

Exec SP restriction: Firebird 2.1 supports default-values for SP-parameters but didn’t supports SQL_DEFAULT type. Therefore IBProvider disable this feature and didn’t interact with default values of SP-params.