Dynamic Cursors (2)
uThe problem:
ØNo way to dynamically identify resulting record structure
ØHave to hard code a data type of the output variable
uRecommendation:
ØTry to use single-table return
§Since you know the table, you can define the variable with %rowtype)
ØCreate an object type to be returned from the query.