Oracle Error ORA-36702: (XSRELTBL05) The format of the HIERHEIGHT function is: HIERHEIGHT(relation [,] level) level >= 1.

Oracle Error Message

ORA-36702: (XSRELTBL05) The format of the HIERHEIGHT function is: HIERHEIGHT(relation [,] level) level >= 1.

Reason for the Error

The HIERHEIGHT function was specified incorrectly.

Solution

Make sure the format is correct.