API_CREATE_ORA_DEM_USER Fails With ORA-29273 and ORA-12535 (Doc ID 2303321.1)

Last updated on SEPTEMBER 22, 2023

Applies to:

Symptoms

1) Executed the following store procedure:

execute API_CREATE_ORA_DEM_USER ('<USER>', '<PASSWORD>', '<FIRSTNAME>', '<LASTNAME>', '37', ' ', ' ', '<EMAIL>', 9, 4 ,'Demand Management', '' ,'UPDATE');

And got the following error:

execute API_CREATE_ORA_DEM_USER ('<USER>', '<PASSWORD>', '<FIRSTNAME>', '<LASTNAME>', '37', ' ', ' ', '<EMAIL>', 9, 4 ,'Demand Management', '' ,'UPDATE');

ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1817
ORA-12535: TNS:operation timed out
ORA-06512: at "DEMANTRA.HELPER", line 2135
ORA-06512: at "DEMANTRA.API_CREATE_ORA_DEM_USER", line 529
ORA-06512: at line 1
29273. 00000 - "HTTP request failed"
*Cause: The UTL_HTTP package failed to execute the HTTP request.
*Action: Use get_detailed_sqlerrm to check the detailed error message.
  Fix the error and retry the HTTP request.

Subsequent attempts to use new connection information fails

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. execute API_CREATE_ORA_DEM_USER
2. Observe the noted error
3. Observe that attempts to log in to collaborator workbench fail using the updated information.

Changes

Cause

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