SQL & PL/SQL

I'm using ODP.NET so instead of returing an Oracle record type, I have to return an object that mimics the record type.

In this case, I need to return an object that mimics ORGANIZATION_REC_TYPE which has regular fields and a field that is of PARTY_REC_TYPE.

So I am looking for a way to, in PL/SQL, loop through the fields of the organization record (getting the field's name, value and data type) and using that information to find my mimic object's same-named attribute and setting that attribute's value. And yes, this has to take into account the "nested" PARTY_REC.

So, I'm willing to stub my toes on the PL/SQL code, but I need some help getting it started. I'd appreciate any input.

Thanks,

George