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)..

When working with Firebird 2.1 и Firebird 2.5, you need to put in order the system tables of your database. See catalogue misc/upgrade/metadata with you installation of Firebird 2.1. When a problem with metadata is detected, the provider will generate an error with quite detailed description.

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.

Download IBProvider Professional Edition now!