ORA-29261 Error when using HTTPURITYPE with HTTPS URL

(Doc ID 2072447.1)

Last updated on OCTOBER 01, 2017

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


On when using SYS.HTTPURITYPE with HTTPS URL it fails with:

SQL> show user
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 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.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms