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
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