CODEWITHSUNDEEP
oracle-databaseapisoaporacle11g
Nick S
Nick S

Reputation: 11

Error ORA-29259: end-of-input reached calling utl_http.begin_request

I'm trying to connect to the Royal Mail SOAP API but can't get past the the begin request stage.

Certificates have been added to the wallet, it works fine for DPD and other Web APIs.

DECLARE
    wk_http_request utl_http.req;
BEGIN
    utl_http.set_wallet('file:/app/oracle/admin/A11/wallet', NULL);
    wk_http_request := utl_http.begin_request('https://api.royalmail.net/shipping/v2', 'POST', utl_http.http_version_1_1);
END;
/

Gives Error:

ORA-29259: end-of-input reached
ORA-06512: at "SYS.UTL_HTTP", line 1128
ORA-06512: at line 5
29259. 00000 -  "end-of-input reached"
*Cause:    The end of the input was reached.
*Action:   If the end of the input is reached prematurely, check if the input
           source terminates prematurely.  Otherwise, close the connection
           to the input.

I get the same whether I include the set wallet line or not.

This runs without error:

DECLARE
    wk_http_request utl_http.req;
BEGIN
    utl_http.set_wallet('file:/app/oracle/admin/A11/wallet', NULL);
    wk_http_request := utl_http.begin_request('https://api.dpd.co.uk', 'POST', utl_http.http_version_1_1);
END;
/

Can anyone connect to the Royal Mail API via Oracle PL/SQL? Our version is 11.2.0.3.0.

Upvotes: 1

Views: 22213

Answers (1)

Jorge Rojas Z.
Jorge Rojas Z.

Reputation: 21

I'm facing the same error with Oracle DB 11.2.0.4 and trying to connect oracle ERP Cloud and oracle Integration Cloud Service.

My research concluded that Oracle 11g need to be patched in order to use TLS 1.2 according to this link.

Here's the list of TLS certificates that royalmail handles

List of TLS supported by https://api.royalmail.net

And here's the list of TLS certificates that api.dpd.co.uk handles

List of TLS supported by https://api.dpd.co.uk

Oracle 11g initially doesn't work with TLS 1.2, so you need to patch your DB in order to use this certificate.

Hope this may be helpul.

Upvotes: 2

Related Questions