APEX 21.2.6
Database version 19c
I tried using PLSQL and got the following error message. Is there another way to get the preauthentication? I got Rest Data Sources to work with object storage so I can use that to get preathentication?
When I verify the PLSQL in APEX I get the following error.
ORA-06550: line 2, column 8:
PLS-00201: identifier 'DBMS_CLOUD_OCI_OBS_OBJECT_STORAGE_CREATE_PREAUTHENTICATED_REQUEST_RESPONSE_T' must be declared
declare
result dbms_cloud_oci_obs_object_storage_create_preauthenticated_request_response_t;
begin
result := create_preauthenticated_request('testspacenamej', 'TEST_Bucket',('this_is_test','ObjectRead','2022-10-12T07:20:50.52Z'),'test_request','us-phoenix-1','objectstorage.us-phoenix-1.oraclecloud.com','OCI_API_access');
dbms_output.put_line(result);
end;
I am using the function as shown at: https://docs.oracle.com/en-us/iaas/pl-sql-sdk/doc/dbms_cloud_oci_obs_object_storage.html
CREATE_PREAUTHENTICATED_REQUEST Function
Creates a pre-authenticated request specific to the bucket.
Syntax
FUNCTION create_preauthenticated_request (
namespace_name varchar2,
bucket_name varchar2,
create_preauthenticated_request_details dbms_cloud_oci_object_storage_create_preauthenticated_request_details_t,
opc_client_request_id varchar2 DEFAULT NULL,
region varchar2 DEFAULT NULL,
endpoint varchar2 DEFAULT NULL,
credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_obs_object_storage_create_preauthenticated_request_response_t;
Not sure what I am doing wrong. Any help is appreciated. I am able to put and list objects in the bucket from APEX, so APEX and OCI Object Storage are talking.
Thanks