ORA-7445 [opipls] from EXECUTE IMMEDIATE in PLSQL (Doc ID 1670241.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

1. Following error reported in the alert log:

ORA-07445: exception encountered: core dump [opipls()+11512] [SIGSEGV] [ADDR:0x14] [PC:0x103CA75F8] [Address not mapped to object] []


2. The call stack may look like:

... opipls opiodr rpidrus skgmstack rpidru rpiswu2 rpidrv psddr0 psdnal pevm_EXIM pfrinstr_EXIM pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe kpoal8 ...


3. In trace file you see sql with 'EXECUTE IMMEDIATE'

 LibraryHandle:  Address=150d9595e0 Hash=44f2c6c2 LockMode=N PinMode=0 LoadLockMode=0 Status=VALD
       ObjectName:  Name=declare
  stmt varchar2(200);
  cnt number;
BEGIN
    if sys.dbms_standard.dictionary_obj_type = 'USER' THEN
      stmt := 'DELETE FROM SDO_GEOM_METADATA_TABLE ' ||
    ' WHERE SDO_OWNER = :owner ';
      EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;  <<--------------------------------------------------------------------------- EXECUTE IMMEDIATE

      stmt := 'DELETE FROM SDO_MAPS_TABLE ' ||
   ' WHERE SDO_OWNER = :owner ';
      EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;   <<--------------------------------------------------------------------------- EXECUTE IMMEDIATE

      stmt := 'DELETE FROM SDO_CACHED_MAPS_TABLE ' ||

 

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