OCI-43410
The root table 'root_table_name' in the JSON-relational duality view 'view_name' cannot be accessed as a JSON array.
- root_table_name: Name of the root table.
- view_name: Name of the JSON-relational duality view.
Cause
The root table has been specified within the JSON_ARRAYAGG operator in SQL syntax for the JSON-relational duality view creation or the root table has @ARRAY directive in the GraphQL syntax for the JSON-relational duality view creation.
Action
In SQL syntax, replace the JSON_ARRAYAGG operator for the root table with the JSON_OBJECT operator, and in the GraphQL syntax either remove the @ARRAY directive for the root table or replace the @ARRAY directive with the @OBJECT directive.