Oracle Error ORA-24195: attemp to retrieve the name list of a map message with size exceeding 1024

Oracle Error Message

ORA-24195: attemp to retrieve the name list of a map message with size exceeding 1024

Reason for the Error

The GET_NAMES function returns the names in a varray with a size limit of 1024.

Solution

Retrieve in several smaller steps using the GET_NAMES function with OFFSET and LENGTH parameters.