Category: atp

Resolving ORA-01031: Insufficient Privileges When Using UTL_HTTP

If you’re using an Autonomous Database Serverless (ADB-S) and attempting to call HTTP (not HTTPS) endpoints, encountering the ORA-01031 error is common. While your first step might be to check the Access Control List (ACL) or grant permissions to the user calling the package, this alone won’t resolve the issue. Here’s how to fix it: […]
Adriano Tanaka

ORA-40842 unsupported value EMBEDDED_OID in the metadata

I was assisting a customer with an issue related to the SODA/MongoDB API. They were encountering the ORA-40842 error in Autonomous Database – Shared (19c). After several troubleshooting sessions, we determined that updating the application driver to the latest version resolves the problem. For Java, specifically, you need orajsoda-1.1.27(or newer) to accommodate some internal changes […]
Adriano Tanaka