ORA-18100: XUST0001 – Updating expression in a wrong position

You are here: Home // Oracle 11g // ORA-18100: XUST0001 – Updating expression in a wrong position

Cause: An updating expression was used in a position other than one of the following:

The topmost expression in the body of a query.
The MODIFY clause of a TRANSFORM expression.
The RETURN clause of a FLWOR expression.
The RETURN clauses of a TYPESWITCH expression in which every RETURN clause contains an updating expression, an empty expression ( ), or a call to the fn:error function.
The THEN and ELSE clauses of a conditional statement in which both the then and else clauses contain either an updating expression, an empty expression ( ), or a call to the fn:error function.
An operand of a comma expression in which each operand is either an updating expression, an empty expression ( ), or a call to the fn:error function.
The content of a parenthesized expression
The body of a function declaration in which the keyword UPDATING is specified.

See the solution below.

Error solution: None

Database version: Oracle 11g Release 2 (11.2)