PLS-00639: NCHAR/NVARCHAR2 cannot be byte length semantics



PLS-00639: NCHAR/NVARCHAR2 cannot be byte length semantics..

Answer / guest

Cause: NCHAR/NVARCHAR can only be codepoint length sematics.
BYTE qualifiers used with NCHAR is illegal: nc NCHAR(7
BYTE); name NVARCHAR2(10 byte);

Action: Remove BYTE qualifier to make it as codepoint length
semantics

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

QSM-01057: no query rewrite for this DML expression

1 Answers  


ORA-24052: cannot propagate object type payloads with LOB attributes to an 8.0 release

1 Answers  


ORA-32308: object materialized views must use SELECT *

1 Answers  


ORA-32630: multiple assignment in automatic order MODEL

1 Answers  


ORA-27053: blocksize in file header not a multiple of logical block size

1 Answers  






ORA-33004: (XSAGDNGL01) workspace object is not a relationship array.

1 Answers  


DRG-10761: procedure string does not exist

1 Answers  


PLS-00924: native compilation is not supported on this platform

1 Answers  


ORA-28115: policy with check option violation

1 Answers   Wipro,


NNL-01060: Cache next checkpointed in: string

1 Answers  


ORA-21701: attempt to flush objects to different servers

1 Answers  


TNS-12688: Login failed: the SecurID server rejected the new pincode

1 Answers  


Categories