Declaring collection variables
About this task
To access the elements of a column that has a collection type (LIST, MULTISET, or SET) as its data type, perform the following steps:
Procedure
- Declare a collection host variable, either typed or untyped.
- Allocate memory for the collection host variable.
- Perform any select, insert, update, or delete operations on the collection host variable.
- Save the contents of the collection host variable into the collection column.