ORA-00600: internal error code
ERROR at line 2:
ORA-00600: internal error code, arguments: [qkacon:qkaconGetPathOps:1
The above error is received in Oracle 10g Release 2 in the following case:
1) When a column in VIEW A is made from an expression using the function SYS_CONNECT_BY_PRIOR and...
2) Such field of View A is used in View B in a column which itself is made up of an expression.
The error does not occur when the field in VIEW A is used AS IS in View B. However, when we try and use the Field in View A as a part of an expression in View B, the error occurs.
Any workarounds to generate a single column in View B using such field in View A with an expression?
ORA-00600: internal error code, arguments: [qkacon:qkaconGetPathOps:1
The above error is received in Oracle 10g Release 2 in the following case:
1) When a column in VIEW A is made from an expression using the function SYS_CONNECT_BY_PRIOR and...
2) Such field of View A is used in View B in a column which itself is made up of an expression.
The error does not occur when the field in VIEW A is used AS IS in View B. However, when we try and use the Field in View A as a part of an expression in View B, the error occurs.
Any workarounds to generate a single column in View B using such field in View A with an expression?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.