5 Replies Latest reply: Jan 25, 2011 5:37 PM by 834235 RSS

    ORA-00911: INVALID CHARACTER ERROR IN ORACLECOMMAND COMMANDTEXT

    829693
      I USE this code in vb net 2005 and when i use greek text as alias in string i get subjects error. if i use English it runs Ok. What can i do?
      Thanks in advance.
      Cursor = Cursors.WaitCursor

      Dim sql As String = "select itemid,descr as SOMEGREEKTEXT, DESCRSH2,VALUE from ITEMS where ITEMID like " & "'" & TxtCode.Text & "'"

      cmd = New OracleCommand(sql, conn)
      cmd.CommandType = CommandType.Text

      da = New OracleDataAdapter(cmd)
      cb = New OracleCommandBuilder(da)
      ds = New DataSet()

      da.Fill(ds)
      Cursor = Cursors.Default