这段代码连sqlserver数据库没问题,连oracle数据库存储过程不成功,求解
- VB.NET code
Dim myconnection As OracleConnection Dim strsql = "User ID=card;Password=card;Data Source=orcltest" myconnection = New OracleConnection(strsql) myconnection.Open() Dim oraclecomm As OracleCommand = Nothing oraclecomm = New OracleCommand("trans", myconnection) oraclecomm.CommandType = CommandType.StoredProcedure oraclecomm.Parameters.Add("cardno", OracleType.VarChar) oraclecomm.Parameters("cardno").Value = "889900" Dim da1 As New OracleDataAdapter() da1.SelectCommand = oraclecomm Dim ds As New DataTable() da1.Fill(ds)
------解决方案--------------------
报什么错误啊,表面上看,看不了来问题。