阅读背景:

mybatis 操作存储过程 小细节错误

来源:互联网 

项目开发的时候遇到一个毛病:

<span>org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: java.sql.SQLException: ORA-06550: 第 8 行, 第 4 列: 
PLS-00103: 涌现符号 ";"在须要以下之一时:
 . ( ) , * @ % & = - + < / >
   at in is mod remainder not rem => <an exponent (**)>
   <> or != or ~= >= <= <> and or like like2 like4 likec between
   || indicator multiset member submultiset
符号 ")" 被调换为 ";" 后持续。

### The error may exist in file [D:\Program Files\Workspaces\MyEclipse for Spring 2014\salesmanb2b\WebRoot\WEB-INF\classes\sqlmap\ProductMapper.xml]
### The error may involve com.salesmanb2b.mapper.ProductMapper.getProductsProc-Inline
### The error occurred while setting parameters
### SQL: {call GET_PRODUCTS   (    ?,    ?,    ?,    ?,    ?    }
### Cause: java.sql.SQLException: ORA-06550: 第 8 行, 第 4 列: 
PLS-00103: 涌现符号 ";"在须要以下之一时:
 . ( ) , * @ % & = - + < / >
   at in is mod remainder not rem => <an exponent (**)>
   <> or != or ~= >= <= <> and or like like2 like4 likec between
   || indicator multiset member submultiset
符号 ")" 被调换为 ";" 后持续。

; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-06550: 第 8 行, 第 4 列: 
PLS-00103: 涌现符号 ";"在须要以下之一时:
 . ( ) , * @ % & = - + < / >
   at in is mod remainder not rem => <an exponent (**)>
   <> or != or ~= >= <= <> and or like like2 like4 likec between
   || indicator multiset member submultiset
符号 ")" 被调换为 ";" 后持续。</span><span>org.springframework.jdbc.BadSq




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: