Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Compilation error using PL/SQL Object Storage API in a program unit — Cloud Customer Connect
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

Accepted answer
12
Views
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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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