Hi Friends,
Kindly help me on this issue.
I have a package (not doing anything much complicated, But , Yes , it process HUGE data).
1. has a cursor Query , which fetches , Order number , Header ID, Org ID.(Cursor Query is not a complex Query almost straight forward)
2. Call An API (process order API) by passing these parameters.
3. If API returns <> SUCESS then ROLL BACK Else COMMIT.
But everytime we get ORA-01555: snapshot too old: rollback segment number 405 with name "_$" Error.
What Am I doing wrong here. (I checked couple of threads, but could not find anything much useful, Checked with our DBA too, but they said, its something wrong with my code, not the space issue).
I rewrote the code using bulk collect with limit 100 , still I get the same error after some point of time.
Kindly help,
Let me know , you need more information.
Thanks and Regards,
A