Mongo API Fails With ORA-40944: Cannot insert into JSON Relational Duality View
(Doc ID 3044313.1)
Last updated on AUGUST 28, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
A table is defined with a PK column INTEGER GENERATED BY DEFAULT ON NULL AS IDENTITY.
Via SQL, a row can be inserted without specifying the PK column when populating the columns or the duality view.
However, the MongoAPI will not allow a row to be inserted without an _id column, and fails with the error below:
MongoServerError: ORA-40944: Cannot insert into JSON Relational Duality View 'CU1': The input JSON document is invalid.
JZN-00655: Message 655 not found; No message file for product=XDK, facility=JZN
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |