Oracle Message ORA-24190 - length of payload exceeds string

ERRORlength of payload exceeds string
CAUSEthe length of payload being taken exceeds the limit of varchar2 or raw.
ACTIONuse clob type or blob type to call get_text or get_bytes.