CDC by tsetGlobalVar

[Anonymous]

Hi everyone 

i want to ask a question to  you i know it is simple but i am a beginner 

i want to create a job to capture cdc from oracle database on column name updated_date but when i  run the job i encountered an error such as screen shot

[Anonymous]

Hi,

it seems to be a problem in your sql request.

Stéphane

[Anonymous]

this is my query is there anything wrong

"select * from table1 where updated_date>TO_DATE("+"'"+globalMap.get("myKey").toString()+"'"+",'yyyy-MM-dd hh24:mi:ss')"

[Anonymous · Accepted solution]

i found the the mistake i changed the tmap_2 component to tconverttype because when i check the myKey paramters via tjavaRow myKey value was equal to   "Sat Aug 31 03:47:09 EEST 2013" 

when i changed the tmap2 component to tconvertype and date to string everything is fine now