create table remarks ( remark varchar(1000)

create procedure P1 as

begin

while loop

begin

.....

insert into remarks ()

commit

end

end