Oracle Invalid Digital ____oracle

Source: Internet
Author: User
Today the program works locally and can be posted to the server The Times a ORA-00911 invalid character error

This error is due to a problem with the SQL statement, check the SQL did not see any problems, the results were taken to the library inside to execute when found inserted in the sentence is a comma separated in English, and my use is in Chinese.

The solution goes without saying, everybody understands

Please remember to report this ora-xxx error when you do not too believe that you write no problem, be sure to take the statement to the library to perform the inspection

Last time colleagues reported such a mistake, take the statement to the library execution also no error, later found in the library query, the end of the query with a semicolon, the library inside is to support this semicolon, but to ibatis inside is not support this semicolon, so this point we should also pay attention to.



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.