AnsweredAssumed Answered

Table Input with Oracle and values from previous step fails

Question asked by B241Q6DO on Nov 30, 2017
Latest reply on Nov 30, 2017 by Johan Hammink

Hi,

 

I have a Table Input step that is reading data from a Postgres database and returning just a single column and row in a string format

 

2017-11-30 15:29:02

 

I want to pass that value on to the next Table Input Step that is reading data from an Oracle database and the query is

 

SELECT name
FROM customer
where tmp_created >= TO_TIMESTAMP(?, 'YYYY-MM-DD HH24:MI:SS')

 

But I get this error message back

 

2017/11/30 14:38:45 - Table input 2.0 - SELECT name
FROM customer
where tmp_created >= TO_TIMESTAMP(?, 'YYYY-MM-DD HH24:MI:SS')
2017/11/30 14:38:45 - Table input 2.0 - ORA-30088: datetime/interval precision is out of range

Both Table Input steps are connected via Hop, 'Insert data from step' in 'Table Input 2.0' is set to 'Table Input' and Execute for each row is set to YES.

What am I missing here?!

Outcomes