Oracle Error ORA-14102: only one LOGGING or NOLOGGING clause may be specified

Oracle Error Message

ORA-14102: only one LOGGING or NOLOGGING clause may be specified

Reason for the Error

LOGGING was specified more than once, NOLOGGING was specified more than once, or both LOGGING and NOLOGGING were specified.

Solution

Remove all but one of the LOGGING or NOLOGGING clauses and reissue the statement.