.net - 如何使用 ADO.NET 和 Oracle 在一次调用中运行多个不同的 `insert` 语句？

Question

以下内容适用于 MS SQL Server，但我们的 Oracle 系统会抛出错误:ORA-00911:无效字符

字符串 strQuery = @"

insert into DEVICE
( DEVICE_ID, DEVICE_NAME, TIMESTAMP) values
(:DEVICE_ID,:DEVICE_NAME, sysdate);
insert into INV
( INV_ID, DEVICE_ID, COMMENT, TIMESTAMP) values
(:INV_ID,:DEVICE_ID,:COMMENT, sysdate);

";

OracleConnection conn = getConn();
OracleCommand cmd = new OracleCommand(strQuery, conn);
cmd.Parameters.AddWithValue(":DEVICE_ID", device.Id);
cmd.Parameters.AddWithValue(":DEVICE_NAME", device.Name);
cmd.Parameters.AddWithValue(":INV_ID", newInvId());
cmd.Parameters.AddWithValue(":COMMENT", device.Comment);

这只是一个示例，但假设某些字段非常大并且有大量语句等。

编辑:将语句放入一个 block 中(如托尼·安德鲁斯的回答)会导致以下错误:

[OracleException (0x80131938): ORA-06550: line 1, column 1:
PLS-00103: Encountered the symbol "" when expecting one of the following:

   begin case declare exit for function goto if loop mod null
   package pragma procedure raise return select separate type
   update while with <an identifier>
   <a double-quoted delimited-identifier> <a bind variable> <<
   form table call close current define delete fetch lock insert
   open rollback savepoint set sql execute commit forall merge
   library OPERATOR_ pipe
]

Answer 1

我不确定，但是如果你把它变成这样的 PL/SQL 匿名 block ，它会起作用吗？:

string strQuery = @"
begin
  insert into DEVICE
    ( DEVICE_ID, DEVICE_NAME) values
    (:DEVICE_ID,:DEVICE_NAME);
  insert into INV
    ( INV_ID, DEVICE_ID, COMMENT) values
    (:INV_ID,:DEVICE_ID,:COMMENT);
end;
";