ORA-00911: Invalid character Error

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.

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