Batch execution of Oracle SQL statements in code

Today is writing a tool (WinForm) that functions as a bulk insert OR UPDATE to a table in the Oracle database.

Execution of the time always error "[911] ora-00911:invalid character"

　　I copy the SQL statements out to PL SQL to execute, and that's right, because the test is just a statement, and I generated the statement at the end of each sentence added ";".

Baidu a bit, said is a semicolon problem, decisively remove the semicolon execution, is right.

But always feel a large segment of SQL does not split, more than the time should have a problem (no test) and poor readability, and then check the syntax of the batch execution.

The following methods are determined as follows:

　　Begin

SQL1;

SQL2;

...

　　END;

Debug through!

Batch execution of Oracle SQL statements in code