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.