I'm using the latest version of Oracle 23ai from here: https://hub.docker.com/layers/gvenzl/oracle-free/latest/images/sha256-f5f0455cebef4cd2c47a6eb828e1f320dfdbd5f1563db9dc29177fc6609238da?context=explore
Create this schema:
CREATE TABLE t (i int PRIMARY key);
INSERT INTO t VALUES (1);
CREATE JSON RELATIONAL DUALITY VIEW v AS
SELECT json { '_id': i } FROM t WITH INSERT UPDATE DELETE;
Then run this query, which uses full qualification of identifiers:
SELECT test.v.data FROM test.v;
This raises:
SQL Error [929] [42000]: ORA-00929: missing period
https://docs.oracle.com/error-help/db/ora-00929/
Seems to be some internal error leaking. The workaround is to not fully qualify the column reference:
SELECT v.data FROM test.v;