[Firebird-net-provider] Using FBCommand and stored procedures

[Tony R. <Ton...@jf...>]

Using FB.NET provider 1.5.1517.216

=20

I have the following SP, what is the best way of calling it (Note code
is in Delphi, but any language will do)

=20

CREATE PROCEDURE TEST (

    ID_IN INTEGER)

RETURNS (

    ID_OUT INTEGER)

AS

BEGIN

  ID_OUT =3D  ID_IN + 1;

  SUSPEND;

END

=20

I have got..

  ac :=3D FbCommand.Create('EXECUTE PROCEDURE
TEST(@ID_IN,@ID_OUT)',adm.Connection);

  ac.Parameters.Add('@ID_IN',FbDBType.Integer,).Direction :=3D
ParameterDirection.Input;

  ac.Parameters.Add('@ID_OUT',FbDBType.Integer).Direction :=3D
ParameterDirection.Output;

  ac.Parameters[0].Value :=3D TObject(Int32(10));

  ac.ExecuteNonQuery;

=20

But I get the following at the executeNonQuery line...

=20

#####

=20

FirebirdSql.Data.Firebird.FbException :

Dynamic SQL Error

parameter mismatch for procedure TEST

=20

  ----> FirebirdSql.Data.Firebird.Gds.GdsException : Exception of type
FirebirdSql.Data.Firebird.Gds.GdsException was thrown.

######

Tony Rivron

=20



This message has been scanned for viruses by MailControl - www.mailcontrol.=
com