Start of change

-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.

Start of changeExamples of places where parameter markers cannot be used:End of change

  • Start of changeAs an argument to some built-in functions.End of change
  • Start of changeIn the SELECT list of a scalar fullselect that is the sole argument of a scalar function.End of change
  • 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. Start of changeThe 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.End of change

SQLSTATE

42610

End of change