Oracle Error Message
PLS-00729: only widening of the collection element type is allowed
Reason for the Error
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.
Solution
Change the constraint specification so as to widen the existing constraints.
