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?
Adwait ChitaleyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RindbaekSenior ConsultantCommented:
ORA-00600 should be checked with oracle through support.oracle.com
use this article: Troubleshoot an ORA-600 or ORA-7445 Error Using the Error Lookup Tool [ID 153788.1]

And it looks like you hit Bug# 5029528 thats fixed in the latest patchset so patch your system and it should disapear.

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.