Oracle Database Errors or Warnings from Error ORA-36976 to ORA-36986


ORA-36976: (XSRELGID00) Invlid GROUPINGID destination relation or variable workspace object.
Cause: Non-Object or invalid relation or invlid variable.
Action: Specify the valid relation or variable.
ORA-36977: (XSRELGID17) The GROUPINGID command does not support hierarchies with more than 126 levels.
Cause: The user specified a hierarchy with more than 126 levels.
Action: Decrease the number of levels in the hierarchy.
ORA-36978: (XSRELGID01) workspace object must be a self-relation.
Cause: Source relation is not a self-relation.
Action: Specify a self-relation as the source relation.

ORA-36979: (XSRELGID18) Property number can only be set by the GROUPINGID command.
Cause: You tried to set the $GID_DEPTH property.
Action: Stop to set the $GID_DEPTH property.
ORA-36980: (XSRELGID02) Variable workspace object must have a numeric data type.
Cause: The destination variable does not have a numeric data type.
Action: Make sure the variable is numeric.
ORA-36981: (XSRELGID19) The format of the GROUPINGID function is: GROUPINGID(gidrel1 [gidrel2]…)
Cause: Bad syntax
Action: Correct syntax

ORA-36982: (XSRELGID03) The destination variable/relation workspace object must be dimensioned by all dimensions of the source relation workspace object that have more than one value in status.
Cause: Destination variable/relation does not have enough dimensionality to hold the result from the multi-dimensional source relation.
Action: Either limit the status of hierarchy dimensions or redefine the destination variable/relation with the extended dimensionality
ORA-36983: (XSRELGID20) The groupingid relation workspace object repeats.
Cause: The groupingid relation repeated.
Action: Remove the duplicated groupingid relation.
ORA-36985: (XSRELGID21) The source relation can be omitted only when using both surrogate GID and level order valueset.
Cause: Source relation was not specified.
Action: Specify the source relation or both surrogate gid and level order valueset.
ORA-36986: (XSRELGID05) Relation workspace object must be dimensioned by workspace object.
Cause: The destination relation is not dimensioned by the dimension of the source relation.
Action: Redefine the destination relation or choose another relation with the correct dimensionality.

Above are list of Oracle Database Errors or Warnings from Error ORA-36976 to ORA-36986 received while performing certain operation against Oracle Database or related products.

What are atOracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Dabase Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *