MIHIR KAR
asked on
oracle _plsql
Hii experts
I'm to updateing 10k rows, due to some bad data it rollback the hole transaction how can i made it sucessfuly without terminate
the transaction and i want to track in which row exactly the transaction rollback .
Your suggestion will be appreciated
Thnks in advance
I'm to updateing 10k rows, due to some bad data it rollback the hole transaction how can i made it sucessfuly without terminate
the transaction and i want to track in which row exactly the transaction rollback .
Your suggestion will be appreciated
Thnks in advance
You will need to identify the cause(s) of the error and then alter the update to cater for the cause(s).
As stated already getting the actual error message would be a good start.
As stated already getting the actual error message would be a good start.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Without knowing all the details, I would suggest using the same solution that was suggested in your previous question for INSERT (here). Use the LOG ERRORS clause of UPDATE. It works the same way.
ASKER
In this case i'm updateing inside a plsql block . Due to " nulls " the transaction getting rollback. I want to save that exception in runtime without
terminate the update process .
terminate the update process .
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
what is error?