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

ORA-26076: cannot set or reset value after direct path structure is allocated

0 Answers  


NNO-00157: warning: hint number has invalid address, hint ignored

1 Answers  


DRG-11707: valid relations: string

1 Answers  


PLS-00219: label 'string' reference is out of scope

1 Answers  


ORA-16734: Error executing dbms_logstdby.skip_error procedure

1 Answers  






ORA-08180: no snapshot found based on specified time

1 Answers  


ORA-01029: internal two task error

1 Answers  


NZE-28818: No package context provided.

1 Answers  


ORA-23350: maximum number of recursive calls exceeded

1 Answers  


ORA-06503: PL/SQL: Function returned without value

1 Answers  


ORA-09283: sllfsk: error skipping records

1 Answers  


ORA-09808: Could not obtain user clearance.

1 Answers  


Categories