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

Question Posted / guest

1 Answers
2793 Views
I also Faced
E-Mail Answers

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

ORA-12997: cannot drop primary key column from an index-organized table

1 Answers

ORA-02445: Exceptions table not found

1 Answers

NZE-29195: CRL is expired

1 Answers

UDI-00012: table mode imports only allow objects from one schema

1 Answers

PCC-00136: Invalid SQL_CURSOR declaration

1 Answers

ORA-39709: incomplete component downgrade; string downgrade aborted

1 Answers

PCC-01012: DATA DIVISION not found

1 Answers

NID-00321: Proceeding with operation

1 Answers

ORA-19567: cannot shrink file string because it is being backed up or copied

1 Answers

PROT-00018: Failed to open file

1 Answers

ORA-38420: invalid stored attribute sub-expression: string

1 Answers

RMAN-06469: could not translate corruption list

1 Answers

For more Oracle Errors Interview Questions Click Here