PLS-00542: CLOB and NCLOB cannot use varying-width character
sets in the server



PLS-00542: CLOB and NCLOB cannot use varying-width character sets in the server..

Answer / guest

Cause: A server type is being created with an embedded CLOB
or NCLOB atttribute which uses a varying-width character set.

Action: Use VARCHAR2 instead of CLOB, or use a fixed-width
character set.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06099: error occurred in source file: string, line: number

1 Answers  


ORA-02290: check constraint (string.string) violated

1 Answers  


ORA-32762: Turn on Temp LOB Ref Count Tracing

1 Answers  


PCB-00301: Use of non-ANSI function is an Oracle extension

1 Answers  


RMAN-10026: network error number-number occurred registering connection

1 Answers  






ORA-28002: the password will expire within string days

1 Answers  


QSM-01035: a row level security policy exists on this table

1 Answers  


TNS-12201: TNS:encountered too small a connection buffer

1 Answers  


ORA-27302: failure occurred at: string

1 Answers  


ORA-22931: MOVE of nested table to a different tablespace not supported

1 Answers  


PLS-00570: different number of columns in the multiset and cast expressions

1 Answers  


ORA-16180: number processes specified for MAX_PARALLEL_SERVERS is too small

1 Answers  


Categories