Oracle Solution for Error ora-33920

Solution for Oracle Error ORA-33920

ORA-33920: (MAKEDCL34) The string SURROGATE must have one of the following data types: ID, NTEXT, TEXT, NUMBER, DATETIME, TIMESTAMP, or INTEGER.

What triggered the Error:

The user attempted to define a surrogate without specifying a valid data type.

What should we do to fix it:

Specify the data type (ID, NTEXT, TEXT, NUMBER, or INTEGER) in the definition of the surrogate.