TO give the dbms_lock privileges:

TO give the dbms_lock privileges:


GRANT execute ON dbms_lock TO <schema_name>;

GRANT execute ON dbms_lock TO schema_name;