Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> HELP! Going crazy: OCI bind strange results
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
![]() |
![]() |