Ora

Seven Stars

Ora

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

 

Ten Stars

Re: Ora

You may need to wrap your date variable with to_date.
Seven Stars

Re: Ora

Hi,

 

I am tried with to_date still same issue.

 

Can you please send me full syntax?

 

Thanks

Shridhar

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads