ORA-7445 [PMUCDST+4] Executing PL/SQL Code (Doc ID 2025933.1)

Last updated on JUNE 09, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Starting with 12.1.0.1, the execution of a PL/SQL code where a collection type is used, fails with ORA-3113 from within a SQL*Plus session and alert.log file shows:

Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x48] [PC:0x7FEF02DF11D, pmucdst()+29]
Errors in file C:\ORACLE\diag\rdbms\jeab9\jeab9\trace\jeab9_ora_10248.trc  (incident=45216):
ORA-07445: exception encountered: core dump [pmucdst()+29] [ACCESS_VIOLATION] [ADDR:0x48] [PC:0x7FEF02DF11D] [UNABLE_TO_READ] []
Incident details in: C:\ORACLE\diag\rdbms\jeab9\jeab9\incident\incdir_45216\jeab9_ora_10248_i45216.trc


The incident trace shows :

*** 2015-04-21 16:19:31.942
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=d4hk5dbc4sdwv) -----
DECLARE
   TYPE transaction_details_rec IS RECORD
      (transaction_id            NUMBER,
       order_no                  VARCHAR2(12),
       line_no                   VARCHAR2(4),
       release_no                VARCHAR2(4),
       date_created              DATE);

   TYPE transaction_details_table IS TABLE OF transaction_details_rec INDEX BY BINARY_INTEGER;
      get_trans_details_table transaction_details_table;

   TYPE multiple_receipt_rec IS RECORD
      (receipt_no   NUMBER);

   TYPE multiple_receipt_table IS TABLE OF multiple_receipt_rec INDEX BY BINARY_INTEGER;
      get_multiple_receipt_table multiple_receipt_table;
...
...
         get_multiple_receipt_table.Delete(get_multiple_receipt_table.FIRST);
           END IF;
        END IF;  
        COMMIT;
     END LOOP;
  END IF;
END;

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
000007FF5A5F2C88       114  anonymous block
 
----- Call Stack Trace -----
... pmucdst pmusepfre_Element_Page_Free pmuscprs_Compress pmuscprs_Compress pmuscprs_Compress pmuscprs_Compress pmusdel_Delete_Element pmucdel petid2
pevm_icd_call_common pfrinstr_ICAL pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe kpoal8 opiodr ...


The same PL/SQL code did run fine in 11.2.

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