运用参数绑定的形式,对大量数据进行操作,效率很高,但有上限条数需要注意。
Oracle12 C
1048575 以下: 正常结束
1048576 以上: ORA-3146 发生
public void InsertData(OracleConnection con, int count)
{
try
{
OracleCommand cmd = new OracleCommand();
string sqlInsert = "INSERT INTO ORACLE_TEST_TABLE (ID,NAME,AGE,MANEY" +
")VALUES(:ID,:NAME,:AGE,:MANEY)";
int length = count;
cmd.Connection = con;
cmd.CommandText = sqlInsert;
cmd.ArrayBindCount = length;
int[] idArr = new int[