Ora-00911:invalid character SQL contains Chinese error

normal operation under PL/SQL but error at VS, first check if the end of the stitching SQL contains ";" (If the end of SQL contains ";" PL is still capable of normal execution) otherwise, it may be caused by the following reasons. Include Chinese

string string. Format (@ "select A.table_name   table name,           a.column_name  field name,           a.data_type    field type,           A. Data_length  length,           a.nullable     is empty,           a.data_default default value,           b.comments comment     from            user_ Tab_columns A, user_col_comments B            WHERE a.table_name = b.table_name and            a.column_name = B.column_name            and a.column_name = ' {0} '                , Fileid);

View Code

Workaround:

Add the following code when loading the program:

   System.Environment.SetEnvironmentVariable ("Nls_lang", "Simplified Chinese_china". ZHS16GBK ");

　　

Ora-00911:invalid character SQL contains Chinese error