Re: Oracle: Accessing Record Fields (dynamically)

datDude wrote:
> updates to previous posting for the field names
>
> if input_rec.[collection(row_id).­field_name_1] = 100
> and input_rec.[collection(row_id).­field_name_2] = 20
> and input_rec.[collection(row_id).­field_name_3] = 80
> then
> follow processing code
> end if;
>
>
>
> also the version is version 9.2.0.4

Oh does this look like a bad design. Does the above indicate nested tables and/or varrays? If so please refer to Tom Kyte's many comments on the subject.

Use object-relational views on top of relational tables.

And thanks for the version number. It provides some context around what you are doing.

-- 
Daniel A. Morgan
Relational theory is not something that is simply a nice-to-have.
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)