INSERT using cursor record variable

From: SkiMtns <skimtns_at_aol.com>
Date: 1995/12/04
Message-ID: <49vf1i$lor_at_newsbf02.news.aol.com>#1/1


Hello, within a function I have created a variable for a record type of my cursor. I load the record variable when I fetch the cursor. What I would now like to do is insert the data that is in the record variable into another table which has the same structure. Is it possible to use the record variable in the INSERT statement (INSERT into TABLE values c1rec) ?  I am using Oracle 7.2. Please e-mail directly if possible. Thanks in advance for any help.

Paul Hawkins Received on Mon Dec 04 1995 - 00:00:00 CET

Original text of this message