I am getting a weird problem while running one procedure .
Proc is like shown below :
procedure abc
IS
CURSOR xyz_cur IS
SELECT x
,y
,z
from temp
where y IN ('abc'.'pqr'.'def','sql','pqw')
for update nowait;
BEGIN
open xyz_cur ;
:
:
END abc;
now earlier the cursor query was without 'sql','pqw' .I have extented this IN statement with these two varchar values .And the table temp is having a check constaint on column y ,i have also extended the check constaints .
Now how can i resolve my problem ,it works well without the two value that i recently added .
What i have tried , i have analysed the table and rebuild the indexes but the still no luck .Please help me
An ORA-600 indicates an "Internal Error", which, in theory at least, you should never see.
In the first instance I'd suggest restarting your database.
If the problem persists after that I'd contact Oracle Support.