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

ORA-01684: max # extents (string) reached in table string.string partition string

1 Answers  


ORA-16811: apply instance not recorded by the Data Guard broker

1 Answers  


ORA-25405: transaction status unknown

1 Answers  


ORA-01725: USERENV('COMMITSCN') not allowed here

1 Answers  


ORA-24804: Lob read/write functions called while another OCI LOB read/write streaming is in progress

1 Answers  


ORA-13774: insufficient privileges to select data from the workload repository

1 Answers  


ORA-00161: transaction branch length string is illegal (maximum allowed string)

1 Answers  


ORA-14046: a partition may be split into exactly two new partitions

1 Answers  


NNC-00425: meta-data violation

1 Answers  


ORA-22323: error table "string"."string" does not exist

1 Answers  


ORA-02208: duplicate MAXTRANS option specification

1 Answers  


ORA-01206: file is not part of this database - wrong database id

1 Answers  


Categories