Hello!
I have to store some fetched records into two lists (arrays) to work with them.
I have to store some fetched records into two lists (arrays) to work with them.
I can use the RECORD type in a FOR SELECT loop to get one row data.
declare
f record;
begin
for f in select title, length
But if I tried to define an "array of record", I got an error message.
declare
R_A record[]; <---- some error
So I can't store the fetched data into an array simply.
Ok, I found a solution when I define a TYPE, and I use this:
declare
f TMy_Record;
R_A TMy_Record[];
Then I can work with the data.
But this means a dependency, so I can't change the TYPE without pre-dropping the stored procedure (and without recreating after).
Is there any way to avoid this? To use a "simple untyped record" in an array without "dependencies"?
Thank you for the answer!
Best regards
dd
