.net實(shí)現(xiàn)oracle數(shù)據(jù)庫(kù)中獲取新插入數(shù)據(jù)的id的方法

create or replace procedure p_GetItemID(
strInsertSQL varchar2,
seqName varchar2,
ID out varchar2
)
is
strSql varchar(200);
begin
execute immediate strInsertSQL;--執(zhí)行插入語(yǔ)句
strSql:='select '||seqName||'.currval from dual';--獲取id的sql語(yǔ)句
execute immediate strSql into ID;--執(zhí)行獲取id的sql語(yǔ)句
EXCEPTION
WHEN OTHERS THEN
DBMS_output.PUT_LINE(SQLERRM);
end p_GetItemID;

public string ExecuteProcedure(string strInsertSQL,string proName,string seqName)
{
try
{
if (m_Connection_orc.State != System.Data.ConnectionState.Open)
{//從webconfig中獲取數(shù)據(jù)庫(kù)連接
m_Connection_orc.Open();
}
}
catch (System.Exception ex)
{
}
try
{ //藍(lán)色字體會(huì)核心語(yǔ)句
OracleConnection dbConnection_orc;
OracleCommand dbCommand_orc;
dbConnection_orc = m_Connection_orc;
dbCommand_orc = new OracleCommand(proName, dbConnection_orc); //proName為存儲(chǔ)過(guò)程的名字
dbCommand_orc.CommandType = CommandType.StoredProcedure;
//在Parameters中添加的參數(shù)名稱(chēng)必須與數(shù)據(jù)庫(kù)中存儲(chǔ)過(guò)程中的參數(shù)名稱(chēng)、類(lèi)型保持一致
dbCommand_orc.Parameters.Add("strInsertSQL", OracleType.VarChar);
dbCommand_orc.Parameters.Add("seqName", OracleType.VarChar);
dbCommand_orc.Parameters.Add("ID", OracleType.VarChar);
dbCommand_orc.Parameters["ID"].Direction = ParameterDirection.Output; //指定參數(shù)ID為輸出類(lèi)型的值
dbCommand_orc.Parameters["strInsertSQL"].Value = strInsertSQL; //獲取插入語(yǔ)句
dbCommand_orc.Parameters["seqName"].Value = seqName; //獲取序列名稱(chēng)
dbCommand_orc.ExecuteNonQuery(); //執(zhí)行操作
string newID = dbCommand_orc.Parameters["ID"].Value.ToString(); //獲取id的值
return newID; //返回id值
}
catch (System.Exception ex)
{
throw ex;
}
finally
{
CloseConnection();
}
}