ORA-00911: Invalid character error, invalid ora-00911 character

Source: Internet
Author: User

ORA-00911: Invalid character error, invalid ora-00911 character

ORA-00911: Invalid character error -- caused by a minor error in the compilation environment

 

Implementation of a function script statement, compile, there is a ORA-00911 error, at that time some doubts, before the production library is used is no problem, after some checks, it turns out that an error has occurred in a very subtle place. The following is an example of simulating a simple experiment.

 

Repeat it in a simple way:

(Note ???? Garbled characters are character settings that are irrelevant to this experiment. However, this experiment is not affected and cannot be processed at the moment. For more information, see the following article: Click to open the link)

 

Note the semicolon format

Remove the semicolon and query again, as shown below. The statement is correctly executed.

 

Troubleshooting: note that the semicolon should be in English format when entering the format. Otherwise, an error will be reported during compilation.

 

Re-query the experiment and enter the semicolon in the English format as follows.

 

 

**************************************** *******Statement************************************************ 

Original works, from "Deep Blue blog" blog, welcome to reprint, reprint please be sure to indicate the source (http://blog.csdn.net/huangyanlong ).

Please leave a message if the statement is incorrect. Thank you very much.

*****************************************************************************************************

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


 

 


Jdbc in java error ORA-00911: invalid characters

"Select empno, ename, job from emp"; the front and back spaces are deleted.
There is a semicolon (;) at the end of the SQL statement, which will cause Exception in thread "main" java. SQL. SQLSyntaxErrorException: ORA-00911: invalid characters

Oracle ORA-00911: invalid characters

Authorize yiyu!

You are in the program
Statement petmtAlter = conn. createStatement (); next breakpoint
Copy the value of sqlSelectStr and assign values to PL/SQL to execute the following commands to find out what is wrong.

Related Article

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.