Same inclusions, Oracle, circulation field, data is the same,
Inclusions in nine process, both to perform
Inclusions separate out perform data no problem one day, it's no problem for me to put in the loop execution for a few days
But perform two months of data is part of the number of days before the meeting is no problem, the nine processes are executed; At the back of the data is executed only eight, seven, five process, finally all become only perform
And this part number is not fixed,
Perform error behind those days alone perform the same inclusions can perform nine process, and the data is correct,


Consult a great god ever met, how to deal with,,,

CodePudding user response:

1. Why do you need to cycle? Estimation problem is in the loop,
Part 2. The cycle can post code?

CodePudding user response:

Declare
='20170901' n varchar2 (10) :
The begin
For I in 1.. 60 loop
Cims_ic. P_shjfsc (' 31102 ', n);
N:=to_char (to_date (n, 'yyyymmdd') + 1, 'yyyymmdd');
End loop;
The end;



The problem is that the cycle I run 10 times no problem, run 2 times is no problem, I ran 60 times 20 times before all is right,

CodePudding user response:

With date will after 20170920, the data conflict?

CodePudding user response:

reference 1st floor qq646748739 response:

1. Why do you need to cycle? Estimation problem is in the loop,
Part 2. The cycle can post code?

Declare
='20170901' n varchar2 (10) :
The begin
For I in 1.. 60 loop
Cims_ic. P_shjfsc (' 31102 ', n);
N:=to_char (to_date (n, 'yyyymmdd') + 1, 'yyyymmdd');
End loop;
The end;



The problem is that the cycle I run 10 times no problem, run 2 times is no problem, I ran 60 times 20 times before all is right,

CodePudding user response:

reference qq646748739 reply: 3/f

will after 20170920, the data conflict with date?

Not, it is other formal data library ogg, there was a problem there is a problem

CodePudding user response:

reference qq646748739 reply: 3/f

will after 20170920, the data conflict with date?

And very oddly, when I was throwing running on Friday, the same script, the same inclusions, the same into arguments, only the first ten or eleven days of data is accurate, the back is just like the problem now, the pit is the last few days had a process didn't succeed, or didn't, because we have a table is to record every day of the operation of each process, let alone run inside a success, even running record of all have no,,,,