I am recieving wrong number or type back from this code and the number and type match the procedure in the database.
Am I missing something?
CN = GetConn2()
Cmd.Parameters.Clear()
Cmd.CommandText = ""
Cmd.Connection = CN
Cmd.CommandText = "PR_ATP_ChangePassword"
Cmd.CommandType = CommandType.StoredProcedure
Cmd.Parameters.Add(New OracleClient.OracleParameter("username", Data.OracleClient.OracleType.VarChar, 24, ParameterDirection.Input)).Value = txtntlogin.Text.ToUpper
Cmd.Parameters.Add(New OracleClient.OracleParameter("passwd", Data.OracleClient.OracleType.VarChar, 8, ParameterDirection.Input)).Value = "wel1come"
Cmd.Parameters.Add(New OracleClient.OracleParameter("ReturnValue", Data.OracleClient.OracleType.VarChar, 200, ParameterDirection.Output))
'RtnValue = Cmd.ExecuteNonQuery
thisReader = Cmd.ExecuteReader
thisReader.Read()
Am I missing something?
CN = GetConn2()
Cmd.Parameters.Clear()
Cmd.CommandText = ""
Cmd.Connection = CN
Cmd.CommandText = "PR_ATP_ChangePassword"
Cmd.CommandType = CommandType.StoredProcedure
Cmd.Parameters.Add(New OracleClient.OracleParameter("username", Data.OracleClient.OracleType.VarChar, 24, ParameterDirection.Input)).Value = txtntlogin.Text.ToUpper
Cmd.Parameters.Add(New OracleClient.OracleParameter("passwd", Data.OracleClient.OracleType.VarChar, 8, ParameterDirection.Input)).Value = "wel1come"
Cmd.Parameters.Add(New OracleClient.OracleParameter("ReturnValue", Data.OracleClient.OracleType.VarChar, 200, ParameterDirection.Output))
'RtnValue = Cmd.ExecuteNonQuery
thisReader = Cmd.ExecuteReader
thisReader.Read()