-- finally, we have to validate the version: declare myvers number := 1041; -- for the initial one mycommentid number :=-1; begin insert into rich_comment ( table_modified, author, description ) values ('RICH700_TRB3LOOKUP', 'JAM', 'Version '||myvers||' used for testing'); select rich_comment_sequ.currval into mycommentid from dual; insert into rich700_trb3lookup ( vers_id, context_id, valid_since, valid_until, comment_id ) values ( myvers, 239, '01-JAN-2010', hdate.high_date, mycommentid ); end;