Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Compilation error using PL/SQL Object Storage API in a program unit

in Autonomous Database 2 comments

Summary:

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.

Content (required):

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!