I am using the DeriveParameters method to obtain and cache the parameter information for stored procedures.
Given the following portion of a stored proc def
CREATE PROCEDURE AddStore (out :ID integer, in :StoreName char(50),
in :Mall char(20), in :StoreNumber smallint, in :Region tinyint,
in :District smallint, in :StoreStatus utinyint, out :ObjectID uniqueidentifier)
DeriveParameters returns the following information:
:ID Input VarChar String:StoreName Input Char StringFixedLength:Mall Input Numeric Decimal:StoreNumber Input Decimal Decimal:Region Input Integer Int32:District Input VarChar String:StoreStatus Input VarChar String:ObjectID Input VarChar String As you can see, ID and ObjectID fields should be OUTPUT parameters, not INPUT. In addition, the PsqlDbType is incorrect in almost every case.
As it stands, this function is useless for anything except getting the parameter names in the correct order.
Any ideas?