日期:2014-05-17 浏览次数:21068 次
PROCEDURE train_type_d(trainTypeId int,
rtn out int)
is
v_count number;
begin
select count(*) into v_count from TRAIN_TYPE where UP_TRAIN_TYPE_ID= trainTypeId;
if v_count>0 then
rtn := 0;
else
delete TRAIN_TYPE where TRAIN_TYPE_ID = trainTypeId;
rtn := 1;
end if;
end;
this.sysBiz.delTrainType(id);