日期:2014-05-18  浏览次数:20906 次

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是什么啊。应该是存储过程里边执行错误