extension of %ROWTYPE variable
485251Feb 20 2010 — edited Feb 21 2010Hi 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.