Writing Insert query inside node-red-contrib-oracledb-mod

Hello @shekhar,
Step 1: add an inject node or http nodes to supply the input values
Step 2: add a function node and write your query there and store that in msg.query (Because, node-red-contrib-oracledb-mod accepts query that is saved in msg.query only).
Step 3: add node-red-contrib-oracledb-mod node and add all the connection configurations that is required. Leave the query tab empty as we are passing it through the function node.
Step 4: add a debug node to see the response.

Thanks for quick response
@Divya , we are not using field mappings here pr passing array in msg.payload ?
I did follow this method but with insert and delete queries i can not see any log in debug node

Hello @Divya

Have you got a success to insert data on oracledb?
Coud you share the solution?

Thanks.

@robsonsilva Welcome to the forum!

This thread is over 4 years old so itI will close it and ask you to open a new thread and explain your issue. Thanks!