communication with Oracle stored procedures
The ASP.NET code I have is the following:
Dim oraCmdLogin As New OracleClient.OracleCommand("compareLogin", oraConn)
oraCmdLogin.CommandType = CommandType.StoredProcedure
Dim login As New OracleClient.OracleParameter
login.OracleType = OracleClient.OracleType.Number
login.ParameterName = "login"
login.Value = 23
oraCmdLogin.Parameters.Add(login)
Dim pass As New OracleClient.OracleParameter
pass.OracleType = OracleClient.OracleType.Number
pass.ParameterName = "password"
pass.Value = 23
oraCmdLogin.Parameters.Add(pass)
oraConn.Open()
Try
oraCmdLogin.ExecuteNonQuery()
Catch ex As Exception
Response.Write(ex.Message)
End Try
oraConn.Close()

