Warnings in the log related to DBMS_LOCK (Oracle), but DBMS is deprecated
We are currently using version 220.127.116.11 and see some warnings in catalina.yyyy-mm-dd.log regarding DBMS_LOCK.
WARN [main] liquibase.lockservice.null Error during capability test for oracle session locking: java.sql.SQLSyntaxErrorException: ORA-00942: Tabelle oder View nicht vorhanden WARN [main] liquibase.lockservice.null Oracle user needs execute access on DBMS_LOCK, and select access on SYS.V_$LOCK and SYS.V_$SESSION to use session lockingSo it seems something is not working as it should. What is it exactly?
Our DBA do not want to assign this permission anymore, because DBMS_LOCK-SLEEP is deprecated. Oracle has replaced the function with DBMS_SESSION.SLEEP, which does not require separate permissions.
If "SLEEP" is the reason, please adjust your source code at least for Oracle DB version 18+.