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


PLS-00566: type name "string" cannot be constrained



PLS-00566: type name "string" cannot be constrained..

Answer / guest

Cause: A lob, date, boolean, rowid, or mlslabel type was
constrained with a length specification. For example: X BLOB(5);

Action: Remove the constraint.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00560: error reading file

1 Answers  


ORA-26093: input data column size (number) exceeds the maximum input size (number)

1 Answers  


PLS-00713: attempting to instantiate a type that is NOT INSTANTIABLE

1 Answers  


PCC-02332: attempted to redefine SQL identifier

1 Answers  


EXP-00040: Dump file and log file must be different

1 Answers  






ORA-00391: All threads must switch to new log format at the same time

1 Answers  


LFI-00148: %s can be called only on files opened in byte mode

1 Answers  


ORA-30926: unable to get a stable set of rows in the source tables

2 Answers  


NNL-00007: server responded with an error

1 Answers  


CLSR-00509: Unable to initialize NLS

1 Answers  


ORA-14008: missing THAN keyword

1 Answers  


ORA-02032: clustered tables cannot be used before the cluster index is built

1 Answers  






Categories