Publish date: 2009-12-15

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:


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:


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.

Publish date: 2009-12-15. Copyright: IBProvider. This material may be reproduced on other web sites, without written permission but link required.