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

QSM-02034: no joins are present in the HAVING clause

1 Answers  


IMG-00803: invalid attribute value

1 Answers  


PLS-00324: cursor attribute may not be applied to non-cursor 'string'

1 Answers  


ORA-29517: recursive resolution failed for a referenced class

1 Answers  


ORA-30728: maximum number of columns exceeded

1 Answers  


ORA-07426: spstp: cannot obtain the location of dbs directory.

1 Answers  


LPX-00124: attribute value should be one or more tokens

1 Answers  


NID-00407: Reversion of database ID failed.

1 Answers  


RMAN-20222: datafilename not found in recovery catalog or is ambiguous

1 Answers  


ORA-24015: cannot create QUEUE_TABLE, QUEUE_PAYLOAD_TYPE string.string does not exist

1 Answers  


ORA-22314: method information mismatch in ALTER TYPE

1 Answers  


ORA-09832: infoCallback: bad message format.

1 Answers  


Categories