语句类似: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
解决方案 »
- 对联合主键的表建物化视图
- oracle数据库中blob字段的批量入库
- 急问ORACLE数据库同步的方法步骤!谢谢!
- [Help]请教Oracle 8g/9g数据库连接字符串问题。。。
- oracle行列转换的问题
- 请教一个 sql执行计划的问题
- 请问oracle高手 SQL语句该如何修改,怎么写。急!!!
- 求一个start with ... connect by 层次查询的用法,比较完整的实例以及测试数据,谢谢了!
- 将Mysql中的一数据库转到Oracle中,写blob字段时出现的问题。
- Oracle的存储过程怎么写呀?
- 我们通常都配置oracle client目录里面的tnsnames.ora,但是在oracle的network\admin里面也有同名文件,这是做什么用呢?
- 如何创建一个只有查询权限的用户
原来在前头执行了存储过程,但是我把CommandType重新设置为text了,还是出错了,估计是个系统的Bug,只好在新建个对象了。感谢各位DING