ORA-07445:lxucStCol lxsStrCol .. AL32UTF8 NLS_SORT=GENERIC_M SELECT QUERY (Doc ID 736596.1)

Last updated on JUNE 13, 2013

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3
This problem can occur on any platform.

Symptoms

Query failed with ORA-7445 lxucStCol lxsStrCol .... when order by clause was used, especially with 
AL32UTF8 NLS_SORT=GENERIC_M SELECT QUERY 
For example : 
Without setting  NLS_SORT=GENERIC_M 
The query may complete running and return something like:   
    
    
select ''''||rowid||''''||',',<columns> from <table> order by <column> 
      
'AAAMvGAAEAAAApqAAA', zsurgeon    <---- normal data 
'AAAMvGAAEAAAAZ4AAA', { ?L??????? ????????????? = ??r???} <---- rows contain ignorable data or uncomposed characters
....
          
        
        
'AAAMvGAAEAAAAhSAAA', ??? J3?F ? ?4i0 ? ????
'AAAMvGAAEAAAAX6AAA', ?? R?D?RIC? ??
'AAAMvGAAEAAAA8oAAA', ???Good Spy\Cr4ck3r???

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms