解决:select 后面跟into
SQL> begin
2 v_xml clob;3 for i in (select keyid from tb_intf_rcgdxx_text2 where rownum<1001) loop
4 select XML from tb_intf_rcgdxx_text2 tws where tws.keyid=i.keyid for update;
5 end loop;
6 end;
7 /
SQL>
declare
v_xml clob;
begin
3 for i in (select keyid from tb_intf_rcgdxx_text2 where rownum<1001) loop4 select XML into v_xml from tb_intf_rcgdxx_text2 tws where tws.keyid=i.keyid for update;
5 end loop;
6 end;
7 /