1

Topic: UTL_HTTP ORA-28788: user provided invalid information

Hello
I try to receive from a site the answer on https oracle returns ORA-28788
I replace on http transits
Help where to dig that incorrectly or does not suffice?

DECLARE
req UTL_HTTP.REQ;
resp UTL_HTTP.RESP;
walletdir VARCHAR2 (100)
: = ' file:C:\oracle\product\12.1.0\db_1\NETWORK\wallet ';
walletpass VARCHAR2 (100): = ' password ';
targeturl VARCHAR2 (100): = ' https://www.google.com ';
BEGIN
UTL_HTTP.SET_WALLET (walletdir, walletpass);
req: = UTL_HTTP.BEGIN_REQUEST (targeturl);
resp: = UTL_HTTP.GET_RESPONSE (req);
UTL_HTTP.END_RESPONSE (resp);
DBMS_OUTPUT.PUT_LINE (' HTTP response status code: ' || resp.status_code);
DBMS_OUTPUT.PUT_LINE (' HTTP response reason: ' || resp.reason_phrase);
END;

2

Re: UTL_HTTP ORA-28788: user provided invalid information

Whether there are three axes on a wallet?

3

Re: UTL_HTTP ORA-28788: user provided invalid information

Full chmod;
did not understand a question?

4

Re: UTL_HTTP ORA-28788: user provided invalid information

daaapd;
If you about access that access are both on reading and on record system under Windows

5

Re: UTL_HTTP ORA-28788: user provided invalid information

daaapd wrote:

Full chmod;
did not understand a question?

smile
The colleague offers
chmod 777 <wallet>

6

Re: UTL_HTTP ORA-28788: user provided invalid information

daaapd;
The server has direct access to https or stopping through a proxy is necessary
utl_http.set_proxy (' myproxy:8081 ');

7

Re: UTL_HTTP ORA-28788: user provided invalid information

Wandering Ajtist, proxy is not present directly walks
What can  I can not understand?

8

Re: UTL_HTTP ORA-28788: user provided invalid information

Wandering Ajtist;
Whether it was necessary in listener.ora to register purse parameters (wallet)?

9

Re: UTL_HTTP ORA-28788: user provided invalid information

daaapd;
The sir, show that you made, beginning from loading of certificates in wallet.

10

Re: UTL_HTTP ORA-28788: user provided invalid information

env;
At me at first produced an error on performance of my script
ora-29024 Failure at certificate check
I added a purse
[code]
[code]> set WALLETLOC=C:\oracle\product\12.1.0\db_1\NETWORK\wallet
> mkdir %WALLETLOC %
> mkstore-wrl %WALLETLOC %-create
[/code] [/code]
Added in script UTL_HTTP.SET_WALLET (walletdir, walletpass);
And this error left
But there was ora-28788 a user gave the incorrect information

11

Re: UTL_HTTP ORA-28788: user provided invalid information

daaapd;
paint that in what order did.
There is a heap of nuances, therefore the more information result, the better.

12

Re: UTL_HTTP ORA-28788: user provided invalid information

env;
All painted more did than nothing

13

Re: UTL_HTTP ORA-28788: user provided invalid information

daaapd;
Certificates in wallet did not add?

14

Re: UTL_HTTP ORA-28788: user provided invalid information

env;
Is not present there were already after creation wallet

15

Re: UTL_HTTP ORA-28788: user provided invalid information

Prompt, who can on another implemented access from  to https

16

Re: UTL_HTTP ORA-28788: user provided invalid information

daaapd wrote:

who can on another implemented access from  to https

HTTPS and Yandex certificate

17

Re: UTL_HTTP ORA-28788: user provided invalid information

Elic wrote:

it is passed...
HTTPS and Yandex certificate

Thanks the link helped it was necessary to export correctly from  the certificate of a site and to transport it in wallet