I've been using APEX ever since version 4, and I remember making Classic Reports with queries like "select b, c, d from my_table where a = :P1_A_VALUE"
:P1_A_VALUE might have been created on page 1 as a static value for page item P1_A_VALUE, with a value of say, 'shoes', always set regardless of session state. So, in my report I would have retrieved the b, c, d records from my_table where a = 'shoes'.
When I do this in 19, the app server crashes with a 500 error, and the java crash report in the Tomcat logs is tremendous, though unhelpful.
If I write the query as "select b, c, d from my_table where a = 'shoes', it works fine. If I can somehow write the where clause with a function somehow, like "where a = func(z)", where func(z) returns 'shoes', it also works fine. Only if I use the bind variable :P1_A_VALUE in the query does it break.
Has the behavior of APEX changed in the last couple of releases? I went from 5 to 19, so many things could have happened.
Thanks for any tips.