list of variables inside a variable of type record

Hi everybody.

Does anyone know how to have a list of the variable inside a record declared like this:

rec1 table_name%rowtype;

I could retrieve the field name from the dictionary views like user_tab_columns or similar, but what can i do if "table_name" is a synonym? Maybe pointing to a db link? And if the db link points to another synonym pointing to another db link etc etc? Is there a straight way to know all the fields inside this record variable?

TIA Kamal Received on Thu Jan 23 2003 - 05:04:27 CST