Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

AMD-00155: Object to delete "string" does not exist in Workspace "string"

1 Answers  


ORA-09211: sfwfb: error writing to file

1 Answers  


ORA-37078: (XSMCSESS06) The dimension being maintained (workspace object) cannot also be used as a step dimension.

1 Answers  


TNS-00298: Request to Navigator: string

1 Answers  


ORA-21710: argument is expecting a valid memory address of an object

1 Answers  






DRG-10800: query failed: string string string

1 Answers  


ORA-16794: Database Guard is ON for primary database

1 Answers  


TNS-00114: Internal error- Allocation of addresses not performed

1 Answers  


SQL*Loader-00134: invalid option specified for EXTERNAL_TABLE parameter

1 Answers  


ORA-06742: TLI Driver: cannot alloc t_bind

1 Answers  


ORA-02069: global_names parameter must be set to TRUE for this operation

1 Answers  


DRG-11714: synonyms have different Broader Terms

1 Answers  


Categories