I have following code but it just doesn't seem to work. I don't understand what's wrong.
await connection.execute(
`UPDATE mytable SET WEIGHT = :WEIGHT
WHERE ITEM_ID = :ITEM_ID AND NAME = :NAME`
), Bindings[0],{autoCommit: true, outFormat : oracledb.OBJECT};
Where Bindings[0] is:
{
ITEM_ID: 'dfghjkl',
WEIGHT: '10',
NAME: 'test'
}
This yields the following error: Error: ORA-01008: not all variables bound
Please help
mytable. I tried to guess what you did and my script ran fine.