17,377
社区成员
发帖
与我相关
我的任务
分享
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);