Search code examples
c#dotconnect

dotConnect and calling procedure with parameters problem

This is my code for calling procedure:

cmd.CommandText = "x.PROCEDURENAME";

cmd.Parameters["V_IID_DOKUMENT_PO"].Value = "1";
cmd.Parameters["x"].Value = x.Text;
cmd.Parameters["x"].Value = x.Text;
cmd.Parameters["x"].Value = x.Text;
cmd.Parameters["x"].Value = Convert.ToInt32(x.Text);
cmd.Parameters["x"].Value = x.Text;
cmd.Parameters["x"].Value = x.Text;
cmd.Parameters["x"].Value = x.Text;
cmd.Parameters["x"].Value = x.Text;
cmd.Parameters["x"].Value = "1";
cmd.ExecuteNonQuery();

but i get

A parameter with name 'V_IID_DOKUMENT_PO' is not contained by this Parameters collection.

if i check in DB

PROCEDURE PROCEDURENAME
 (V_IID_DOKUMENT_PO IN NUMBER
  ...

what i am doing wrong?

If i use:

cmd.Parameters.Add("V_IID_DOKUMENT_PO", OracleDbType.Number, 1);

i get invalid sql statement

Solution

  • Use,

    cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("V_IID_DOKUMENT_PO", OracleDbType.Number).Value=1;