DBMS_CLOUD Synonym No Longer Valid Autonomous Database 23AI

Summary:

Attempting to execute a subprogram from DBMS_CLOUD and getting error that the synonym is no longer valid.

Content (please ensure you mask any confidential information):

Attempted to execute the 'delete_file' subprogram in the DBMS_CLOUD package in a PL/SQL module I wrote. When I compile the module, I get an error:

• Error(44,7): PLS-00201: identifier 'DBMS_CLOUD.DELETE_FILE' must be declared

So I logged into the admin account and attempted to grant execute on DBMS_CLOUD to the schema owning the PL/SQL module. The grant failed with error:

grant execute on dbms_cloud to <schema_name>;