We're having an issue connecting to an Oracle database via data store. Our

We're having an issue connecting to an Oracle database via data store. Our CDT is created, data store DOES map successfully, but when we run a query rule (or queryEntity) against the DS, we receive the error "ORA-00942: table or view does not exist". The CDT fields utilize annotations to remove underscores, but not sure what else could be the issue here. We have also tried connecting with and without schema "schema.table", but the DS only recognizes the table when schema is not included - however we cannot read data. Our DB account has correct permissions, this connection has been in production for years now - no changes there.

Has anyone else had this problem with Oracle, where the data store maps successfully but you cannot query data?

OriginalPostID-197978

OriginalPostID-197978

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data