# Insert using node-red-contrib-oracledb-mod

**URL:** <https://discourse.nodered.org/t/insert-using-node-red-contrib-oracledb-mod/93925>\
**Category:** General\
**Created:** [16 December 2024 03:54 UTC](https://discourse.nodered.org/t/insert-using-node-red-contrib-oracledb-mod/93925 "2024-12-16T03:54:39Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![engjie0918](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/engjie0918/32/97223_2.png) [@engjie0918](https://discourse.nodered.org/u/engjie0918)\
**Post date:** [16 December 2024 03:54 UTC](https://discourse.nodered.org/t/insert-using-node-red-contrib-oracledb-mod/93925/1 "2024-12-16T03:54:39Z")

</div>

I'm working on a Node-RED flow to insert random data into an Oracle database table at regular intervals, but I'm facing an issue where all the inserted values end up being NULL. I need help identifying where I might be going wrong.

This is the flow:

 ![Screenshot 2024-12-16 at 11.43.36 AM](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/6/96b50915c9874c29a6ddcc91907deee84b2960a3.png)

In Function Node:

 ![Screenshot 2024-12-16 at 11.46.22 AM](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/6/96ef29e7ab0287d208ebced2f5726e8b6f698e08.png)

In SQL query of Oracle Node:

 ![Screenshot 2024-12-16 at 11.48.51 AM](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/4/945abbbdeb976b3bd9882771236579a3f667897b.png)

Lastly in Field Mapping of Oracle Node:

 ![Screenshot 2024-12-16 at 11.52.01 AM](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/3/a3bed86b8b8df89839710ea3d068e23729000785.png)

After injecting to run the insert query, the debug message:

 ![Screenshot 2024-12-16 at 11.53.51 AM](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/4/942c6ca46ff2ac63e86823d8a1453fa1faf4cb12.png)

---

<div class="post-metadata">

**Author:** ![omrid](https://avatars.discourse-cdn.com/v4/letter/o/77aa72/32.png) [@omrid](https://discourse.nodered.org/u/omrid)\
**Post date:** [16 December 2024 08:59 UTC](https://discourse.nodered.org/t/insert-using-node-red-contrib-oracledb-mod/93925/2 "2024-12-16T08:59:10Z")

</div>

I'm using this node, doing many inserts. I don't know how to solve your issue, but I just specify the whole SQL block in `msg.query`, and it works perfectly.

---

<div class="post-metadata">

**Author:** ![engjie0918](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/engjie0918/32/97223_2.png) [@engjie0918](https://discourse.nodered.org/u/engjie0918)\
**Post date:** [17 December 2024 00:21 UTC](https://discourse.nodered.org/t/insert-using-node-red-contrib-oracledb-mod/93925/3 "2024-12-17T00:21:57Z")

</div>

msg.query in Function node? did you write anything into Field Mappings?

---

<div class="post-metadata">

**Author:** ![gregorius](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/gregorius/32/73816_2.png) [@gregorius](https://discourse.nodered.org/u/gregorius)\
**Post date:** [17 December 2024 08:47 UTC](https://discourse.nodered.org/t/insert-using-node-red-contrib-oracledb-mod/93925/4 "2024-12-17T08:47:14Z")

</div>

At a random guess, should/could the payload be an array instead of hash? I've not worked with the Oracle node so I'm only guessing but since the field mappings screenshot states "always use field mappings (even if msg.payload is an array)" - so payload can also be an array.

Second question: is the syntax `:column1` (i.e. colon followed by column name) the correct syntax in the SQL query tab?

---

<div class="post-metadata">

**Author:** ![omrid](https://avatars.discourse-cdn.com/v4/letter/o/77aa72/32.png) [@omrid](https://discourse.nodered.org/u/omrid)\
**Post date:** [17 December 2024 09:13 UTC](https://discourse.nodered.org/t/insert-using-node-red-contrib-oracledb-mod/93925/5 "2024-12-17T09:13:14Z")

</div>

> [@engjie0918](#):
>
> msg.query in Function node? did you write anything into Field Mappings?

I leave it empty. You can use `msg.mapping`.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [17 March 2025 09:13 UTC](https://discourse.nodered.org/t/insert-using-node-red-contrib-oracledb-mod/93925/6 "2025-03-17T09:13:51Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.