sharepointplsqloracle-apexapexoracle-wallet

ORA-28759: failure to open file with apex_web_service.make_rest_request

I have a successful POST request with Postman to upload a file calling this url :

https://test.sharepoint.com/sites/BM/_api/web/GetFolderByServerRelativeurl('/sites/BM/BM_UPLOADS/')/Files/add(url='test_file.pdf',overwrite=true)

when I tried to apply that in Oracle APEX procedure :

l_resp := apex_web_service.make_rest_request(p_url         => 'https://test.sharepoint.com/sites/BM/_api/web/GetFolderByServerRelativeurl("/sites/BM/BM_UPLOADS/")/Files/add(url="test_file.pdf",overwrite=true)';
                                               p_file blob;',  `
                                               p_http_method => 'POST',
                                               p_body_blob   => p_file,
                                               p_wallet_path => 
                                                 'file:/home/r_erp/wallet',
                                               p_wallet_pwd  => 'test@2022'
                                               );

when run the procedure I have the error : ORA-28759: failure to open file

I relaized that I do HTTPS request which require creating an oracle wallet and add the required certificate inside it. so I followed the instructions here

but with no luck same error : ORA-28759: failure to open file

I'm not sure if I added the correct certificate for SharePoint to Oracle wallet! When I accessed my SharePoint site , I had those 3 certificates : enter image description here

I downloaded the leaf one : *.sharepoint.com and added it to the wallet by orapki utility this one added successfully .

I downloaded the second one : DigiCert Cloud Services CA-1 but when I tried to add this one I had the error : Unable to read certificate .

I do also run this procedure ACL grant :

begin


dbms_network_acl_admin.create_acl (
acl         => 'utl_https.xml',
description => 'HTTP Access',
principal   => 'BM',
is_grant    => TRUE,
privilege   => 'connect',
start_date  => null,
end_date    => null );


dbms_network_acl_admin.add_privilege (
acl        => 'utl_https.xml',
principal  => 'BD',
is_grant   => TRUE,
privilege  => 'resolve',
start_date => null,
end_date   => null
 );

  dbms_network_acl_admin.assign_acl (
acl        => 'utl_https.xml',
host       => '*.sharepoint.com',
lower_port => 443,
upper_port => 443 ); commit; end;

I'm using oracle APEX on a hosting cloud service with Apache web application on Linux OS. I do also give 777 permissions to the oracle wallet path and all files inside it. Same error : ORA-29273: HTTP request failed ORA-28759: failure to open file

My question : is there anything missing I should do ? How to download the correct certificate for https requests to a platform like SharePoint ?

Solution

  • The ORA-28759: failure to open file message indicates that the database was not able to open the wallet file, at the location you specified in the p_wallet_path parameter.