我正在尝试将一组ID保存在数组中:
declare
cities_ids array_of_numbers;
begin
select id into cities_ids from objects where id = 1115464;
FOR i IN 1..cities_ids.COUNT LOOP
DBMS_OUTPUT.PUT_LINE(cities_ids(i));
END LOOP;
end;
执行后,出现下一个错误:
ORA-00932: inconsistent datatypes. Expected UDT, got NUMBER.
请解释我做错了什么...
很简单:BULK COLLECT
丢失。
declare
cities_ids array_of_numbers;
begin
select id BULK COLLECT into cities_ids from objects where id = 1115464;
FOR i IN 1..cities_ids.COUNT LOOP
DBMS_OUTPUT.PUT_LINE(cities_ids(i));
END LOOP;
end;
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句