Question

C＃中遇到了 未处理的“System.Data.OleDb.OleDbException”类型的异常出现在 system.data.dll中

我的源代码是：

string connstr = "Provider=MSDAORA.1;User ID=system;Password=djl;Data Source=link114;";
OleDbConnection conn = new OleDbConnection(connstr);

OleDbCommand cmd = new OleDbCommand("test", conn);

cmd.CommandType = CommandType.StoredProcedure;

OleDbParameter IdIn = cmd.Parameters.Add("@tel", OleDbType.VarChar, 10);//输入参数
IdIn.Direction = ParameterDirection.Input;

OleDbParameter IdOut1 = cmd.Parameters.Add("@threew", OleDbType.VarChar, 50);//输出参数

IdOut1.Direction = ParameterDirection.Output;

IdIn.Value = textBox1.Text;

conn.Open();

cmd.ExecuteNonQuery();
我源代码中的 "test"是一个存储过程在 oracl中的 代码是 (tel in VARCHAR2,threew out varchar2) as
v_tel varchar2(10);
v_name varchar2(10);
v_addr varchar2(10);
begin
SELECT CALLNUM,NAME,ADDRESS into v_tel,v_name,v_addr FROM DJL WHERE CALLNUM=tel;
threew := v_tel||'^'||v_name||'^'||v_addr ;
end test;

Answer 1

OleDbCommand cmd = new OleDbCommand("test", conn);
写成
OleDbCommand cmd = new OleDbCommand();
cmd.CommandText="test";
cmd.Connection=conn;
试下

Answer 2

需要用"@tel"吗？
把“@”去掉试试

Answer 3

参数错误