Rick Macguigan 15.Mar.13 08:15 PM a Web browser LEILEI - 8.0Windows
Domino server and LEI running on :
Lotus Domino (r) Server (64 Bit) (Release 8.5.3FP3 for Windows/64)
03/15/2013 12:43:53 PM
Using Oracle 11.2.03
Trying to build a new replication activity which works OK. However, refining the activity using the conditional clause to return less rows is failing.
Getting the following error on the LEI log:
Method -Connect-
03/15/2013 12:39:54 PMError: [Execute Statement]ORA-00936: missing
expression, Connector '(PROD) SENPROD MKTG Connection
(UW_Contract_Summary)', Method -Select- (936)
03/15/2013 12:40:12 PMActivity Ended With An Error
I am able to query the table in PL SQL Developer using:
select distinct CEDENT_NAME, CEDENT_ACTIVE
from reports.UW_CONTRACT_SUMMARY
ORDER BY CEDENT_NAME, CEDENT_ACTIVE
In LEI have tried the following with same error:
select distinct CEDENT_NAME, CEDENT_ACTIVE
ORDER BY CEDENT_NAME, CEDENT_ACTIVE
distinct CEDENT_NAME, CEDENT_ACTIVE
ORDER BY CEDENT_NAME, CEDENT_ACTIVE
Return to top
LEi Conditional Clause SQL statemen... (Rick Macguigan 15.Mar.13)
. . 
Print this page
