Avoid name collisions
When you create a UDX, ensure that you choose a unique name for it. Do not use a name that is already in use, either by an SQL function or another UDX. Do not rely on difference in case alone (for example, TRUNC and trunc) to distinguish UDX names. By default, the system converts all identifiers, such as database, table, and column names, to the default system case, which is uppercase. If you want to use mixed-case names for UDX names, you can place the name in double quotation marks when you register the UDX.