ORA-00907: 缺少右括号

[myb_edu007]

代码:
OleDbConnection objCn=new OleDbConnection();
OleDbDataAdapter objCmd;
DataSet Ds=new DataSet();
try
{
objCn.ConnectionString =mcnStr;

objCmd = new OleDbDataAdapter("select (select count(ssgsd) from czjjdqy where cmpno ="+cmp+" and flag ='Y') qysxj, "
+"(select count(ssgsd) from czjjdqy where cmpno ="+cmp+" and flag ='Y'and ssgsd <>'新港开发区' and ssgsd <>'高新开发区' and ssgsd <>'省企业') wqqy, "
+"(select count(ssgsd) from czjjdqy where cmpno ="+cmp+" and flag ='Y'and (ssgsd ='新港开发区' or ssgsd ='高新开发区') ) xggxqy,"
+"(select count(ssgsd) from czjjdqy where cmpno ="+cmp+" and flag ='Y'and ssgsd ='省企业' ) sqy,"
+"(select count(ssgsd) from czjjdqy where cmpno ="+cmp+" and flag ='Y') gsgzxj,"
+"(select count(ssgsd) from czjjdqy where cmpno ="+cmp+" and flag ='Y'and gsgztz ='1'and (ssgsd <>'省企业'and ssgsd <>'新港开发区' and ssgsd <>'高新开发区')) yfzgtz,"
+"((select count(ssgsd) from czjjdqy where cmpno ="+cmp+" and flag ='Y') - (select count(ssgsd) from czjjdqy where cmpno ="+cmp+" and flag ='Y'and gsgztz ='1'and (ssgsd <>'省企业'and ssgsd <>'新港开发区' and ssgsd <>'高新开发区')) - (select count(ssgsd) from czjjdqy where cmpno ="+cmp+" and flag ='Y' and (ssgsd ='省企业'or ssgsd ='新港开发区' or ssgsd ='高新开发区')) )dfzgtz,"
+"(select count(ssgsd) from czjjdqy where cmpno ="+cmp+" and flag ='Y'and (ssgsd ='省企业'or ssgsd ='新港开发区' or ssgsd ='高新开发区')) bxfzgtz,"
+"(select count(ssgsd) from czjjdqy where cmpno ="+cmp+" and flag ='Y'and gsyyzzdz ='1' ) ybzzdz,"
+"(select count(ssgsd) from czjjdqy where cmpno ="+cmp+" and flag ='Y'and swdjzdz ='1' ) swdjzdz,"
+"(select count(ssgsd) from czjjdqy where cmpno ="+cmp+" and flag ='Y'and ssys ='1' ) ssys,"
+"(select count(ssgsd) from czjjdqy where cmpno ="+cmp+" and flag ='Y'and dlhs ='1' ) dlhs,"
+"(select count(ssgsd) from czjjdqy where cmpno ="+cmp+" and flag ='Y'and (gsrk <>'0'or dsrk <>'0')) rks,"
+"(select count(ssgsd) from czjjdqy where cmpno ="+cmp+" and flag ='Y'and lhzf ='1' ) lhzfs"
+" from czjjdqy where cmpno ="+cmp+" and flag ='Y' group by cmpno",objCn);
objCmd.Fill(Ds,"archives");
问题:在代码执行到objCmd.Fill(Ds,"archives");时,出现"ORA-00907: 缺少右括号".但把sql语句加入plsql执行却能查出结果集．

[阿非]

你先把sql 语句 赋给一变量，然后运行的时候 把变量里的语句 放到plsql里运行一下

[netwar]

晕，写得太乱了，
用个变量代替一下，

[myb_edu007]

问题已经找到，是括弧问题，忽视了字段类型。

[li_an20081]

兄弟我也出现这个问题了，你能说清楚点吗？