Oracle Error ORA-15247: cannot specify both WAIT and NOWAIT options in the same statement

Oracle Error Message

ORA-15247: cannot specify both WAIT and NOWAIT options in the same statement

Reason for the Error

An attempt was made to specify both WAIT and NOWAIT options in the same statement.

Solution

Revise the statement and include at most one option.