ORA-00917 missing comma when using OleDb to insert chinese character

  • Thread starter Thread starter cherry
  • Start date Start date
C

cherry

I have a program using OleDbCommand to insert some chinese character
information into Oracle Database.
It runs normal except when data contains a particular chinese
character "¦â" and the exception message is ORA-00917 missing comma.

This is so strange for me since this is a very simple chinese
character and it could be inserted when I tested with other
applications(i.e. Oracle Financials).
Is this the problem of OleDbCommand of .Net?
Any idea?


Thanks and Regards,
Cherry
 
Hi,

Use parametrised commands (send values using parameters) and you'll be
(probably) fine.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/


I have a program using OleDbCommand to insert some chinese character
information into Oracle Database.
It runs normal except when data contains a particular chinese
character "¦â" and the exception message is ORA-00917 missing comma.

This is so strange for me since this is a very simple chinese
character and it could be inserted when I tested with other
applications(i.e. Oracle Financials).
Is this the problem of OleDbCommand of .Net?
Any idea?


Thanks and Regards,
Cherry
 
Back
Top