Host variables are used in 'Prepared' statements. The reason for that isas
the name suggests, they are prepared. ie they are created before they areparameter
run, and when run, the host variables are passed to the already prepared
statement as input values.
This is basically for performance reasons, as the prepared statement can
then be reused multiple times efficiently
Okay, I've found where is says that it's not allowed.
The select-statement must not refer to variables or include
But why, I dont see the explaination why? I'm not seeing why the
would care if I use a hard coded value or a host variable to select