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-09208: sftcls: error closing file

1 Answers  


LFI-00136: Unable to change type of open file.

1 Answers  


ORA-19722: datafile string is an incorrect version

1 Answers  


NID-00398: Changing database ID from number to number

1 Answers  


QSM-00795: the SQL Tuning Set repository has not been implemented

1 Answers  






ORA-28116: insufficient privileges to do direct path access

1 Answers  


PCB-00012: Command line option DYNAMIC=ANSI required with option TYPE_CODE=ANSI

1 Answers  


SQL-02154: Invalid or unset data type for host variable in ANSI Dynamic

1 Answers  


ORA-31045: Cannot store more than string extras outside the root XML node

1 Answers  


RMAN-08108: channel string: specifying block(s) to restore from backup set

1 Answers  


RMAN-06492: controlfile autobackup format "string" must specify a "string" format specifier

1 Answers  


ORA-00122: cannot initialize network configuration

1 Answers  


Categories