Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

extension of %ROWTYPE variable

485251Feb 20 2010 — edited Feb 21 2010
Hi all,

Really scratching my head with this one and I'm sure there's a very simple solution.

Reading values into a record which is based upon a system view called v$logmnr_contents

input_rec v$logmnr_contents%ROWTYPE;

I want an output_rec which is based upon this definition but has and extra column called IDX as the first column,
this would be of type NUMBER.

First question, is there a way to use the definition v$logmnr_contents but add this extra column?
Along the lines of...

Declare
v_idx number;
output_rec v_idx, v$logmnr_contents%ROWTYPE;


Also how would I copy input_rec to output_rec without specifying the individual fields in the record?

Hope somone has a solution.

Regards
Dave

PS - This is Oracle 9i if that makes any difference.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 21 2010
Added on Feb 20 2010
7 comments
1,744 views