在.net下调用oracle存储过程的问题
我的程序在.net下老说“System.Data.OracleClient.dll”类型的异常,编译不了。
我的存储过程是:
procedure test(tno out float ,outp OUT float)
is
v_SQL VARCHAR2(100);
rep integer;
p_outp t_cursor;
Begin
v_SQL:='SELECT DF FROM DSF WHERE DF=1';
OPEN p_outp FOR v_SQL;
FETCH p_outp INTO rep;
CLOSE p_outp;
outp:=1;
End;
我的程序是:
Dim cnConnection As OracleConnection = _
New OracleConnection("User ID=evwb_dfp;" & _
"Password=sei;" & _
"Data Source=evwb22")
cnConnection.Open()
Dim cnCommand As New OracleCommand()
cnCommand = New OracleCommand("EVWB_DFP.TEST1.TEST", cnConnection)
cnCommand.CommandType = CommandType.StoredProcedure
Dim myParm As OracleParameter = cnCommand.Parameters.Add ("@tno",OracleType.Float)
myParm.Direction = ParameterDirection.Output
Dim myParm2 As OracleParameter = cnCommand.Parameters.Add("@outp", OracleType.Float)
myParm2.Direction = ParameterDirection.Output
cnCommand.ExecuteNonQuery()
麻烦你再帮我看一下,谢谢!