create or replace procedure people(p_date varchar2)
is
v_date varchar(8);
v_count number;
begin
v_date :=p_date;
v_count :=0;
insert into pweb.capes_day (BUSS_TYPE,CLASS_TYPE,KPI_NAME,TYPE_ID,VALUE,O_TIME)
select b.BUSS_TYPE,b.CLASS_TYPE,b.KPI_NAME,b.ID,a.VALUE,a.O_TIME
from pweb.is_kpi_meta_data a, pweb.dms_domc b
where a.kpi_id = b.kpi_id
and substr(a.o_time,1,8) =v_date;
v_count:=v_count+SQL%ROWCOUNT;
commit;
end people;
你好,怎么消除这个警告,v_count:=v_count+SQL%ROWCOUNT; 我想知道的是插入了多少行记录数。
追答1. 插入数据库表
2. 作为返回值
create or replace procedure people(p_count out number, p_date varchar2)
最后:
p_count := v_count;