Oracle Error ORA-04010: the number of values to CACHE must be greater than 1

Oracle Error Message

ORA-04010: the number of values to CACHE must be greater than 1

Reason for the Error

the value in the CACHE clause was one

Solution

specify NOCACHE, or a value larger than one