We are currently using ORDS as a plsql gateway for an older application that does not require any of the other features provided by ORDS.
To keep it simple ORDS has not been installed in the database so that ORDS can be upgraded without the assistance of the DBA.
After upgrading ORDS to recent versions the DBA is seeing warnings relating to "too many parse errors" being recorded in the logs where it appears ORDS is trying to check the plsql gateway patching and version values.
2024-01-17T03:24:00.580228+00:00
WARNING: too many parse errors, count=100 SQL hash=0x1686a00d
PARSE ERROR: ospid=1109, error=942 for statement:
2024-01-17T03:24:00.580344+00:00
SELECT
(SELECT VALUE FROM ORDS_METADATA.USER_ORDS_PROPERTIES WHERE KEY = 'plsql.gateway.patching') as patchingValue,
(SELECT VALUE FROM ORDS_METADATA.USER_ORDS_PROPERTIES WHERE KEY = 'plsql.gateway.version') as versionValue
FROM dual
Additional information: hd=0x7a3b7308 phd=0x759766b8 flg=0x20 cisid=107 sid=107 ciuid=107 uid=107 sqlid=0h8nys8b8d80d
I believe it started in ORDS version 23.1 and is still happening in 23.4.
The easiest solution is to install ORDS in the database, however to keep ORDS upgrades simple for this database it would be preferable if we didn't have to.
The plsql.gateway.mode is set to direct in the ORDS configuration. Is there a configuration option to prevent ORDS checking the gateway version in the database.