I have a simple SELECT statement with two input variables, e.g., "SELECT
FROM OURTABLE WHERE ZIP3=:zip3 AND LASTNAME LIKE :surname"
I bind this two variables to input data targets (of the appropriate length)
and execute the statement. I get no rows back. If I hard code the
statement with the SAME data, e.g., SELECT FROM OURTABLE WHERE ZIP3=731 AND
LASTNAME LIKE 'LAB%'" (that's a single quote, then a double quote), then I
get 400 rows back.
I know the bind is working because I can see the bind data in the TRACE
I've been fighting this for two days, and I'm going crazy (crazier?) Any
ideas gratefully accepted.