Hello,
We are migrating from SQL Server to Oracle and were hoping to continue using case insensitive sort and comparison. But DBAs reported that our system was giving ORA600 errors because of this setting. So they changed it to case sensitive sort and case insensitive comparison. They said this prevents the ORA600 errors. But now our logic in the procedure is not working correct. Could this be because the indexes were built when the sort was case sensitive and now the sort setting is case insensitive? Also can you and should you even have conflicting setting on sort and comparison? It doesn't make sense to me.