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