Re: 2 problems in using package........

Hi !

> > After the package is finish running, following message show:
> > ORA-01555:snapshot too old(rollback segment too small)
> > ORA-06512: at "USER.UPDATE_CCC", line 14
> >
> > 2) Could anyone tells me why such message show and how to
 solve this
> > problem?

Your rollback segment is small, it isn't able to provide the original state of TTT during the loop because of other user's DML statements. Increase rollback segments.

					Bye:
						Bert
-- 
                                           :
 ----.----,  ------------------------------:----------------------------
   --;----"-----,  ,--------,  ,--------,  |     Bertalan Gombos
     |          |  ;--------'  |           |    software engineer
  ---|----------'  `--------   |           |  bgombos_at_freemail.c3.hu
`----'  ---------------------------------  `------------------------ '98