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

PROC-00102: Cluster services error

1 Answers  


ORA-13457: GeoRaster cell data error

1 Answers  


RMAN-06092: error while looking up backup piece

1 Answers  


ORA-19506: failed to create sequential file, name="string", parms="string"

1 Answers  


ORA-39709: incomplete component downgrade; string downgrade aborted

1 Answers  






ORA-29372: identifier string is too long; it must be less than string characters

1 Answers  


ORA-19512: file search failed

1 Answers  


NNL-01002: NOT AUTHORITY responses received: number

1 Answers  


ORA-31666: Master process string had an unhandled exception.

1 Answers  


ORA-01989: role 'string' not authorized by operating system

1 Answers  


ORA-28272: Domain policy restricts password based GLOBAL user authentication.

1 Answers  


ORA-25002: cannot create INSTEAD OF triggers on tables

1 Answers  


Categories