-418 A STATEMENT STRING TO BE PREPARED CONTAINS AN INVALID USE OF PARAMETER MARKERS
Explanation
The statement cannot be executed because a parameter marker has been used in an invalid way.
Examples of places where parameter markers cannot be used:
- As an argument to some built-in functions.
- In the SELECT list of a scalar fullselect that is the sole argument of a scalar function.
- In a concatenation operation.
- In the string expression of an EXECUTE IMMEDIATE SQL statement.
- In a result-expression in any CASE expression when all the other result-expressions are either NULL or untyped parameter markers.
- In a key-expression of an index definition.
- As an argument to an XMLEXISTS predicate.
System action
The statement cannot be processed.
Programmer response
Correct the logic of the application program so that this error does not occur. See the discussion of the PREPARE statement for information about the proper usage of parameter markers within SQL statements and for EXECUTE IMMEDIATE SQL statement restrictions. The PREPARE statement description includes tables that describe contexts where untyped parameter markers are supported in expressions, predicates, and statements. A CAST specification can be used in some cases to explicitly assign attributes to a parameter marker.
SQLSTATE
42610