Declaring a Name for an Opaque Type

The name that you declare for an opaque data type is an SQL identifier. When you create an opaque type in a database that is not ANSI-compliant, the name must be unique among the names of data types within the database.

When you create an opaque type in an ANSI-compliant database, owner.type combination must be unique within the database. The owner name is case sensitive. If you do not put quotation marks around the owner name, the name of the opaque-type owner is stored in uppercase letters.