ORA-00911: invalid character Error,

ORA-00911: invalid character Error,

I usually use pl SQL and golden32 to query database software. If I use golden32, it is no problem to alias it as Chinese when I use it. Until I want to convert PL SQL (use Chinese package chinese.exe ), after the completion of the Chinese query statement again becomes the error "ORA-00911: invalid character"; after searching a lot of web pages to solve this problem, but most of the problem is the indicator point symbol;

Later, I found a solution on this website: http://blog.csdn.net/iloli/article/details/7766563;

Solve the problem by adding system variables:

 

Select "environment variables ";

Run the following statement in the database:

Select * from v $ nls_parameters t where t. PARAMETER = 'nls _ language' or t. PARAMETER = 'nls _ CHARACTERSET ';

The combined value of the inserted query field is AMERICAN. ZHS16GBK and the variable name is NLS_LANG. Then restart the computer.