My Oracle Support Banner

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 and later
Oracle 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.


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 := '';
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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.