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

RMAN-08116: output filename is original SPFILE location

1 Answers  


ORA-22980: must specify a set of attributes for the WITH OBJECT OID clause

1 Answers  


ORA-19320: Host name not specified in HTTP URL

1 Answers  


ORA-07271: spwat: invalid oracle process number.

1 Answers  


ORA-23377: bad name string for missing_rows_oname1 argument

1 Answers  


ORA-02770: Total number of blocks is invalid

1 Answers  


QSM-01124: set operator materialized view, string, doesn't have a marker column

1 Answers  


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

1 Answers  


ORA-15091: operation incompatible with open handle in this session

1 Answers  


ORA-00231: snapshot controlfile has not been named

1 Answers  


LFI-00148: %s can be called only on files opened in byte mode

1 Answers  


ORA-14095: ALTER TABLE EXCHANGE requires a non-partitioned, non-clustered table

1 Answers  


Categories