Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle Stored procedures .NET

Status
Not open for further replies.

mc13

Programmer
May 26, 2000
26
US
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()

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top