Hello, I am trying to make use of node-red-contrib-oracledb-mod to connect to the Oracle db and access datas. I am able to connect it successfully and write select queries and getting the proper results. But, not able to write the insert queries by giving the values that I get from the payload. Plea…

Your payload should look something like: sql = "INSERT INTO Schema1.tableABC ( ... ) VALUES ('"+msg.payload.ContactInformation[0].Googleplus+"', '"+msg.payload.ContactInformation[0].MiddleName+"')" return {payload:sql} To make it readable for yourself, assign variables like: googleplus = msg.pay…

I will try this and get back. Thank you

Should I write this in the node-red-contrib-oracledb-mod or in a separate function node? I made changes in node-red-contrib-oracledb-mod node as follows. Still it is giving the same error as before. query = "INSERT INTO Schema1.tableABC (GOOGLEPLUS, MIDDLENAME, NOTES, DEPARTMENT, BIRTHDAY, PROFILEP…

Did you read the info panel of the node ? Oracle database storage node. Connects to a server and inserts rows into the database or retrieves rows from the database with a SQL query. Expects an object called msg containing msg.payload and optionally msg.query and msg.mappings. msg.payl…

Sorry, I didn't read it. I will work on this now. Thanks @bakman2

@Divya in your first post you asked if there was any documentation on how to use the node. Every single node provides help in the info sidebar. Some may provide more help than others, but that should always be the first place to look when you want to learn more about the node.

Yes @knolleary I agree. But, sometimes I may need more information and some examples than what is provided in the info tab. Just now I went through the info tab thats provided for this oracle node. Still I am finding difficulties in inserting the query. Badly in need of help. I am also trying in wha…

I tried in the following way. Still I am not able to solve this issue. if (msg.payload) { var values = `('` + msg.payload.ContactInformation[0].Googleplus + `','` + msg.payload.ContactInformation[0].MiddleName + `','` + msg.payload.ContactInformation[0].Notes + `','` + msg.payload.Contact…

What does a debug node return (complete msg object)

Are you sure the node takes the query as you are writing it In that Info panel you have now read… [image] bakman2: msg.payload : array containing the fields to be used inside the query, first element in the array corresponds with the first :fieldname parameter in the query etc.

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

General

zenofmud 3 November 2023 10:08 24

@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!

Topic		Replies	Views
Insert data to oracle database with oracledb-mod General	5	383	4 January 2024
Insert using node-red-contrib-oracledb-mod General	5	98	17 March 2025
Unable to use oracledb node General	2	565	16 January 2019
Oracle DB INSERT Not Working General	9	131	22 April 2025
Field mapping does not work as expected in node-red-contrib-oracledb-mod General database	1	256	6 April 2023

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

Related topics