Forum Stats

  • 3,851,526 Users
  • 2,263,993 Discussions
  • 7,904,769 Comments

Discussions

HELP - Refresh variable - ORA-00920: invalid relational operator

Meapri-Oracle
Meapri-Oracle Member Posts: 65
edited Feb 26, 2009 9:58AM in Data Integrator
I created a variable to be used as a filter. When the LKM runs it fails at the first step with the ORA-00920: invalid relational operator.
ODI cannot parse the syntax of the variable. I don't know where the error is . Has someone already encountered this king of error ?

Thanks Meapri.

edit : The Variable is :

- alphanumeric
- historic
- in (select business_unit from SYSADM.PS_S1_ODI_FILTR_BU)

The generated SQL :

create or replace view SYSADM_ODI.C$_0BCT_CTL
(
C1_BUSINESS_UNIT,
C2_EIP_CTL_ID,
C3_TRANS_PROGRAM,
C4_TRANSACTION_CODE,
C5_DT_TIMESTAMP,
C6_BCT_STATUS,
C7_BCT_SOURCE,
C8_PROCESS_INSTANCE,
C9_OPRID,
C10_DEVICE_ID,
C11_DEVICE_LAST_SEQ,
C12_DEVICE_DTTIME,
C13_EIP_TRANS_SRC_REF,
C14_EIP_TRANS_SRC,
C15_PUBNODE,
C16_CHNLNAME,
C17_PUBID,
C18_MSGNAME,
C19_SUBNAME,
C20_ERRORS_FLG,
C21_PARTIAL_FLG
)
as select
BCT_CT.BUSINESS_UNIT,
BCT_CT.EIP_CTL_ID,
BCT_CT.TRANS_PROGRAM,
BCT_CT.TRANSACTION_CODE,
BCT_CT.DT_TIMESTAMP,
BCT_CT.BCT_STATUS,
BCT_CT.BCT_SOURCE,
BCT_CT.PROCESS_INSTANCE,
BCT_CT.OPRID,
BCT_CT.DEVICE_ID,
BCT_CT.DEVICE_LAST_SEQ,
BCT_CT.DEVICE_DTTIME,
BCT_CT.EIP_TRANS_SRC_REF,
BCT_CT.EIP_TRANS_SRC,
BCT_CT.PUBNODE,
BCT_CT.CHNLNAME,
BCT_CT.PUBID,
BCT_CT.MSGNAME,
BCT_CT.SUBNAME,
BCT_CT.ERRORS_FLG,
BCT_CT.PARTIAL_FLG
from SYSADM.PS_BCT_CTL BCT_CT
where (1=1)
And (BCT_CT.BUSINESS_UNIT #JDC2_v2.ALL_BU)

Edited by: Meapri on Nov 21, 2008 8:38 AM
Tagged:

Answers

This discussion has been closed.