Oracle Error Message
ORA-18100: XUST0001 – Updating expression in a wrong position
Reason for the Error
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.
Solution
None
