Oracle Error ORA-01044: size string of buffer bound to variable exceeds maximum string

Oracle Error Message

ORA-01044: size string of buffer bound to variable exceeds maximum string

Reason for the Error

An attempt was made to bind a buffer whose total size would exceed the maximum size allowed. Total array size for arrays is calculated as: (element_size)*(number of elements)

Solution

Reduce buffer size.