This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a fairly extensive workflow with two layers of batch macros that make use of In-DB nodes in order to dynamically adjust my database connection strings based on the DB (Dev / Test / Prod) that I need to use. Previously I had used batch macros with standard Input and Output connections, which worked fine on my local machine but errored out on Server.
So I re-did the whole thing (7 DB connections) using the In-DB nodes. However, I just noted that the "Update Rows" option in the Write Data In-DB node does not appear to be supported with (.oci) connections to Oracle Databases. Please let me know if am mistaken here, but if I'm correct this appears to be a key functional deficiency.
This is a big deal for me as I have 25 workflows that together have nearly 100 unique DB connections that all need to be manually adjusted when moving between environments. I had hoped the Control Param / Action Node / In-DB connection using (.indbc) files was the solution, but the gap I've noted above just put the kybosh on the whole thing.
Please confirm this limitation in the Write Data In-DB and if so, advise when this feature can be added.