Thank you, indeed SELECT * INTO o ... solves it. One last question, if I may: both expected_stuff and archive.expected_stuff are defined as: ( source CHAR(2); warehouse CHAR(1); stuff SMALLINT; packslip CHAR(12) ); and o is expected_stuff%ROWTYPE Having the same structure, I put INSERT INTO archive.expected_stuff VALUES(o); but it doesn't work. Instead, I had to rewrite as INSERT ... VALUES (o.source,o.warehouse...); Is the short version not supposed to work, or am I using the wrong syntax? Thanks again, Sorin ____________________________________________________________________________________ Get your own web address. Have a HUGE year through Yahoo! Small Business. http://smallbusiness.yahoo.com/domains/?p=BESTDEAL
