I'm trying to loop thru a PL/SQL "User Defined Record" that has just one value to it which holds a bunch of filenames that I add along the way in my pl/sql procedure. So...1) how do I properly loop through a bunch of plain records? Do I need to do a Fetch like a cursor? I don't know how many records to loop thru so what can I do? I'm use to "Fetch Into" for a loop...but this record type is not a cursor (see my code below).
TYPE counted_assets IS RECORD
FOR counted_assets_record IN counted_assets LOOP
IF (SUBSTR(bookpagekey_record.file_name, 1, 7) = SUBSTR(counted_assets_record.asset_filename, 1, 7))
AND (bookpagekey_record.content_category LIKE '%Primary Image%')