Closed mrchess closed 8 years ago
Fwiw when I run the same SQL query in my SQLDeveloper console, it works.
Ugh. Of course. The issue was i am passing null
instead of an empty object {}
.
I originally thought the Error
was referencing an error in the SQL statement.
Correct code:
oracle.connection.execute(sql, {},...) // <- supposed to be {}
I'm trying a very simple scenario of running this:
But I keep getting
[Error: NJS-006: invalid type for parameter 1]
.Is there a different way to utilize
nextval
? Basically I can't create a trigger on my sequence due to our local conventions, so I have to manually usenextval
.