Oracle Error Message
ORA-02304: invalid object identifier literal
Reason for the Error
An attempt was made to enter an object identifier literal for CREATE TYPE that is either:
– not a string of 32 hexadecimal characters
– an object identifier that already identifies an existing object
– an object identifier different from the original object identifier already assigned to the type
Solution
Do not specify the object identifier clause or specify a 32 hexadecimal-character object identifier literal that is unique or identical to the originally assigned object identifier. Then retry the operation.
