Hi,

Please find the procedure below,

create or replace procedure Update1 is

Cursor Cur1 Is
Select NO From MASTER;

RecordCounter Number := 0;

begin

For FM In Cur1
Loop
Update /*+ parallel 8 */ MASTER Set
dateofbirth = To_Date((dateofbirth + 30),'DD/MM/YYYY'),
Where NO = FM.NO;

RecordCounter := RecordCounter + 1;

If RecordCounter >= 10000 then
Commit;
RecordCounter := 0;
End If;
End Loop;

Commit;

end Update1;


while executing this procedure,I'm getting the following error,

ERROR at line 1:
ORA-01841: (full) year must be between -4713 and +9999, and not be 0
ORA-06512: at "UPDATE1", line 13
ORA-06512: at line 1


How to resolve this error?

Thanks..