62,046
社区成员
发帖
与我相关
我的任务
分享
public string GetOracleRowIdAfterInsertCommand(string OracleConnectionString)
{
string rowId = "";
OracleConnection conn = new OracleConnection(OracleConnectionString);
try
{
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "begin ";
cmd.CommandText += "INSERT INTO TABLEFORTEST (COLA,COLB) values ('A','B');";
cmd.CommandText += "end;";
conn.Open();
OracleString oracleRowId;
cmd.ExecuteOracleNonQuery(out oracleRowId);
rowId = oracleRowId.Value;
}
finally
{
conn.Close();
}
return rowId;
}