CODEWITHSUNDEEP
oracle-databaseoracle19c
user3429660
user3429660

Reputation: 2722

JSON integrity check triggers "table or view does not exist"

When running run the following SQL in Oracle 19, it works well:

alter table X add constraint C1 check ("XX" is not null)

But, if I run the SQL below:

alter table X add constraint C2 check ("XX" is json)

I get the following error, with no other info:

ORA-00604: error occurred at recursive SQL level 1

ORA-00942: table or view does not exist

The column type is CLOB , the table is empty, and it only has two columns: ID and XX. I tried to change the column name but it did not help. There are other tables in the same schema with working JSON constrains, but I fail to spot any difference.

Has anyone run into a similar problem?

Upvotes: 1

Views: 739

Answers (1)

user3429660
user3429660

Reputation: 2722

It turns out it's a bug with Oracle 19 (Bug 30871716). It has been fixed in July 2020, in version 19.8.0.0.200714.

Upvotes: 1

Related Questions