Node-oracledb: This isn't Issue... just Question

[newsam202]

hello.

i using node-red

i cann't found any document about oracledb node attribute.

What's different between
(1) send single query result message
(2) send multiple query result messages

I really want to know that

[dmcghan]

@newsam202 I'm not sure I understand your question. Could you please clarify what you want to know?

[newsam202]

@dmcghan

I want to know the difference between the two options in node-red.

(node-red => Edit oracledb Node => Query results => Action (list)

• Action list
  ignore query result
  send single query result message

send multiple query result messages

Both return results, but I wonder what the difference is in using them.

[dmcghan]

@newsam202 A link to the content you're displaying would be helpful.

[newsam202]

@dmcghan i'm attach action list capture image

https://t1.daumcdn.net/cfile/tistory/99DBC5435B3032542D

[danilohgds]

Hi Sam, allow me to jump in the conversation @dmcghan

Node-red is a library for IoT development, originally developed by IBM. @newsam202 I believe you would probably get a better understanding from folks from node-red as their development is unrelated to the node-oracledb development.

github: https://github.com/abreits/node-red-contrib-oracledb
flow documentation: https://flows.nodered.org/node/node-red-contrib-oracledb

I've used node-red so the differences are as follows:

ignore query result

• This does not send payload responses over to listening clients.
  send single query result message
• Send the query result as a single payload for your clients
  send multiple query result messages
• Sends the query over in multiple messages, usually through splitting or index-based of the array.

var msg1 = { payload:"first query line" };
var msg2 = { payload:"second line" };
var msg3 = { payload:"third line" };
return [  msg1, msg2, msg3 ];

Hope this helps you out.