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 v.3.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(?)

Åxec 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!