Re: INSERT using cursor record variable

Hi Paul;

Funny you should post this as i was just trying to do this yesterday; My PL/SQL book explicitly states that you cannot do that: ig.

    insert into my_table values (src_tbl_rec); the book offers no alternative so i guess you need to explicitly name each inserted field; bad for me as my table has over 100 columns ;

i reverted to the create table as select in sqlplus. lemme know if you come up with a nice pl/sql solution;

Regards,
TMM    NAME Tim McGirr mcgirr_at_ix.netcom.com SNAIL 518 Dennis Lane Hockessin De 19707 PHONE 302-234-2975 (home) 302-433-8429 (work) Received on Tue Dec 05 1995 - 00:00:00 CET