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

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.