Question 3

What should I do if get java.sql.SQLSyntaxErrorException: ORA-00902: invalid datatype error while adding record in repository for created or upgraded enterprise?

Above error occurs if Type Object is corrupted. Recreate it. Run the following command to recreate it.

CREATE OR REPLACE TYPE INSTRTBL
AS TABLE OF VARCHAR2 (255)
/