Hi all,
I have some plsql-code where I upload/download files from my storage bucket. It was working some days ago.
Now it's partially working:
- LIST : select * from dbms_cloud.list_objects (... ); is working
- WRITE : response := dbms_cloud_oci_obs_object_storage.put_object() ... is working
- READ/download does not work anymore
l_response := apex_web_service.make_rest_request_b
( p_url => l_request_url
,p_http_method => 'GET'
,p_credential_static_id => G_TENANT_CREDENTIAL);
I probably have deleted some policy (cleaned up yesterday), but cannot figure out which one ?
Tried to re-create them, no success.
My user, used to create the credential, is administrator and there is a policy for admins to manage buckets and objects.
I also added: Allow group 'Default'/'All Domain Users' to manage objects in tenancy
The error message:
-------------------
DECLARE
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "APEX_240100.WWV_FLOW_CREDENTIAL", line 240
ORA-06512: at "APEX_240100.WWV_FLOW_CREDENTIAL", line 231
ORA-06512: at "APEX_240100.WWV_FLOW_WEBSERVICES_API", line 622
ORA-06512: at "APEX_240100.WWV_FLOW_WEBSERVICES_API", line 705
ORA-06512: at line 30
I've setted up a new credential for another user, the same error.
I tries to do the same download from oci client on linux, this is working.
The DB is an always free autonomous ATP.
Any hint is apreciated.
Thank you
Helmut