Loop über strukturierte Addition
Via Avaloq Script über über en strukturierte Addition loope
begin
session#.open_session(i_bu_id=>6, i_oracle_user=>'RBOCK');
dbms_output.put_line('--- Script execution ---');
script#.do_dyn('
begin
with obj_asset(274505) as a do
install#.log#write("count="||a.extn.asset_ftid.ftid_list.count);
for e in a.extn.asset_ftid.ftid_list loop
install#.log#write(e||" income_value="||e.income_value);
install#.log#write(e||" pay_date="||e.pay_date);
end loop;
end with;
end;
');
dbms_output.put_line('--- Done ---');
exception
when others then
dbms_output.put_line('Error '||co_err.last_err_log_id||': '||sqlerrm||def.rtn||log#.log#ctx(co_err.last_err_log_id));
end;
