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-00923: native compilation failed: string:string

1 Answers  


KUP-04074: no write access to directory object string

2 Answers  


RMAN-06213: --------------- ---------------------------------------------------

1 Answers  


ORA-28671: UPDATE BLOCK REFERENCES may not be used on a partitioned index as a whole

1 Answers  


ORA-38492: invalid ALTER INDEX parameters clause "string"

1 Answers  






DRG-11836: Expectation Failed

1 Answers  


TNS-01406: ID: string

1 Answers  


RMAN-06524: RMAN retention policy will be applied to the command

1 Answers  


SQL*Loader-00532: OCI return status: continue

1 Answers  


PLW-05003: same actual parameter(string and string) at IN and NOCOPY may have side effects

1 Answers  


ORA-30175: invalid type given for an argument

1 Answers  


PLS-00390: undefined column 'string' in INSERT statement

1 Answers  


Categories