This discussion is archived
5 Replies Latest reply: Jan 25, 2011 3:37 PM by 834235 RSS

ORA-00911: INVALID CHARACTER ERROR IN ORACLECOMMAND COMMANDTEXT

829693 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points