Re: [exim] Exim & Oracle problems

Top Page
Delete this message
Reply to this message
Author: Christian Kuehn
Date:  
To: exim-users, dot
Subject: Re: [exim] Exim & Oracle problems
> 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@???