Oracle Error ORA-24190: length of payload exceeds string

Oracle Error Message

ORA-24190: length of payload exceeds string

Reason for the Error

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

Solution

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