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

Encountering an error of insufficient privileges when attempting to execute DBMS_CLOUD.COPY_DATA

Accepted answer
159
Views
1
Comments
edited Jul 19, 2023 8:13PM in Autonomous Database 1 comment

Summary:

I am encountering an error of insufficient privileges when attempting to execute DBMS_CLOUD.COPY_DATA in a PROCEDURE.

Content (required):

I'm working on creating a procedure that will use DBMS_CLOUD.COPY_DATA to transfer data from object storage into a table. However, I'm encountering an issue where I'm unable to execute the COPY_DATA function within the procedure, although it works fine in an anonymous block. I'm receiving an ORA-01031 error message indicating that I don't have sufficient privileges.


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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