> On Wed, 11 Jun 2008, Christian Kuehn wrote:
>> warn set acl_m2 = ${lookup oracle{"GREYLIST_TEST"}{$value}{0}}
>>
>> 10:21:20 27795 ORACLE query failed: ORA-00900: Ungultige SQL-Anweisung
>
> Does it work if you remove the "" quote marks?
You are right, this is the syntax problem.
NOW:
17:19:24 19110 type=oracle key="SELECT 2 FROM DUAL"
17:19:24 19110 database lookup required for SELECT 2 FROM DUAL
17:19:24 19110 ORACLE query: SELECT 2 FROM DUAL
17:19:24 19110 ORACLE new connection: host=ora2000 database=ora2000
user=exim_gl
17:19:24 19110 lookup yielded:
17:19:24 19110 expanding: $value
17:19:24 19110 result:
17:19:24 19110 expanding: 0
17:19:24 19110 result: 0
17:19:24 19110 skipping: result is not used
17:19:24 19110 expanding: ${lookup oracle{SELECT 2 FROM DUAL}{$value}{0}}
17:19:24 19110 result:
There should be 2 in $value......
Christian
Tony Finch wrote:
--
Christian Kuehn
Manstadtsweg 8, 22309 Hamburg
Tel. +49 40 40197232
Fax. +49 40 40197230
eMail: christian@???
