This content has been marked as final. Show 6 replies
That's the standard behavior I believe.
Web ADI call the PL SQL for each row.
if everything is successfully then commit, if there is even one single error, rollback - you should not set a commit or a rollback in your code.
All records are processed so that the user know which ones have to be corrected or excluded.
Thanks for your response.
I call a standard API from plsql. Std API does a COMMIT automatically. So, I don't have any control on this although my wrapper doesn't COMMIT anything.
What's more worse is I don't get a green smiley for the records that are processed.
If there 20 records and all 20 are success, then I get green smiley for all.
But if one fails, I don't get green smileys.
Is there anything I can do about this.