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

LPX-00001: NULL pointer

1 Answers  


SQL*Loader-00406: If data is all generated, number to load cannot be ALL

1 Answers  


TNS-01073: Listening on: string

1 Answers  


ORA-06792: TLI Driver: server cannot exec oracle

1 Answers  


NNO-00070: administrative region has changed, reloading domain data

1 Answers  






ORA-02195: Attempt to create string object in a string tablespace

1 Answers  


PCC-02412: FOR clause not permitted in OBJECT GET or SET statement

1 Answers  


ORA-01607: cannot add logfile to the specified instance

1 Answers  


ORA-22982: cannot create sub-view under this view

1 Answers  


ORA-32775: cannot change size attributes of read only tablespace string

1 Answers  


ORA-24198: attempt to use an invalid operation ID

1 Answers  


NID-00415: Change of database name and database ID failed.

1 Answers  


Categories