我想往Oracle的一个表A001中插入'text1.text'和'text2.text'的内容,我写的代码如下,可是提示错误:ORA-00911: 无效字符。请各位大侠帮忙看看是哪里出了问题啊?谢谢了
string ConnectionString = "Data Source=服务器;User ID=***;Password=***";
OracleConnection conn = new OracleConnection(ConnectionString);
string ORC = "insert into A001 (ID,PWD) values('text1.text','text2.text') ";
OracleCommand cmd = new OracleCommand(ORC, conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
string ConnectionString = "Data Source=服务器;User ID=***;Password=***";
OracleConnection conn = new OracleConnection(ConnectionString);
string ORC = "insert into A001 (ID,PWD) values('text1.text','text2.text') ";
OracleCommand cmd = new OracleCommand(ORC, conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
我感觉这是中文逗号
到oracle pl里面试一下
语句里最后边不能有分号。另外,
text1.text和text2.text值不能为null