General procedure is as follows:

Loop
The fetch l_cursor_fee_info
Into l_fee_info;
Exit the when l_cursor_fee_info % notfound;

.
The select Max (seq_id)
Into l_seq_id
The from fee_info t
Where id=a certain value;

.
End loop;
The problem is that the first cycle to A certain value for A, can take to seq_id second recycled into A, seq_id no at this moment, namely l_seq_id=null, what reason is this?? Urgent

CodePudding user response:

Are you sure two incoming the "A" is the same value? You can print each cycle the A value

CodePudding user response:

Will exit the when l_cursor_fee_info % notfound; To satisfy the condition and dropped out of the loop?

CodePudding user response:

Execute the select before, a print, an incoming value to see what is it

CodePudding user response:

Debugged, tracking once got it