Oracle Solution for Error ora-24190

Solution for Oracle Error ORA-24190

ORA-24190: length of payload exceeds string

What triggered the Error:

the length of payload being taken exceeds the limit of varchar2 or raw.

What should we do to fix it:

e clob type or blob type to call get_text or get_bytes.