I have a select statement that gets a list of columns from a table and this dataset is passed to a for each loop container and the each column is assigned to a variable created at the package level.
The question is, can the value of these variables be accessed outside the for each loop container. If so, what values do they hold? Is it the most recent value?
If my for each loop container fails, I should update a column in a table based on the value of a column that has been passed and is being accessed in a for each container.
Any code/logic/examples are greatly appreciated!
Thanks a million in advance.