Stack Overflow
Stack Overflow

Questions tagged [utl-http]

19 questions
2
votes
0 answers

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 peculiar issue. Here is the function I'm…
Eltac Shixseyidov
  • 29
  • 4
2
votes
2 answers

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: "The authorization grant type is not supported by the…
feddoh
  • 31
  • 7
1
vote
1 answer

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: mkdir /oracle/admin/mydb/my_wallet orapki wallet…
bluefox
  • 175
  • 3
  • 16
1
vote
2 answers

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 EE (release 19.3) installed on Windows 10 Pro…
Dee
  • 69
  • 1
  • 10
1
vote
0 answers

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 …
Bala venni
  • 23
  • 4
1
vote
1 answer

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 itself, so it should be similar in usage) What I…
Kabulan0lak
  • 2,116
  • 1
  • 19
  • 34
1
vote
1 answer

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: at "SYS.UTL_HTTP", line 1258 ORA-06512: at…
daimne
  • 47
  • 1
  • 6
0
votes
0 answers

ORA-29259 after trying with UTL_HTTP and APEX_WEB_SERVICE packages

I am using an Oracle database, version 12.2.0.1.0, apex version 22.1.0 . Error ORA-29259 end-of-input reached is constantly displayed after trying to make a https POST request to a specific API endpoint. File is stored server-side, around 5MB in…
Dino
  • 3
  • 5
0
votes
0 answers

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¿+¿\q2'3¿¿¿y¿S6¿¿¿uz, Co¿¿¿¿&+N.…
Justin
  • 5
  • 2
0
votes
0 answers

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 get_text or get_raw on the response when the…
Greg Reynolds
  • 9,736
  • 13
  • 49
  • 60
0
votes
1 answer

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 Wallets" article which describes, in part, how to add site…
Jeromy French
  • 11,812
  • 19
  • 76
  • 129
0
votes
1 answer

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.. so no problem in the service, something with…
Faheem Ahmed Shaik
  • 1
0
votes
1 answer

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 "somewhere" in ORDS or Database directory so I…
Adnan
  • 5
  • 1
  • 4
0
votes
1 answer

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 the token back. The second Request throws the…
Lukas Knirschnig
  • 9
  • 4
0
votes
1 answer

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 :=…
kikicoder
  • 383
  • 3
  • 16
1
2