UTL_HTTP Receives ORA-700 [kgerev1] /ORA-00600: [NHPMAPIOERROR_2 - 7]

(Doc ID 2331494.1)

Last updated on NOVEMBER 22, 2017

Applies to:

PL/SQL - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.0.2 or 12.2.0.1 version, the following error occurs when making a utl_http call with a JSON request:

ERROR
-----------------------

ORA-00600: internal error code, arguments: [] ...

----- PL/SQL Call Stack -----
object line object
handle number name
0x96cedc38 635 package body SYS.UTL_HTTP
0x96cedc38 1248 package body SYS.UTL_HTTP

STACK TRACE:
pihtRaiseReqError0 <- pihtpg <- spefcifa <- spefmccallstd <- pextproc <- peftrusted
<- psdexsp <- rpiswu2 <- kxe_push_env_internal_pp_
<- kkx_push_env_for_ICD_for_new_session <- psdextp <- pefccal <- pefcal <- pevm_FCAL
<- pfrinstr_FCAL <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe
<- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
<- ssthrdmain <- main

or if patch for bug:18865932 is installed, the error would be:


Error: ORA-00700 [kgerev1] [600] [600] [700]
Error Stack:
ORA-00700: soft internal error, arguments: [kgerev1], [600], [600], [700] ...

Main Stack:
pihtRaiseReqError0 <- pihtpg <- spefcifa <- spefmccallstd <- pextproc <- peftrusted
<- psdexsp <- rpiswu2 <- kxe_push_env_internal_pp_
<- kkx_push_env_for_ICD_for_new_session <- psdextp <- pefccal <- pefcal <- pevm_FCAL
<- pfrinstr_FCAL <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe
<- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
<- ssthrdmain <- main

Changes

 none particular but there is some suspicion that this worked fine in 11gR2.

Cause

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