ORA-07445 [_memcpy()] When Using Bind Variable To Pass a Namespace In EXTRACTVALUE (Doc ID 1479464.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

When in the ExtractValue function the namespace is passed with a Bind Variable or a PL/SQL variable, example

 
the query raises ORA-07445: [_memcpy].
----- Call Stack Trace -----
skdstdst ksedst dbkedDefDump ksedmp ssexhd memcpy qmxtrtGetNamespace qmxtrtComposeQueryPath qmxtr2oExtrOverExtr $cold_qmxtr2oExtractOverOpt kokqoxml tOverOpt kokqbpo kokqbpt
kokqpare kokqpoqb kokqpqb kokqpqbc2 kokqpaqb opitca kksFullTypeCheck 144 rpiswu2 kksSetBindType kksfbc opiexe opipls opiodr rpidrus
skgmstack rpidru rpiswu2 rpidrv psddr0 psdnal pevm_EXECC pfrinstr_EXECC pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe kpoal8
opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real ssthrdmain main main_opd_entry

It works fine when the variable is substituted with a literal

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