Oracle Error ORA-36875: (XSTFDSC05) LIMITMAP is missing or is not a string literal.

Oracle Error Message

ORA-36875: (XSTFDSC05) LIMITMAP is missing or is not a string literal.

Reason for the Error

Table functions that have an automatic ADT require LIMITMAP to be a string literal.

Solution

Either specify ADT for the table function or specify LIMITMAP as a string literal.