0

ERROR

I am using REST DATA SOURCE in apex low code. When I call an API. I am getting this error:

"An error occurred during URL invocation.

ORA-29024: Certificate validation failure".

This API is working in Postman.

Why has this error occurred? How to rectify this?

Improve this question

1 Answer 1

Reset to default
0

"It works in Postman" is comparing apples to pears in a way. Postman connects your client to the API endpoint. In oracle APEX the connection is initiated from within the database. There are 2 things that needs to be setup for this. First, an ACL is needed. This will allow any processes in the database to connect to the remote host. This looks fine in your setup since you get an error that indicates you already reached the host. Second, the SSL certificate needs to be added to the Oracle wallet. There are many blogs on how to do this, here is one example

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

it is likely that Oracle APEX REST Data Source API requires an SSL certificate to establish a secure connection to the remote host .Am I correct?
It's not "likely", it is "certain". ORDS uses the wallet configuration in the underlying database.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.