My Oracle Support Banner

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

Last updated on MARCH 04, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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

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
Symptoms
Cause
Solution
References


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