Before you can retrieve a collection from the database
into an SPL routine, you must declare a collection variable. The following
figure shows how to declare a collection variable to retrieve the primes column
from the numbers table.Figure 1: Declare a collection variable.
DEFINE p_coll SET( INTEGER NOT NULL );
The DEFINE statement declares a collection variable p_coll,
whose type matches the data type of the collection stored in the primes column.