Is there any way to create a record type with a %rowtype variable without knowing the table's name? I'd like a record to be able to be created dynamically, as each table may have different numbers of columns.
I already have a ref cursor that takes in a table name stored in a varchar2. I just need a record type to hold a row fetched from the ref cursor.
If there's some way to use that varchar2 with the table's name when creating the record type, that would work perfectly.
After some research it seems like what I'm trying to do may be impossible. I want to make a stored procedure that when passed a table name and id value it will find all rows of that table with that id and create the insert statements needed to reproduce them.