Home » SQL & PL/SQL » SQL & PL/SQL » oracle10g and utl_http (oracle10g)
oracle10g and utl_http [message #689522] Sat, 03 February 2024 00:25 Go to next message
aabunarr
Messages: 1
Registered: February 2024
Junior Member
hi..
i hope this message finds you well...

i am using oracle 10g r2
and facing the problem connecting to web service


     *
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1577
ORA-28750: unknown error
ORA-06512: at line 1
"

by defualt i setup a wallet by orapki
and still get error


please any help

regards
Re: oracle10g and utl_http [message #689523 is a reply to message #689522] Sat, 03 February 2024 01:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Indent the code, use code tags and align the columns in result.
Make sure that lines of code do not exceed 100 characters when you format.

Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.


What is the statement you executed?
What credentials require the web service?

Re: oracle10g and utl_http [message #689525 is a reply to message #689522] Sun, 04 February 2024 09:25 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
I assume it's an HTTPS and not a plain HTTP request that's failing.
The request is probably using a newer protocol that's not supported by your older 10g database.

$ oerr ora 28750
28750, 00000, "unknown error"
// *Cause:   An Oracle Security Server error of an unspecified type occurred.
// *Action:  Enable tracing to determine the exact cause of this error.
//           Contact Oracle customer support if needed.

[Updated on: Sun, 04 February 2024 09:36]

Report message to a moderator

Previous Topic: Evaluating a sys_context call in a predicate
Next Topic: Dad, Grand Pa and Great Grand Pa !
Goto Forum:
  


Current Time: Mon May 27 00:26:57 CDT 2024