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

PCB-00300: Datatype for host variable not supported by ANSI "string"

1 Answers  


ORA-28665: table and partition must have same compression attribute

1 Answers  


LPX-00223: external entity "~s" found in an attribute value

1 Answers  


TNS-01305: nt main err code: number

1 Answers  


ORA-16016: archived log for thread string sequence# string unavailable

1 Answers  






ORA-13430: the GeoRaster object has null attribute(s)

1 Answers  


ORA-01983: invalid auditing option for DEFAULT

1 Answers  


ORA-30747: cannot create substitutable tables or columns of non final type string.string

1 Answers  


ORA-30029: no active undo tablespace assigned to instance

1 Answers  


ORA-12805: parallel query server died unexpectedly

1 Answers  


NID-00142: Only changing database name, previous attempt changed dbid to number

1 Answers  


EXP-00076: multiple devices specified for tape output

1 Answers  


Categories