语句类似:update T1 set name='aaa' where id =10;
绝对没有错!
Select 没有问题,请帮忙看看是什么问题。具体出错信息:
ORA-06550: line 1, column 81:\nPLS-00103: Encountered the symbol \"(\" when expecting one of the following:\n\n begin case declare end exception exit for goto if loop mod\n null pragma raise return select update while with\n <an identifier> <a double-quoted delimited-identifier>\n <a bind variable> << close current delete fetch lock insert\n open rollback savepoint set sql execute commit forall merge\n <a single-quoted SQL string> pipe\n <an alternatively-quoted SQL string>\nThe symbol \"case\" was substituted for \"(\" to continue.\nORA-06550: line 1, column 107:\nPLS-00103: Encountered the symbol \";\" when expecting one of the following:\n\n * & = - + < / > at in is mod remainder not rem when\n <an exponent (**)> <> or != or ~= >= <= <> and or like\n between overlaps || multiset member SUBMULTIS\n
绝对没有错!
Select 没有问题,请帮忙看看是什么问题。具体出错信息:
ORA-06550: line 1, column 81:\nPLS-00103: Encountered the symbol \"(\" when expecting one of the following:\n\n begin case declare end exception exit for goto if loop mod\n null pragma raise return select update while with\n <an identifier> <a double-quoted delimited-identifier>\n <a bind variable> << close current delete fetch lock insert\n open rollback savepoint set sql execute commit forall merge\n <a single-quoted SQL string> pipe\n <an alternatively-quoted SQL string>\nThe symbol \"case\" was substituted for \"(\" to continue.\nORA-06550: line 1, column 107:\nPLS-00103: Encountered the symbol \";\" when expecting one of the following:\n\n * & = - + < / > at in is mod remainder not rem when\n <an exponent (**)> <> or != or ~= >= <= <> and or like\n between overlaps || multiset member SUBMULTIS\n
原来在前头执行了存储过程,但是我把CommandType重新设置为text了,还是出错了,估计是个系统的Bug,只好在新建个对象了。感谢各位DING