I want to write exception block inside a for loop like oracle as below.
for i in c1 loop
insert into table values (i.id, i...);
exception when others then
insert into erro_log values (i.id, i...);
I want to handle same thing in hana. Is it possible in hana?
Does anybody knows how to handle exception in a for loop statement or has an other solution to solve my problem described above?