C # When oracle adds data to the table, the following error occurs: Invalid character. The reason is that a semicolon is added after the SQL statement.

C #CodeTo add data to the Oracle database table. The SQL statement is checked in pl SQL and can be added successfully.

But when the code is executed, an error is reported. Invalid character of invalid character.

Check the code and compare the SQL string. Finally, I searched for the problem. Some may be that the last SQL statement may contain a semicolon.

Remove the semicolon. The execution is successful.

Write SQL statements in pl SQL and add a semicolon at the end. However, it is considered invalid in the code.

 

 

There are other causes for invalid character error. This article only writes out the situations I encountered.