begin for cid in(SELECT id FROM diccomponent) loop insert into repstorage (id,componentid,count,uts)values(repstorage_seq.nextval,cid,0,sysdate); end loop; end; / 第 3 行出现错误: ORA-06550: 第 3 行, 第 82 列: PLS-00382: 表达式类型错误就是说cid错误,郁闷了
begin for cid in(SELECT id FROM diccomponent) loop insert into repstorage (id,componentid,count,uts)values(repstorage_seq.nextval,cid.id,0,sysdate);--------这里引用出问题了 end loop; end; /
begin for cid in(SELECT id FROM diccomponent) loop insert into repstorage (id,componentid,count,uts)values(repstorage_seq.nextval,cid.id,0,sysdate);--------这里引用出问题了cid.id end loop; end; /
begin
for cid in(SELECT id FROM diccomponent) loop
insert into repstorage (id,componentid,count,uts)values(repstorage_seq.nextval,cid.id,0,sysdate);--------这里引用出问题了
end loop;
end;
/
for cid in(SELECT id FROM diccomponent) loop
insert into repstorage (id,componentid,count,uts)values(repstorage_seq.nextval,cid.id,0,sysdate);--------这里引用出问题了cid.id
end loop;
end;
/