大家帮我看看

Question

大家看看这个错误是语法错误，还是数据造成的
 sql = "insert into jkqx(id,zch,sccsmcc,cpxnzc,cpsyfw,zcdl,shfwjg,pzrq,YXQJZR,bz,bgrq,sccse,sccdzc,sccs,scgc,cpmcc,cpmce,ggxh,cpbz)values(:p,:p1,:p2,:p3,:p4,:p5,:p6,:p7,:p8,:p9,:p10,:p11,:p12,:p13,:p14,:p15,:p16,:p17,:p18)";
                            cmd.CommandText = sql;
                            cmd.Parameters.Clear();
                            cmd.Parameters.AddWithValue(":p", i);
                            cmd.Parameters.AddWithValue(":p1", temp1);
                            cmd.Parameters.AddWithValue(":p2", temp2);
                            cmd.Parameters.AddWithValue(":p3", temp3);
                            cmd.Parameters.AddWithValue(":p4", temp4);
                            cmd.Parameters.AddWithValue(":p5", temp5);
                            cmd.Parameters.AddWithValue(":p6", temp6);
                            cmd.Parameters.AddWithValue(":p7", temp7);
                            cmd.Parameters.AddWithValue(":p8", temp8);
                            cmd.Parameters.AddWithValue(":p9", temp9);
                            cmd.Parameters.AddWithValue(":p10", temp10);
                            cmd.Parameters.AddWithValue(":p11", temp11);
                            cmd.Parameters.AddWithValue(":p12", temp12);
                            cmd.Parameters.AddWithValue(":p13", temp13);
                            cmd.Parameters.AddWithValue(":p14", temp14);
                            cmd.Parameters.AddWithValue(":p15", temp15);
                            cmd.Parameters.AddWithValue(":p16", temp16);
                            cmd.Parameters.AddWithValue(":p17", temp17);
                            cmd.Parameters.AddWithValue(":p18", temp18);
                            cmd.CommandType = CommandType.Text;
                            cmd.ExecuteNonQuery();异常
+ $exception {"ORA-01036: 非法的变量名/编号\n"} System.Exception {System.Data.OracleClient.OracleException}

Answer 1

                            sql = "update jkqx set zch=:p1,sccsmcc=:p2,cpxnzc=:p3,cpsyfw=:p4,zcdl=:p5,shfwjg=:p6,pzrq=:p7,yxqjzr=:p8,bz=:p9,bgrq=:p10,sccse=:p11,sccdzc=:p12,sccs=:p13,scgc=:p14,cpmcc=:p15,cpmce=:p16,ggxh=:p17,cpbz=:18 where id=:p";
                            cmd.CommandText = sql;
                            cmd.Parameters.Clear();
                            cmd.Parameters.AddWithValue(":p", i);
                            cmd.Parameters.AddWithValue(":p1", temp1);
                            cmd.Parameters.AddWithValue(":p2", temp2);
                            cmd.Parameters.AddWithValue(":p3", temp3);
                            cmd.Parameters.AddWithValue(":p4", temp4);
                            cmd.Parameters.AddWithValue(":p5", temp5);
                            cmd.Parameters.AddWithValue(":p6", temp6);
                            cmd.Parameters.AddWithValue(":p7", temp7);
                            cmd.Parameters.AddWithValue(":p8", temp8);
                            cmd.Parameters.AddWithValue(":p9", temp9);
                            cmd.Parameters.AddWithValue(":p10", temp10);
                            cmd.Parameters.AddWithValue(":p11", temp11);
                            cmd.Parameters.AddWithValue(":p12", temp12);
                            cmd.Parameters.AddWithValue(":p13", temp13);
                            cmd.Parameters.AddWithValue(":p14", temp14);
                            cmd.Parameters.AddWithValue(":p15", temp15);
                            cmd.Parameters.AddWithValue(":p16", temp16);
                            cmd.Parameters.AddWithValue(":p17", temp17);
                            cmd.Parameters.AddWithValue(":p18", temp18);
                            cmd.CommandType = CommandType.Text;
                            cmd.ExecuteNonQuery();
写错了 。应该是这个 有问题

Answer 2

                            sql = "update jkqx set zch=:p1,sccsmcc=:p2,cpxnzc=:p3,cpsyfw=:p4,zcdl=:p5,shfwjg=:p6,pzrq=:p7,yxqjzr=:p8,bz=:p9,bgrq=:p10,sccse=:p11,sccdzc=:p12,sccs=:p13,scgc=:p14,cpmcc=:p15,cpmce=:p16,ggxh=:p17,cpbz=:18 where id=:p";
                            cmd.CommandText = sql;
                            cmd.Parameters.Clear();
                            cmd.Parameters.AddWithValue(":p", i);
                            cmd.Parameters.AddWithValue(":p1", temp1);
                            cmd.Parameters.AddWithValue(":p2", temp2);
                            cmd.Parameters.AddWithValue(":p3", temp3);
                            cmd.Parameters.AddWithValue(":p4", temp4);
                            cmd.Parameters.AddWithValue(":p5", temp5);
                            cmd.Parameters.AddWithValue(":p6", temp6);
                            cmd.Parameters.AddWithValue(":p7", temp7);
                            cmd.Parameters.AddWithValue(":p8", temp8);
                            cmd.Parameters.AddWithValue(":p9", temp9);
                            cmd.Parameters.AddWithValue(":p10", temp10);
                            cmd.Parameters.AddWithValue(":p11", temp11);
                            cmd.Parameters.AddWithValue(":p12", temp12);
                            cmd.Parameters.AddWithValue(":p13", temp13);
                            cmd.Parameters.AddWithValue(":p14", temp14);
                            cmd.Parameters.AddWithValue(":p15", temp15);
                            cmd.Parameters.AddWithValue(":p16", temp16);
                            cmd.Parameters.AddWithValue(":p17", temp17);
                            cmd.Parameters.AddWithValue(":p18", temp18);
                            cmd.CommandType = CommandType.Text;
                            cmd.ExecuteNonQuery();
写错了 。应该是这个 有问题