Oracle Error ORA-29894: base or varray datatype does not exist

Oracle Error Message

ORA-29894: base or varray datatype does not exist

Reason for the Error

One of the base and varray datatypes specified in WITH ARRAY DML (DATA_TYPE, VARRAY_TYPE) clause could not be found.

Solution

Check to see if the datatype exists and the user has EXECUTE privilege on this datatype.