Package DBMS_LOCK not included

[geirsagberg]

Hello! I am attempting to use https://github.com/blagerweij/liquibase-sessionlock to avoid hanging locks with Liquibase. This package depends on DBMS_LOCK being present, but it does not seem to be included:

SELECT *
FROM ALL_OBJECTS
WHERE OBJECT_TYPE = 'PACKAGE'
  AND OBJECT_NAME = 'DBMS_LOCK';

Returns 0 results. This is both in the full and regular image.

Would it be possible to include this package?

[loiclefevre]

Hi @geirsagberg, which image are you using? which account did you use to run that query?

[geirsagberg]

My bad, I forgot to set ALTER SESSION SET CONTAINER = FREEPDB1.