HELP! Going crazy: OCI bind strange results

From: Roger Loeb <rloeb_at_martech.com>
Date: Fri, 1 May 1998 14:36:47 -0600
Message-ID: <6idbp0$114$1@news1.rmi.net>

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

I've been fighting this for two days, and I'm going crazy (crazier?) Any ideas gratefully accepted.

Rog

--
roger@_delete_this_to_reply_.martech.com Received on Fri May 01 1998 - 15:36:47 CDT