CREATE FUNCTION NTI.GETPROVIDERNAME
("P_ID" INTEGER
)
RETURNS VARCHAR(100)
begin atomic
declare pname varchar(100);
set pname=(
select provider_name
from t_provider
where provider_id=p_id);
return pname;
end;
("P_ID" INTEGER
)
RETURNS VARCHAR(100)
begin atomic
declare pname varchar(100);
set pname=(
select provider_name
from t_provider
where provider_id=p_id);
return pname;
end;