createorreplacepackagep _ view _ paramis
functionset_param(numnumber ) return number;
function get_param return number;
end p_view_param;
createorreplacepackagebodyp _ view _ paramis
param value编号;
functionset_param(numnumber ) return number is
比根
paramValue:=num;
返回编号;
结束;
function get _ paramreturnnumberis
比根
返回参数值;
结束;
end p_view_param;
createorreplaceviewv _ WMS _ inventory as
选择材料_ no from [ email protected ] _ dbwherequantity=p _ view _ param.get _ param (
select * fromv _ WMS _ inventorywherep _ view _ param.set _ param (3050 )=3050;