24-02-20 11:48 PM
Hello,
I am running into an issue I haven't experienced before. I have an OLEDB connection where I am running three different sql statements through getting collections. One of these is not pulling any data. If I copy the statement over to my sql developer and run it, it pulls data. It isn't causing any errors or bombing out, just not pulling any data.
Does anyone have any ideas regarding what may be the cause or has anyone ran into this issue before?
Thanks,
Jon
12-03-20 04:43 PM
12-03-20 04:52 PM
31-03-20 03:37 PM
01-04-20 05:40 AM
19-10-20 12:15 PM
Hi Jonathan,
Have you got this resolved?
If not try updating the SQL to derive the date from SYSDATE.
Alternatively we use a calculation to replace date parameters in the SQL and format the date to this format 'yyyy-MM-dd HH24:MI:SS'
22-10-20 03:04 PM