Re: Using parameter values in WHERE clause

From: SoulSurvivor <markyg_7_at_yahoo.co.uk>
Date: 1 May 2003 07:03:42 -0700
Message-ID: <8d9c6fd.0305010603.ca1a13a_at_posting.google.com>


Can you give an example. Result can be different depending on how you are doing it.

M

tim.webster_at_bt.com (Tim) wrote in message news:<9ea6cfd9.0304300750.f3b8f2c_at_posting.google.com>...
> has anyone ever had a problem using a parameter value in a where
> clause, as opposed to a static string? I have an issue where if I use
> a parameter value, the clause seems to be ignored, while if I put in a
> static string, or assign the parameter to a local varible and use that
> instead, it works fine.
>
> If I print out the value of the parameter in my debugging log, it
> looks totally fine as well.
>
> Although there are easy workarounds for the problem, it's baffling me
> and I would like to know if anyone else has ever seen this. I
> certainly haven't in my roughly 4 years Oracle experience.
>
> Thanks
Received on Thu May 01 2003 - 16:03:42 CEST

Original text of this message