Hi experts,
I'm new to ODI kindly provide me your inputs on below.
I have an SQL query,which is working fine in SQL developer and giving me output.but the same query is not inserting any records to target sql server in procedure.
Below is for your reference
Target:
INSERT INTO xx.xxdbo.xxx_sync_json([json],[odi_sess_no])values('#JSON',<%=odiRef.getSession("SESS_NO")%>)
Source
select '{"Entity":"'||'contact'||'",'||'"FilterColumn":"new_xx_id",'||'"FilterValue":'||decode(trim(J$xxNT.xxnt_ID),'','null','"'||trim(J$xxNT.xx_ID)||'",')||'"ChangedValues":{'||'}}' AS JSON from xxxDBA.J$xxNT J$xxNT
Note: xxxDBA.J$xxNT is a table
Also i have noticed ,sometimes the procedure is running and pushing records to target server,but when i run the same procedure inside odi package.it is completing without any errors but not inserting any records(i'm using procedures,not scenarios).
Kindly clear my doubts.
Thanks in advance
Keerthi