Node-oracledb: how can i handle DML returning value with INSERT ALL?

Created on 21 Dec 2018  路  2Comments  路  Source: oracle/node-oracledb

for a single insert we have

INSERT
INTO table_name (pk, column1) VALUES (1, 'string')
RETURNING pk INTO :ids

how can i handle DML returning inserted ids value with INSERT ALL statement?

question

All 2 comments

You wouldn't use INSERT ALL, you would use connection.executeMany. See Batch Statement Execution.

thanks,

I did it with the executemany

Was this page helpful?
0 / 5 - 0 ratings

Related issues

PaulBrookes picture PaulBrookes  路  4Comments

sanfords picture sanfords  路  3Comments

ChrisHAdams picture ChrisHAdams  路  3Comments

rheinripper picture rheinripper  路  4Comments

nicholas-ochoa picture nicholas-ochoa  路  3Comments