# Writing Insert query inside node-red-contrib-oracledb-mod
**URL:** https://discourse.nodered.org/t/writing-insert-query-inside-node-red-contrib-oracledb-mod/13390
**Category:** General
**Created:** [17 July 2019 11:18 UTC](https://discourse.nodered.org/t/writing-insert-query-inside-node-red-contrib-oracledb-mod/13390 "2019-07-17T11:18:51Z")
**Posts on this page:** 5
**Page:** 2
### Author:  [@Divya](https://discourse.nodered.org/u/Divya)
#### Post date: [10 March 2020 11:48 UTC](https://discourse.nodered.org/t/writing-insert-query-inside-node-red-contrib-oracledb-mod/13390/21 "2020-03-10T11:48:37Z")
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.
---
### Author:  [@shekhar](https://discourse.nodered.org/u/shekhar)
#### Post date: [10 March 2020 14:07 UTC](https://discourse.nodered.org/t/writing-insert-query-inside-node-red-contrib-oracledb-mod/13390/22 "2020-03-10T14:07:14Z")
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
---
### Author:  [@robsonsilva](https://discourse.nodered.org/u/robsonsilva)
#### Post date: [3 November 2023 00:05 UTC](https://discourse.nodered.org/t/writing-insert-query-inside-node-red-contrib-oracledb-mod/13390/23 "2023-11-03T00:05:24Z")
Hello @Divya
Have you got a success to insert data on oracledb?
Coud you share the solution?
Thanks.
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [3 November 2023 10:08 UTC](https://discourse.nodered.org/t/writing-insert-query-inside-node-red-contrib-oracledb-mod/13390/24 "2023-11-03T10:08:57Z")
@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!
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [3 November 2023 10:09 UTC](https://discourse.nodered.org/t/writing-insert-query-inside-node-red-contrib-oracledb-mod/13390/25 "2023-11-03T10:09:02Z")
[Previous page](https://discourse.nodered.org/t/writing-insert-query-inside-node-red-contrib-oracledb-mod/13390.md?page=1)