Oracle Error ORA-36872: (XSTFDSC02) Column type specifier cannot be used when the table function data type is specified.

Oracle Error Message

ORA-36872: (XSTFDSC02) Column type specifier cannot be used when the table function data type is specified.

Reason for the Error

Column type can only be used with implicitly-specified table functions

Solution

Remove column type from reference from the LIMITMAP or remove the explicit table function data type specification.