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

[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

 

[Miha Markic [MVP C#]]

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