sql的insert和update两个语句同时执行时在程序里总是出错,求解
这样写总是出错,怎么办?异常详细信息:System.Data.OracleClient.OracleException: ORA-00911: 无效字符
在数据库里操作没问题,但是在程序里就出错了
using (OracleConnection aOracleConnection = new OracleConnection(connectStr))
{ aOracleConnection.Open();
string insertStr = "Insert Into " + DBSpace + "." + tableofJSQX + "(FZMC,JLMC,GLBM)" + " select FZMC,JLMC,GLBM from jjims.xtgl_jsqx_cdm;" + " update " + DBSpace + "." + tableofJSQX + " set ck=0,xg=0,tj=0,de=0,sc=0,xz=0,dr=0,dc=0,fzmc='" + selectedGroup + "' where FZMC = '新建'";
OracleCommand aOracleCommand = new OracleCommand(insertStr, aOracleConnection); aOracleCommand.ExecuteNonQuery();