Source and target data types

You cannot create a cast between two built-in or qualified data types.

You also cannot create a cast that includes any of the following data types as either the source type or target type for the cast:
  • Collection data types: LIST, MULTISET, or SET
  • Unnamed row types
  • Smart-large-object data types: BLOB or CLOB