Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



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

Answer / guest

Cause: 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.

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-19851: OS error while managing auxiliary database string

1 Answers  


ORA-30647: error retrieving access parameters for external table string.string

1 Answers  


ORA-00911: invalid character

1 Answers  


RMAN-05010: target database must be opened in READ WRITE mode for TSPITR

1 Answers  


ORA-07705: sksaprs: device name buffer too small

1 Answers  






ORA-30430: list does not contain any valid summaries

1 Answers  


RMAN-00573: dbms_pipe.next_item_time returned unknown type code: number

1 Answers  


ORA-24348: Update or Delete without Where

1 Answers  


ORA-07624: smsdes: $DGBLSC failure

1 Answers  


ORA-08264: ora_addr: cannot close nameserver

1 Answers  


ORA-24201: duplicate publisher, publisher already added to the queue

1 Answers  


ORA-28667: USING INDEX option not allowed for the primary key of an IOT

1 Answers  






Categories