I am attempting to use a funtion in a cursor for loop but get the following error;
for c in (select upper(program_name) from caudit_program_exclude)
loop
ProgramTbl(c.program_name) := c.program_name;
end loop;
LINE/COL ERROR
-------- -----------------------------------------------------------------
40/5 PL/SQL: Statement ignored
40/18 PLS-00302: component 'PROGRAM_NAME' must be declared
Is this not allowed?