Oracle中一次执行多条SQL语句需要注意的地方

 

StringBuilder sb = new StringBuilder();
sb.Append(" BEGIN ");
sb.Append("INSERT INTO BOXCAP (BOXID,CAPITALID,STATE) VALUES (32,'090922000018',0);");
sb.Append("INSERT INTO BOXCAP (BOXID,CAPITALID,STATE) VALUES (32,'090922000020',0);");
sb.Append("END;");
this.bOXCAPTableAdapter.Connection.Open();
OracleCommand comm = new OracleCommand();
comm.Connection = this.bOXCAPTableAdapter.Connection;
comm.CommandType = CommandType.Text;
comm.CommandText = sb.ToString();
comm.ExecuteNonQuery();
this.bOXCAPTableAdapter.Connection.Close();

//1.不能加任何行分割符号
//2.必须以begin开始(begin后要带空格)和end;结尾(end后必须加分号)
//3.每条Sql语句以分号结束