search

oracle / adb-free

Universal Permissive License v1.0
36 stars 3 forks source link

ORA-20987: APEX - The DBMS_CLOUD package is not available on this system. - Contact your application administrator. #32

Open alexesca opened 1 day ago

alexesca commented 1 day ago

I am trying to follow this article, Seamless PDF Generation with Oracle APEX and OCI Document Generator, and it asks me to create a credential in my database.

When I run a similar code to the following, I get this error:

BEGIN
    APEX_INSTANCE_ADMIN.CREATE_CLOUD_CREDENTIAL (
    p_credential_name       => 'MY_CREDENTIAL',
    p_user_ocid             => 'ocid1.user.oc1...',
    p_tenancy_ocid          => 'ocid1.tenancy.oc1..',
    p_private_key           => 'ABCDEFGHIJKLMNOPQRSTUVWXYZ',
    p_fingerprint           => '12:34:56:78:90:ab:cd:ef:12:34:56:78:90:ab:cd:ef' );
END;

ORA-20987: APEX - The DBMS_CLOUD package is not available on this system. - Contact your application administrator.

I found this comment in this forum. It says that the issue was fixed in the APEX 24.1.2 patch. The adb-free:24.9.3.2 has APEX 24.1.1

https://forums.oracle.com/ords/apexds/post/apex-instance-admin-create-cloud-credential-2174

image

I am using the following autonomous database version that has APEX 24.1.1. It is now impossible for me to continue developing the feature I need because I cannot upgrade the version of apex myself. This is why we need this database image to be updated more often

docker pull ghcr.io/oracle/adb-free:24.9.3.2