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-00981: cannot mix table and system auditing options

1 Answers  


ORA-32408: materialized view log on "string"."string" already has new values

1 Answers  


ORA-01612: instance string (thread string) is already enabled

1 Answers  


ORA-00260: cannot find online log sequence string for thread string

1 Answers  


TNS-00125: Failed to get number of Interchanges in TNSNET.ORA

1 Answers  


ORA-30451: internal error

1 Answers  


ORA-29371: pending area is not active

1 Answers  


ORA-02212: duplicate PCTFREE option specification

1 Answers  


ORA-16032: parameter string destination string cannot be translated

1 Answers  


ORA-34276: (MXDCL33) (Precision, Scale) arguments can only be used with a NUMBER variable or dimension.

1 Answers  


ORA-16523: Operation requires the client to connect to instance "string".

1 Answers  


ORA-12212: TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA

1 Answers  


Categories