110,533
社区成员
发帖
与我相关
我的任务
分享
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;
}
select rowid from TABLEFORTEST where COLA = 'A' and COLB='B'
int rowId = cmd.ExecuteOracleNonQuery(out oracleRowId);
public int ExecuteOracleNonQuery (
out OracleString rowid
)