Database Administration (MOSC)

MOSC Banner

DBMS_CLOUD getting ORA-01031: insufficient privileges

edited Apr 4, 2025 8:31AM in Database Administration (MOSC) 12 commentsAnswered ✓

Environment OCI DB 23ai.

As admin user, when i use DBMS_CLOD in select statement no issues.

As admin user, when i use DBMS_CLOD in a block (begin-End) no issues

When i use DBMS_CLOD in store procedure when i compile i get Error: PL/SQL: ORA-01031: insufficient privileges

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center