Oracle Error ORA-01489: result of string concatenation is too long

Oracle Error Message

ORA-01489: result of string concatenation is too long

Reason for the Error

String concatenation result is more than the maximum size.

Solution

Make sure that the result is less than the maximum size.