VB.NET - Update Command not responding for Oracle XE?
Asked By Gokhan Metepe on 18-Mar-13 07:10 AM
I am using this command types whiling selecting in Oracle.
But it is not responding for Update command;
Dim lTT1 As New OracleConnection(Me.Connessione)
Dim lTCIM1 As New OracleCommand()
lTCIM1.Connection = lTT1
lTCIM1.CommandType = CommandType.Text
lTCIM1.CommandText = "Update DRUG Set DRNAM = 'Alchol' Where DRNAM = 'Alkol';"
lTT1.Open()
lTCIM1.ExecuteNonQuery()
lTT1.Close()
Whats wrong?