ORA-21779: duration not active , urgent!
Hi
I am getting errors at one place "ORA-21779: duration not active" error after we migrated from Oracle 10g database to Oracle 19c. This happens always in one place of code during batch runs (dbms scheduler jobs), but not for all items that we process.
This is the code part that that results in this exception.
So simple row update with returning value.
update acc_payment
set row = t6300.rec
where acc_payment_no = t6300.rec.acc_payment_no
returning record_version into t6300.rec.record_version;
I rewrote the update into UPDATE + SELECT INTO. But the update part still fails.
I am getting errors at one place "ORA-21779: duration not active" error after we migrated from Oracle 10g database to Oracle 19c. This happens always in one place of code during batch runs (dbms scheduler jobs), but not for all items that we process.
This is the code part that that results in this exception.
So simple row update with returning value.
update acc_payment
set row = t6300.rec
where acc_payment_no = t6300.rec.acc_payment_no
returning record_version into t6300.rec.record_version;
I rewrote the update into UPDATE + SELECT INTO. But the update part still fails.
0