Calling a Procedure with Parameter Passing

Question

firebird

after describing the connections...

            try
            {
                connectionsql.Open();
                connectionfirebird.Open();

                cmdS.CommandText = "select ID_CASH from CAHS_TRANSACT";
                SqlDataReader reader;
                reader = cmdS.ExecuteReader();
                while (reader.Read())
                {
                    str = "execute procedure ART_DOC_INSERT (:ID_CASH, :DOCNUMB, :FLG)";
                    cmdF.CommandText = str;
                    cmdF.Parameters.Add("@ID_CASH", FbDbType.Integer).Value = reader.GetInt32(0);
                    cmdF.Parameters.Add("@DOCNUMB", FbDbType.BigInt).Value = DateTime.Now.ToString("yyMMddhhmm");
                    cmdF.Parameters.Add("@FLG", FbDbType.Integer).Value = "1";
                    try
                    {
                        cmdF.Prepare();
                        cmdF.ExecuteNonQuery();
                        cmdF.Parameters.Clear();
                    }
                    catch (Exception ex2)
                    {
                        Console.WriteLine(ex2.Message);
                        Console.ReadLine();
                    }
                }

gives an error:
Dynamic SQL Error
SQL error code = -206
Column unknown
ID_CASH
At line 1, column 36
What is my mistake? Thank you!

Answer 1

Based on this or this , the code will be like this:

str = "execute procedure ART_DOC_INSERT (:ID_CASH, :DOCNUMB, :FLG)";
cmdF.CommandText = str;
cmdF.Parameters.Add("ID_CASH", FbDbType.Integer).Value = reader.GetInt32(0);
cmdF.Parameters.Add("DOCNUMB", FbDbType.BigInt).Value = DateTime.Now.ToString("yyMMddhhmm");
cmdF.Parameters.Add("FLG", FbDbType.Integer).Value = "1";

look carefully at the links provided, maybe you will find something else useful)

Answer 2

Thanks, I'll take a look at the links, of course, but your code shows the same error!

Answer 3

text of the procedure

Answer 4

thank! figured it out myself.
this is correct:
str = "execute procedure ART_DOC_INSERT (@ID_CASH, @DOCNUMB, @FLG)";
cmdF.CommandText = str;
cmdF.Parameters.Add("ID_CASH", FbDbType.Integer).Value = reader.GetInt32(0);
cmdF.Parameters.Add("DOCNUMB", FbDbType.BigInt).Value = DateTime.Now.ToString("yyMMddhhmm");
cmdF.Parameters.Add("FLG", FbDbType.Integer).Value = "1";

Answer 5

that's great! )