asp.net中Update数据库时出错,请帮帮忙
语句类似: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
------解决方案--------------------用pl/sql developer单步调试就看出问题出在哪了
select 的用法在oralce中和sql server中不一样!
------解决方案--------------------把你存储过程粘出来,大家帮你看看,包头包体都要!
------解决方案--------------------在OracleParameter myParameter = new OracleParameter( "type ",OracleType.VarChar,4);
中定义的参数名称,类型,大小必须与oracle的存储过程一致
需要注意!
------解决方案--------------------那段错误代码太厉害了!!没有提示那一行出错吗/
------解决方案--------------------line 1, column 81是什么啊。应该是存储过程里边执行错误