Does anyone use Oracle with ACF and have had issue...
# cfml-generalm
mike42780
08/16/2022, 9:33 PMDoes anyone use Oracle with ACF and have had issues trying to run MERGE INTO queries in queryExecute/cfquery? I'm on ACF 2021 and Oracle 19C, but it's happened on previous releases as well. Something like this https://www.oracletutorial.com/oracle-basics/oracle-merge/ for the query. Either it works great and executes the query, or it just hangs forever and I can't find any error logs. The same query will run fine directly against the database.
mike42780
08/16/2022, 9:35 PMMerge into is nice sometimes because it runs so fast. Usually I eventually give up and have to loop through all the records in Coldfusion. But once in a while the merge into query actually works. I have one open right now that has run fine for at least a year. And the new one that's very similar that just hangs forever. Merge into always seems to be hit or miss and I can't figure out why.