Re: Like operator and Parameter
From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sat, 23 Apr 2005 12:34:31 -0700
Message-ID: <1114284634.204157_at_yasure>
>
>
> i assume this is a query within Oracle Reports
>
> please be more specific on how it does not work -- the syntax certainly
> looks correct. are you perhaps running in a case-sensitive issue? what value
> are you supplying for the parameter, what results are you expecting, and
> what results are you getting?
>
> ++ mcs
Date: Sat, 23 Apr 2005 12:34:31 -0700
Message-ID: <1114284634.204157_at_yasure>
Mark C. Stock wrote:
> "OraRepDvlpr" <itsashok_at_gmail.com> wrote in message
> news:1114208034.007157.35620_at_z14g2000cwz.googlegroups.com...
>
>>Hi group, >>I am new to oracle reports and currently going thru the learning >>curve. I need to use a parameter in Parameter Form in SQL clause. >> >>SELECT a,b,c from TD where TD.e like '%'||:p_from_Form||'%' >> >>The above SQL does not work. >>Any idea >>
>
>
> i assume this is a query within Oracle Reports
>
> please be more specific on how it does not work -- the syntax certainly
> looks correct. are you perhaps running in a case-sensitive issue? what value
> are you supplying for the parameter, what results are you expecting, and
> what results are you getting?
>
> ++ mcs
It is syntactically correct for Oracle Reports. The only problem I saw with it was possibly putting it in the wrong place or not properly constructing the user defined parameter.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Sat Apr 23 2005 - 21:34:31 CEST