oracle 脚本， 在线等

[beackoom]

declare
x NVARCHAR2(36);
begin
for x in ( SELECT AID FROM A WHERE AID NOT IN (SELECT DISTINCT(AID) FROM B) ) loop
INSERT INTO B VALUES (x, 'name', 0, 3);
end loop;
end;

上面这个脚本在insert语句 x位置有语法错误，但是我不知道什么错误？刚接触oracle，希望大家帮帮忙!

[notebook800]

declare 
  x NVARCHAR2(36); 
begin 
for x in ( SELECT AID FROM A WHERE AID NOT IN (SELECT DISTINCT(AID) FROM B) ) loop 
  INSERT INTO B VALUES (x.AID, 'name', 0, 3); 
end loop; 
end; 

[beackoom]

语法没问题了 。但是在执行过程中，死了那里了

[notebook800]

x 不需要declare
默认为rowtype

begin 
  for x in ( SELECT AID FROM A WHERE AID NOT IN (SELECT DISTINCT(AID) FROM B) ) loop 
    INSERT INTO B VALUES (x.AID, 'name', 0, 3); 
  end loop; 
end; 

[beackoom]

但还是谢谢你