978154 wrote:My bet? The SQL is a query used for a cursor, and that as you loop through the rows you have a COMMIT. You can have an undo tablespace the size of Jupiter, and still no guarantee that the procedure will succeed. You need to move the COMMIT tol after you close the cursor.
Getting the below error for the query
ORA-01555 caused by SQL statement below (SQL ID: 1c49b7v6uxw5q, Query Duration=252432 sec, SCN: 0x0006.beb04f13):