.....
cursor get_pro_name(p_id products.ord_id%type) is
select pro_name from products where
ord_id =p_id;
begin
for i_get_pro_name in get_pro_name(:new.ord_id) loop
.....
cursor get_pro_name(p_id products.ord_id%type) is
select pro_name from products where
ord_id =p_id;
begin
for i_get_pro_name in get_pro_name(:new.ord_id) loop
.....
select seq_pro.nextval into i from dual;
:new.pro_id := i; --pro_id是主键 dbms_output.put_line(to_char(i));
end if;dbms_output.put_line(to_char(:new.pro_id ));看看它到底是?
不会进入for i_get_pro_name in get_pro_name loop,is_reappear就不为false.