Compilation error using PL/SQL Object Storage API in a program unit
Setup: We are using an OCI ATP database and running APEX 22.2.1. The database user that owns the application objects has been granted the DWROLE.
I can reference "dbms_cloud_oci_obs_object_storage_delete_object_response_t" in an anonymous block in APEX but get a PLS-00201 compilation error when I try to move that code to a package.
In the APEX application, the user uploads an image which is then placed in Object Storage using a call to dbms_cloud_oci_obs_object_storage.put_object. Works great when all of the code in is APEX.