Hi! This is my first day using node-RED, so I'm really new.
I'm trying to use the oracledb node to perform some inserts into a table. Just a very simple try.
The insert is working, but the problem is that bind variables are allways empty.
I tried with: "insert into mytable(col1) values(:value1)", and in the "Field Mapping" tab I have this: "msg.payload.Value".
I also tried with some string as "myvalue", but nothing worked.
Could anybody help me to understand how it works?