PL/sql that little thing-->sqlsession operation; SQL []; ORA-01722: Invalid number

PL/sql that little thing-->sqlsession operation; SQL []; ORA-01722: Invalid number

In this case, many methods have been found on the Internet, and there are basically two ways to help us solve this problem:

1. Find out the wrong line code to see if the string is converted to a number when the error, if the action beginning wrong, you need to Integer.parseint (string str) API to solve the problem

If there is no error in the action layer, but the display is Mapper.xml file error, it is inconsistent with the data type in the database, this time need to to_number (from the background parameters)

2. If the drive output in the action layer, if there is no response to the output, you need to pay attention to whether the problem of fuzzy query, when the action layer does not need to fuzzy query%, there is no need

Write on the fuzzy query%, to see if there is like in the Mapper.xml mapping file, if there is like before the action layer to add%, if there is no like, there is no need for the action layer%

PL/sql that little thing-->sqlsession operation; SQL []; ORA-01722: Invalid number