Ora

Anonymous — Thu, 03 Aug 2017 07:49:27 GMT

Hi Team,

I am trying load into the target using incremental load. Attached screen shot for your references.

Main job: I am reading date values from reference table (test_src) and storing into the context variable.

-------------------------------------------------------------

Query: tOralce_1

SELECT
INCR_LOAD.INCR_DATE1
FROM INCR_LOAD
where INCR_LOAD.TBL_NAME='test_src'"

------------------------------------------------------------

And,Subjob based on date values is >(greater than context variable load into target table.) while doing i am getting below error.

Exception in component tOracleInput_2
java.sql.SQLDataException: ORA-01858: a non-numeric character was found where a numeric was expected

Query: tOracle_2

"SELECT
TRN_REF_NO,
TXN_DT,
FROM TEST_SRC
WHERE xxx_TEST_SRC.TXN_DT >= ' "+context.Incrementaldate1+" ' "

Any suggestion on query.

Thanks

Shridhar

Re: Ora

cterenzi — Thu, 03 Aug 2017 14:24:08 GMT

You may need to wrap your date variable with to_date.

Anonymous — Fri, 04 Aug 2017 02:16:16 GMT

Hi,

I am tried with to_date still same issue.

Can you please send me full syntax?

Thanks

Shridhar