ORA-29261 Error when using HTTPURITYPE with HTTPS URL
(Doc ID 2072447.1)
Last updated on APRIL 12, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
On 11.2.0.4 when using SYS.HTTPURITYPE with HTTPS URL it fails with:
SQL> show user
USER is "SYS"
SQL> declare
url varchar2(500);
2 3 dummy clob;
4 begin
5 UTL_HTTP.set_wallet('file:/usr/oracle/exports/exp001/wallet', 'welcome1');
6 url := 'https://wwwdev.gpirsscanner.ford.com/GpdodsUiWeb/ValidateVehicleFeaturesController?01=01DE1A0000=DE1A0000.=.2011=2011CPPBCU=CPPBCUENDPOINT=ENDPOINTT=TCDE=CDE';
7 select httpuritype(url).getclob() dummy into dummy from dual;
8 dbms_output.put_line('wayne'||substr(dummy,1,200));
9 dbms_output.put_line('wayne'||substr(dummy,201,200));
10 end;
11 /
ERROR
-----------------------
declare
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1817
ORA-29261: bad argument
ORA-06512: at "SYS.HTTPURITYPE", line 34
ORA-06512: at line 7
The issue does not reproduce with HTTP URL.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |