CREATE OR REPLACE PROCEDURE dhl (id in varchar)
AS
lmid varchar(50);
name varchar(50);BEGINselect lmb.lmid,lmb.name INTO lmid,name from lmb ,zlb where zlb.zlid=id and zlb.lmid=lmb.lmid;
IF lmid IS NOT NULL THEN
begin
insert temp(lmid,name) values (lmid,name);
dhl(lmid);
end;
END IF;END;
AS
lmid varchar(50);
name varchar(50);BEGINselect lmb.lmid,lmb.name INTO lmid,name from lmb ,zlb where zlb.zlid=id and zlb.lmid=lmb.lmid;
IF lmid IS NOT NULL THEN
begin
insert temp(lmid,name) values (lmid,name);
dhl(lmid);
end;
END IF;END;
AS
lmid varchar(50);
name varchar(50);BEGINselect lmb.lmid,lmb.name INTO lmid,name from lmb ,zlb where zlb.zlid=id and zlb.lmid=lmb.lmid;
IF lmid IS NOT NULL THEN
begin
insert into temp(lmid,name) values (lmid,name);
dhl(lmid);
end;
END IF;END;