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


PLS-00506: User Defined Constrained Subtypes are disallowed



PLS-00506: User Defined Constrained Subtypes are disallowed..

Answer / guest

Cause: An attempt was made to define a constrained subtype,
but only unconstrained subtypes are allowed in this release
of PL/SQL. For example, the following type definition is
illegal: SUBTYPE Acronym IS VARCHAR2(5); -- illegal

Action: Remove the illegal type constraint.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00655: only functions can be declared as PIPELINED

1 Answers  


ORA-19642: incremental-start SCN is string

1 Answers  


ORA-12659: Error received from other process

1 Answers  


ORA-12807: process queue could not receive parallel query message

1 Answers  


LSX-00342: value of attribute "base" must be a complex type definition

1 Answers  






ORA-36976: (XSRELGID00) The format of the GROUPINGID command is: GROUPINGID [relation1] INTO {variable | relation2 | surrogate} [USING levelrelation] [INHIERARCHY {inhvariable | valueset}] [LEVELORDER levelordervs] The source relation can be omitted only when using both surrogate gid and level order valueset.

1 Answers  


ORA-04086: trigger description too long, move comments into triggering code

1 Answers  


ORA-24779: detach not allowed with open remote cursor

1 Answers  


ORA-07393: unable to delete text file

1 Answers  


O2I-00125: Error writing to the INITFILE file

1 Answers  


SQL*Loader-00429: insufficient number of elements found for varray

1 Answers  


RMAN-06015: error while looking up datafilecopy name: string

1 Answers  






Categories