ORA-00600: [qctchr : Bfl] When Create View And NLS_LENGTH_SEMANTICS=CHAR Is Used

(Doc ID 2350748.1)

Last updated on FEBRUARY 15, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Create view when NLS_LENGTH_SEMANTICS=CHAR is set , fails with ORA-00600: internal error code, arguments: [qctchr : bfl], [40], [6], [1],[873], [3], [10], [], [], [], [], []
 

CALL STACK contains:
--------------------------

The error is reproducible when ALL the below conditions are met:

- nls_length_semantics=char
- use of xmltable in the view creation
- use of no_merge hint
- use cast to a varchar size larger than the table field size

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