Oracle Error ORA-36410: (VCACHE03) ‘number’ is an invalid value for the $VARCACHE property. The only permissible values are ‘DEFAULT’, ‘SESSION’, ‘VARIABLE’, and ‘NONE’.

Oracle Error Message

ORA-36410: (VCACHE03) ‘number’ is an invalid value for the $VARCACHE property. The only permissible values are ‘DEFAULT’, ‘SESSION’, ‘VARIABLE’, and ‘NONE’.

Reason for the Error

The user tried to assign an invalid value to the $VARCACHE property on a variable

Solution

Assign one of the valid values