24 questions
0
votes
0
answers
86
views
Get the full request header from UTL_HTTP
I am setting up a HTTP request with header information using Oracles UTL_HTTP package and UTL_HTTP.SET_HEADER(...). After setting a "Host" header I got the error
Your request contains ...
- 105
0
votes
1
answer
61
views
Send message to ActiveMQ Classic via Rest API with properties from Oracle
I can send a message from Oracle UTL_HTTP to ActiveMQ Classic using Rest API, but how can I add some properties to my message ?
myMessage := 'some text ....';
req := UTL_HTTP.BEGIN_REQUEST(lc_baseurl, ...
- 125
1
vote
1
answer
446
views
JSON_EQUAL in PL/SQL
How can I compare two JSON_OBJECT_T?
I have a PL/SQL procedure. I am getting a return of an array of JSON OBJECT from the GET request from HTTP API endpoint. I have prepared a JSON_OBJECT_T record ...
- 11
0
votes
0
answers
270
views
In oracle, ORA-29273: HTTP request failed ORA-29024: Certificate validation failure
My plsql for accessing intranet site
DECLARE
l_url VARCHAR2(50) := 'https://www.domainname.net';
l_http_request UTL_HTTP.req;
l_http_response UTL_HTTP.resp;
BEGIN
-- Make a HTTP ...
1
vote
0
answers
89
views
how connecting to web by utl_http in oracle10gr2?
I am using Oracle 10g R2
and facing the problem connecting to web.
SQL> select UTL_HTTP.REQUEST('https://backend.jofotara.gov.jo/core/invoices/',null,'file:E:\ho','Mmarwan2000@') Output from dual;
...
0
votes
1
answer
1k
views
UTL_HTTP making API call to fetch token , bad request
I am using utl_http for the first time, using documentation and online resources to build my code.
I am trying to call an API that is returning a token.
I have the API calls working using POSTMAN,
but ...
2
votes
1
answer
2k
views
ORA-29273: HTTP request failed / ORA-29259: end-of-input reached exception on the first call but not on subsequent ones in Oracle PL/SQL
I am facing an issue with a PL/SQL function that makes HTTP(S) requests using UTL_HTTP. The function is supposed to send a POST request to a specific URL. It's working almost as expected, but with a ...
0
votes
0
answers
191
views
Oracle PL/SQL HTTP request response strange characters
I am using the Fedex API for rating and when I try to get the response of the json I get very strange characters in the response for exmaple.
¿ m¿QO¿0¿¿> :¿ ¿¿¿¿P¿@¿¿E]¿}w¿¿o¿¿¿~w¿¿¿I¿+¿...
- 5
0
votes
0
answers
197
views
Oracle UTL_HTTP gzip response with non-200 status
I have a very strange problem with UTL_HTTP. I'm calling an API that can return a gzip encoded response. This is handled correctly when the service returns a 200 status code. However, when I try using ...
- 10.5k
0
votes
1
answer
5k
views
How can I see what certificates are associated with an oracle wallet?
While troubleshooting an ORA-24263 error ("ORA-24263: Certificate of the remote server does not match the target address"), I came across this "UTL_HTTP and SSL (HTTPS) using Oracle ...
- 12.1k
0
votes
1
answer
1k
views
Consuming rest API using PL/SQL - Body not recognized
I am new to this forum and consuming Rest API's using PL/SQL. I am trying to consume a rest service from pl/sql, but the server is not able to identify the request. The same request works from postman....
0
votes
1
answer
863
views
What is the server path for standalone ORDS running Oracle APEX?
I am trying to put a php file on a folder and call it using UTL_HTTP.REQUEST from SQL and in APEX. I used xampp software to host it and it works. So I was wondering if there is a way to put in a file &...
- 27
1
vote
1
answer
30k
views
Oracle 19c - ORA-29024 (Certificate validation failure)
I am trying to use UTL_HTTP package to send requests to a remote web server.
It works well using normal HTTP but when I try to use HTTPS, I always get ORA-29024.
What I did so far:
Create a wallet: ...
- 185
1
vote
2
answers
10k
views
Oracle 19: Failing to connect to host using PL/SQL via ACL
I'm trying to get a simple proof of concept working to use PL/SQL to consume an API.
I'm using the articles on oracle-base.com to guide me here, but I'm hitting a wall.
Technical Details:
Oracle 19c ...
- 91
3
votes
1
answer
5k
views
ora-29259 end-of-input reached using UTL_HTTP.BEGIN_REQUEST
I am making a stored procedure with 2 seperate HTTP Requests.
The first one to get an Atuthentication Token and the second one that uses the token.
The first Request works without a problem and I get ...
0
votes
1
answer
1k
views
why HTTP request failed repeatedly on UTL_hhtp oracle package?
Dears, I have a oracle package where I request some http request from a tomcat server , I am using UTL_HTTP package to do so,
now the request is working successfully
the code to request is:
REQ := ...
- 417
0
votes
1
answer
2k
views
Send huge data through post request from oracle database
I am trying to send data via an HTTP post request from Oracle using UTL_HTTP.
The code is like this:
REQ := UTL_HTTP.BEGIN_REQUEST(URL,'POST','HTTP/1.1')
UTL_HTTP.SET_HEADER(REQ,'USER-AGENT','MOZILLA/...
- 417
0
votes
1
answer
356
views
Oracle UTL_HTTP bad request with ngixx
I've a ngnix as a reverse proxy with the next entry:
location /jrri/ {
proxy_pass http://xxx.xxx.xxx.xxx:8080/;
proxy_set_header X-Forwarded-Host $host;
proxy_set_header X-Real-IP $...
- 186
0
votes
1
answer
1k
views
utl_http.HTTP_CONTINUE example
I would like to use "utl_http.HTTP_CONTINUE" on my pl sql code. But I could not find any example how to use this. Can anyone help me about how to use "utl_http.HTTP_CONTINUE" ...
- 53
1
vote
0
answers
545
views
ORA-29273: HTTP request failed ORA-29259: end-of-input reached ORA-06512: at "SYS.UTL_HTTP", line 1491
i am getting the following error ORA-29273: HTTP request failed ORA-29259: end-of-input reached ORA-06512: at "SYS.UTL_HTTP", line 1491 when running this query
SELECT utl_http.request('http:...
- 23
1
vote
1
answer
2k
views
Oracle PL/SQL HTTP request response encoding issue
Following my previous question, I don't seem to be able to convert a HTTP response from ISO-8859-1 to UTF-8.
I am using APEX_WEB_SERVICE package to to my requests. (I know this package uses UTL_HTTP ...
- 2,136
2
votes
2
answers
1k
views
oracle utl_http rest call on shopware 6 admin-api?
I am confused about utl_http and oauth authentication with shopware 6. I undestand I have to obtain a token, which has to be used in futher requests.
With all efforts I am getting the answer: "...
- 31
2
votes
1
answer
11k
views
ORA-29273: HTTP request failed ORA-29276: transfer timeout
We are running 12.1.0.2 OEE
We are Getting intermittent Ora error while executing a rest call from SP
[Error] Execution (124: 1): ORA-29273: HTTP request failed
ORA-29276: transfer timeout
ORA-06512: ...
- 67
1
vote
1
answer
2k
views
Oracle UTL_HTTP request returns a shorter response than when the same request is done in Python or curl
I'm accessing a REST service for data query and download. This is the very first call that performs the authentication. The response is a json structure that contains an authentication token.
When I ...
- 2,078