Problem with multiple "not in " conditions in query
733894Nov 12 2009 — edited Nov 12 2009I am getting the following error when trying to execute a query with multiple 'not in' conditions. There are about 900 values in each condition (Total 3 conditions). I am quite sure that there is not problem with syntax as it is working when few of the values in the 'not in' condition are removed.
ORA-00600: internal error code, arguments: [KGHAL02],[0x0],[],[],[],[],[],[]
The query goes like this.
Select specimen_id, specimen_name from specimen,entity_type where specimen.entity_type_code = entity_type.entity_type_code where entity_type.entity_type = 'Sample' and specimen.specimen_id
not in ('A','B'...............) and specimen.specimen_id not in ('X','Y',............) and specimen.specimen_id not in ('AA','BB');
There are multiple not in conditions on same column as oracle does not support more than 1000 values in 'in' or 'not in' condition