# Unable to use oracledb node

**URL:** <https://discourse.nodered.org/t/unable-to-use-oracledb-node/6886>\
**Category:** General\
**Created:** [16 January 2019 13:38 UTC](https://discourse.nodered.org/t/unable-to-use-oracledb-node/6886 "2019-01-16T13:38:38Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![tomasjuarez](https://avatars.discourse-cdn.com/v4/letter/t/e19adc/32.png) [@tomasjuarez](https://discourse.nodered.org/u/tomasjuarez)\
**Post date:** [16 January 2019 13:38 UTC](https://discourse.nodered.org/t/unable-to-use-oracledb-node/6886/1 "2019-01-16T13:38:38Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [16 January 2019 14:08 UTC](https://discourse.nodered.org/t/unable-to-use-oracledb-node/6886/2 "2019-01-16T14:08:30Z")

</div>

welcome to Node-RED 🙂  
If you’d ay you are using a node it’s best if you. an give us the full name.

eg node-red-node-twitter or node-red-contrib-something

as there are often more than one node to do a task and how you configure them may be different

---

<div class="post-metadata">

**Author:** ![tomasjuarez](https://avatars.discourse-cdn.com/v4/letter/t/e19adc/32.png) [@tomasjuarez](https://discourse.nodered.org/u/tomasjuarez)\
**Post date:** [16 January 2019 18:05 UTC](https://discourse.nodered.org/t/unable-to-use-oracledb-node/6886/3 "2019-01-16T18:05:35Z")

</div>

The full name is node-red-contrib-oracledb.  
Let me put some screenshots to clarify the situation.

![Screenshot](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/1/111652a2a5181c3e491672160b5c3f424c12fd08.jpeg)

Is there something wrong?