An error occurred while using mybatis to operate on the stored procedure.
An error occurred during project development:
<Span style = "font-size: 24px;"> org. springframework. jdbc. badSqlGrammarException: ### Error querying database. cause: java. SQL. SQLException: ORA-06550: 8th rows, 4th columns: PLS-00103: sign ";" when you need the following :. (), * @ % & =-+ </> at in is mod remainder not rem => <an exponent (**)> <> or! = Or ~ ==<=<> And or like like2 like4 likec between | indicator multiset member submultiset symbol ")" is replaced with ";" and then continues. ### 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: 8th rows, 4th columns: PLS-00103: sign ";" when you need the following :. (), * @ % & =-+ </> at in is mod remainder not rem => <an exponent (**)> <> or! = Or ~ ==<=<> And or like like2 like4 likec between | indicator multiset member submultiset symbol ")" is replaced with ";" and then continues .; Bad SQL grammar []; nested exception is java. SQL. SQLException: ORA-06550: 8th rows, 4th columns: PLS-00103: sign ";" when you need the following :. (), * @ % & =-+ </> at in is mod remainder not rem => <an exponent (**)> <> or! = Or ~ ==<=<> And or like like2 like4 likec between | indicator multiset member submultiset symbol ")" is replaced with ";" and then continues. </Span>
An error occurred while creating the ing file.
<select id="getProductsProc" parameterType="java.util.Map" statementType="CALLABLE"> {call GET_PRODUCTS ( #{proid,jdbcType=INTEGER, mode=IN}, #{product1,javaType=ResultSet,jdbcType=CURSOR,resultMap=product,mode=OUT}, #{product2,javaType=ResultSet,jdbcType=CURSOR,resultMap=product,mode=OUT}, #{product3,javaType=ResultSet,jdbcType=CURSOR,resultMap=product,mode=OUT}, #{product4,javaType=ResultSet,jdbcType=CURSOR,resultMap=product,mode=OUT} ) } </select>
The right parenthesis behind the call is missing
This is a small detail
PS:
For Oracle stored procedures
We recommend that you use navicat to write the code after it runs successfully.