SQL & PL/SQL

Hi All,

I am using Oracle 10 G Database. When i execute my package i am getting the below error:

ORA-01555: snapshot too old: rollback segment number 11 with name "_SYSSMU11$" too small

I am using one cursor , for every one record in cursor i am calling one related procedure , that procedure will execute in 10 mins to 2 hours. it all happen in the single loop for every record.

In what case i will get these error. My DBA increased the undo Size also.


Any suggestion for resolve this???


Thanks in Advance.

Cheers,
San