How to fix the Oracle error PLS-00729: only widening of the collection element type is allowed?

In this post, you’ll learn more about the Oracle ErrorPLS-00729: only widening of the collection element type is allowed with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00729: only widening of the collection element type is allowed

Reason for the Error PLS-00729: only widening of the collection element type is allowed

Modification to the collection element type did not widen its constraints or attempted to change the type of the element. For NUMBER types, scale and precision can be changed to allow increase in number of digits after and before the decimal point. For VARCHAR2 and RAW type attributes the size can be increased.

How to fix the Error PLS-00729: only widening of the collection element type is allowed ?

You can fix this error in Oracle by following the below steps

Change the constraint specification so as to widen the existing constraints.