Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Call API from PL/SQL Using UTL_HTTP raise error ORA-29024

Alexis BJan 28 2025

Hi Everyone,

We have a DB 12cR1

ACLs are granted :

But we are unable to call an API with PL/SQL using UTL_HTTP

declare
req UTL_HTTP.REQ;
resp UTL_HTTP.RESP;
val VARCHAR2(2000);
str varchar2(1000);
begin
req := UTL_HTTP.BEGIN_REQUEST('https://ion.tdsynnex.com/api/v1/invoices/myinvoices');
resp := UTL_HTTP.GET_RESPONSE(req);

LOOP
UTL_HTTP.READ_LINE(resp, val, TRUE);
DBMS_OUTPUT.PUT_LINE(val);
END LOOP;

UTL_HTTP.END_RESPONSE(resp);

EXCEPTION
WHEN UTL_HTTP.END_OF_BODY THEN
UTL_HTTP.END_RESPONSE(resp);
END;
/

And we always got following error :

Rapport d'erreur -
ORA-29273: échec de demande HTTP
ORA-29024: Echec de validation de certificat
ORA-06512: à "SYS.UTL_HTTP", ligne 368
ORA-06512: à "SYS.UTL_HTTP", ligne 1118

I tried to follow this doc https://oracle-base.com/articles/misc/utl_http-and-ssl to create a wallet

and added utl_http.set_wallet('file:D:\Wallet\wallet\', null);

before to call req := UTL_HTTP.BEGIN_REQUEST('https://ion.tdsynnex.com/api/v1/invoices/myinvoices');

But we still got same issue

We read about My Oracle Support Doc ID 756978.1 that we should use a PROXY

But we didn't have any proxy AND this Doc ID is related to DB 19c and we are in an older version so I guess it should not apply?

Thanks

Best regards,

Comments

chonewell Nov 12 2024

My Oracle Cloud tenant, cloud account, and secure email have no issues. Why haven't I received my password reset email for Oracle Cloud? This is very strange, and our attempts have not been able to solve the problem. May I ask who I should turn to for help?

L. Fernigrini Nov 12 2024

If your account is a paid one, open a Support ticket.

If it is a Free Tier then you will have to rely on help from the community. Most probable cause that you did not receive the password reset email is that your account has been stolen and the email has been changed.

chonewell Nov 13 2024

Thank you for your reply!
But when I chatted with the online customer service, they told me that my Oracle Cloud tenant, account, and email were all fine. So, there shouldn't be a problem of theft.
I have a free account, but who can I contact on the forum? I can only post, but no one on the forum can view my account permissions, right. I am currently trying to reset MFA, I don't know if it works.
It's quite ridiculous that I have a free account and can't enjoy any services, but how can I become a paid user if I can't log in to my account.

1 - 3

Post Details

Added on Jan 28 2025
3 comments
107 views