oledbparameter ORA-01008: Not all variables bound
Publicado por Walter (3 intervenciones) el 05/12/2006 16:53:36
El siguiente codigo no funciona me da un error:
ORA-01008: Not all variables bound
Dim Comando As New OleDbCommand(vQuery, Con.Conexion)
Comando.CommandType = CommandType.Text
Comando.Parameters.Add(New OleDbParameter("C1", OleDbType.VarChar, 2, ParameterDirection.Input))
Comando.Parameters("C1").Value = Session("Cia")
Result = Con.Consulta(Comando)
------------------------
Public Function Consulta(ByVal pComando As OleDbCommand) As OleDb.OleDbDataReader
Try
Return pComando.ExecuteReader
Catch ex As Exception
MsgBox("Error..." & ex.Message)
Return Nothing
End Try
End Function
ORA-01008: Not all variables bound
Dim Comando As New OleDbCommand(vQuery, Con.Conexion)
Comando.CommandType = CommandType.Text
Comando.Parameters.Add(New OleDbParameter("C1", OleDbType.VarChar, 2, ParameterDirection.Input))
Comando.Parameters("C1").Value = Session("Cia")
Result = Con.Consulta(Comando)
------------------------
Public Function Consulta(ByVal pComando As OleDbCommand) As OleDb.OleDbDataReader
Try
Return pComando.ExecuteReader
Catch ex As Exception
MsgBox("Error..." & ex.Message)
Return Nothing
End Try
End Function
Valora esta pregunta


0