Node-oracledb: CANNOT GET DATA AFTER INSER/UPDATE

Created on 14 Aug 2018  路  2Comments  路  Source: oracle/node-oracledb

Hey there im trying to get the updated/inserted data after UPDATE query, because i have to do another query with this response data, but im actually getting:

{ outBinds: undefined,
  rowsAffected: 1,
  rows: undefined,
  metaData: undefined }

Im using 2.3.0 node-oracledb version with v10.8.0 NODE version and my code is :

QUERY :
INSERT INTO gio.projects (code, direccion, idStatus, nombre, rules, latitude, longitude, description) VALUES (123123, null, 1, 'TEST',1, null, null, null)

EXECUTE QUERY:

connection.execute(
                            queryb, [],
                            {
                                maxRows: 1000
                                , outFormat: oracledb.OBJECT
                            },
                            function (err, result) {
                            console.log("RESULT", result)
                                if (err) {
                                    doRelease(connection);
                                    return;
                                }
                            });
question

Most helpful comment

Take a look at section "14.3 DML RETURNING Bind Parameters".
That should do what u want

All 2 comments

Take a look at section "14.3 DML RETURNING Bind Parameters".
That should do what u want

Solved, ill close! thx

Was this page helpful?
0 / 5 - 0 ratings