transexception

Hello,

1) Why (or when) should one use TRANSEXCEPTION?

2) discard & exception both can be used (https://support.oracle.com/epmos/faces/CommunityDisplay?resultUrl=https%3A%2F%2Fcommunity.oracle.com%2Fthread%2F3393054&…). Similarly, can transdiscard & transexception also be used together to log the exceptions to a table as well to the discard file?

3) In case of transexception, what gets logged to the exception table:

  (a) those DMLs in the transaction that encountered an error

  (b) DMLs that did not encounter any error but were still not applied because those were part of the same transaction (which had some other DMLs encountering an error)