PL/SQL How do you INSERT a %ROWTYPE variable

I wish to do the following:

v_foo foo%ROWTYPE;

select * into v_foo from foo where foo.foo_id = 123

v_foo.foo_id = [get new id]
v_foo.lname = 'Harrah'

INSERT into foo (*) values (v_foo)

Of course the INSERT line does not work. How can I insert a %ROWTYPE variable without listing all of the columns and elements?

Thanks,
Andy
aharrah_at_springrock.com Received on Fri Mar 28 1997 - 00:00:00 CST