-
Resolving ORA-01841 error
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..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|