ANYDATA.CONVERTOBJECT() WITH A COMPLEX OBJECT TYPE FAILS with ORA-3113 and ORA-07445 [KADACCESS()] (Doc ID 1549424.1)

Last updated on DECEMBER 13, 2022

Applies to:

Symptoms

When anydata.convertObject() is called from a PL/SQL block with an uninitialized, complex object type, an ORA-3113 and ORA-7445 [kadaccess()] occurs.  

For example:
 

 

declare
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 18236
Session ID: 21 Serial number: 5955


Trace file shows:

ORA-07445: exception encountered: core dump [kadaccess()+2280] [SIGSEGV]

  kadaccess()+2267 (0x2af7cbf) mov %ax,(%rdx)
  kadaccess()+2270 (0x2af7cc2) jmp 0x2af7ccf
  kadaccess()+2272 (0x2af7cc4) mov (%rdx),%rdx
  kadaccess()+2275 (0x2af7cc7) mov $0xffffffff,%eax
> kadaccess()+2280 (0x2af7ccc) mov %ax,(%rdx)
  kadaccess()+2283 (0x2af7ccf) mov 0x18(%rbp),%rax
  kadaccess()+2287 (0x2af7cd3) movl $0x0,(%rax)
  kadaccess()+2293 (0x2af7cd9) jmp 0x2af7617
  kadaccess()+2298 (0x2af7cde) movzwl -0xc(%rbp),%esi

  ----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x730f8730       332  SYS.XMLTYPE
0x6d440870         6  anonymous block

----- Call Stack Trace -----

skdstdst  ksedst1  ksedst  dbkedDefDump  ksedmp ssexhd  sighandler  kadaccess
 qmxtkCreateFromAnyData  qmxtkConsFromAnydata  spefcpfa  spefmccallstd  
pextproc  peftrusted  psdexsp  rpiswu2  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  libc_start_main  start

Cause

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