Oracle DBA, How To, Error, Cause and Action

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

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




Cause: 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)




Action: Reduce buffer size.