Database Error Messages

OCI-40592

name conflicts were found during execution of DBMS_JSON.ADD_VIRTUAL_COLUMNS: string

Cause

An attempt was made to create virtual columns using an annotated Javascript Object Notation (JSON) data guide with the name of a column that already exists.


Action

Change the preferred name of the virtual column in the annotated Javascript Object Notation (JSON) data guide. An alternative is to set parameter resovleNameConflicts in procedure DBMS_JSON.ADD_VIRTUAL_COLUMNS to TRUE and the procedure will automatically resolve the virtual column name conflicts by appending a sequence number.