Oracle调用存储过程
pl/sql执行:
SQL窗口:
call procedure_name(parameter);
begin procedure_name(parameter); end;
COMMAND窗口:
exec procedure_name(parameter);
execute procedure_name(parameter);
call procedure_name(parameter);
begin procedure_name(parameter); end;
.net程序执行:
public bool UpdateDate(int xzID, int stewardID)
{
bool result = false;
OracleCommand oraCmd = new OracleCommand();
oraCmd.CommandText = "xx.Sp_update"; //存储过程名称
oraCmd.CommandType = CommandType.StoredProcedure;
#region 存储过程的参数声明
OracleParameter[] parameters ={
new OracleParameter("i_xz_id",OracleType.Number),
new OracleParameter("i_steward_id",OracleType.Number)
};
parameters[0].Value = xzID;
parameters[0].Direction