开发者

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


Did you specify that this is a stored procedure you're calling??

E.g. do you have this line somewehre (your sample code posted seems incomplete):

cmd.CommandType = CommandType.StoredProcedure;


Use,

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

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜