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

ORA-28027: privileged database links may be used by global users

1 Answers  


ORA-24786: separated transaction has been completed

1 Answers  


ORA-24950: unregister failed, registeration not found

1 Answers  


ORA-34802: (OCI11) OLAP OCI operation caused ROLLBACK past an UPDATE of an attached analytic workspace. Current operation canceled.

1 Answers  


ORA-32761: Turn off Temp LOB Ref Count Feature

1 Answers  






IMG-00587: output format does not support the specified scanlineOrder

1 Answers  


QSM-00510: statistics missing on materialized views

1 Answers  


ORA-29315: tablespace 'string' has been recreated

1 Answers  


ORA-01942: IDENTIFIED BY and EXTERNALLY cannot both be specified

1 Answers  


ORA-06432: ssaio: Buffer Not Aligned

1 Answers  


ORA-39700: database must be opened with UPGRADE option

2 Answers  


ORA-13756: Cannot update attribute "string".

1 Answers  


Categories