Oracle Solution for Error ora-29894

ORA-29894: base or varray datatype does not exist

What triggered the Error:

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

What should we do to fix it:

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