Hi,
this is probably really basic but in my loop it steps through a cursor that checks for errors and then adds it to a table but the bit that gets me is that the first error is put into the TABLE as below but the next overwrights it, i want to concat all messages together before i do the INSERT but how can store each error as it loops.
<LOOP>
while cursor FIRST to LAST
select error-message INTO error_message where error_message1 || error_message2 || error_message3;|
INSERT INTO TABLE values (error_message);
<END LOOP>
No one has replied yet! Why not be the first?
Sign in or Join us (it's free).