firebird-net-provider

[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

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

[<car...@te...>]

Hello:

Try:

ac := FbCommand.Create('EXECUTE PROCEDURE TEST(@ID_IN)', adm.Connection);
ac.CommandType := CommandType.StoredProcedure;

ac.Parameters.Add('@ID_IN', FbDBType.Integer,).Value := TObject(Int32(10));
ac.Parameters.Add('@ID_OUT', FbDBType.Integer).Direction := 
ParameterDirection.Output;

ac.ExecuteNonQuery;

Or:

ac := FbCommand.Create('TEST', adm.Connection);
ac.CommandType := CommandType.StoredProcedure;

ac.Parameters.Add('@ID_IN', FbDBType.Integer,).Value := TObject(Int32(10));
ac.Parameters.Add('@ID_OUT', FbDBType.Integer).Direction := 
ParameterDirection.Output;

ac.ExecuteNonQuery;




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain