How to fix the Oracle error ORA-36862: (XSTFRC02) Column number for this SQL Cache must be between 1 and number. Specified column number number is invalid.?

In this post, you’ll learn more about the Oracle ErrorORA-36862: (XSTFRC02) Column number for this SQL Cache must be between 1 and number. Specified column number number is invalid. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36862: (XSTFRC02) Column number for this SQL Cache must be between 1 and number. Specified column number number is invalid.

Reason for the Error ORA-36862: (XSTFRC02) Column number for this SQL Cache must be between 1 and number. Specified column number number is invalid.

Column Map references a column number that is greater than the maximum column number in SQL Cache

How to fix the Error ORA-36862: (XSTFRC02) Column number for this SQL Cache must be between 1 and number. Specified column number number is invalid. ?

You can fix this error in Oracle by following the below steps

Reference a correct column number. Normally, users should not call OLAP Random Access Cursor table function themselves and therefore should not encounter this error.