3,491
社区成员
发帖
与我相关
我的任务
分享
create or replace procedure product_inouttype_prc(parm_ctgyid in varchar2,parmparm_pric in out number)
as
begin
update PRODUCTINFOLXX
set productprice=productinfolxx.productprice*(1-parmparm_pric)
where productinfolxx.category=parm_ctgyid;
SYS.DBMS_OUTPUT.PUT_LINE('parmparm_pric的值是:'||parmparm_pric);
SYS.DBMS_OUTPUT.PUT_LINE('1-parmparm_pric的值是:'||(1-parmparm_pric));
if SQL%found then
parmparm_pric:=SQL%rowcount;
end if;
end product_inouttype_prc;
create or replace procedure product_clinouttype_prc(parm_ctgyname in varchar2)
as
cur_ctgyid categoryinfolxx.categoryid%type;
cur_pric number;
begin
select categoryinfolxx.categoryid into cur_ctgyid
from categoryinfolxx
where categoryinfolxx.categoryname=parm_ctgyname;
product_inouttype_prc(cur_ctgyid,cur_pric);
if cur_pric>0 then
SYS.DBMS_OUTPUT.PUT_LINE('共修改'||cur_pric||'条记录。');
end if;
exception
when no_data_found then
SYS.DBMS_OUTPUT.PUT_LINE('没有数据!');
when too_many_rows then
SYS.DBMS_OUTPUT.PUT_LINE('数据过多!');
end;