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

In this post, you’ll learn more about the Oracle ErrorORA-36702: (XSRELTBL05) The format of the HIERHEIGHT function is: HIERHEIGHT(relation [,] level) level >= 1. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

The HIERHEIGHT function was specified incorrectly.

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

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

Make sure the format is correct.

Tags :

Leave Your Comment