Skip to Content
0
Former Member
Jun 24, 2015 at 06:19 PM

Handling exception in a for loop

719 Views

Hi,

I want to write exception block inside a for loop like oracle as below.

for i in c1 loop

begin

insert into table values (i.id, i...);

commit;

exception when others then

insert into erro_log values (i.id, i...);

end;

end loop;


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?

Best regards,

Kishore