PLS-00801: Internal Error [1002] Compiling Pl/Sql With Synonym Of Operator Object (Doc ID 1262737.1)

Last updated on JULY 17, 2017

Applies to:

PL/SQL - Version: 9.2.0.8 to 11.2.0.2 - Release: 9.2 to 11.2
Information in this document applies to any platform.

Symptoms

PLS-00801 error reported from 9i/10g database,
and
ORA-03113 / ORA-07445 reported from 11g database when
PL/SQL block references Operator object by a synonym.

Testcase:
create or replace function tfunc(arg1 in blob) return clob
is begin
return null;
end;
/
create or replace operator tfunc_operator
binding (blob) return clob using tfunc;
--
create synonym tfunc_synonym for tfunc_operator;
--
create table ttable (id number, ctab blob);
create or replace procedure chime_test(in_id in varchar2, out_chime out clob)
is
begin
SELECT tfunc_synonym(ctab)
INTO out_chime
FROM ttable
WHERE id = TO_NUMBER(in_id);
END chime_test;
/
show errors;

9i/10g Output:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PLS-00801: internal error [1002]
3/3 PL/SQL: SQL Statement ignored
3/10 PL/SQL: ORA-06544: PL/SQL: internal error, arguments: [1002], [],
[], [], [], [], [], []

11g Output:

ERROR at line 1:
ORA-03113: end-of-file on communication channel
..
alertlog lists:
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0]
[PC:0x10816C144, phnr_resolve()+2756] [flags: 0x0, count: 1]
Errors in file
/refresh/64bit/app/oracle/diag/rdbms/ref1121u/REF1121U/trace/REF1121U_ora_203
3.trc (incident=27795):
ORA-07445: exception encountered: core dump [phnr_resolve()+2756] [SIGSEGV]
[ADDR:0x0] [PC:0x10816C144] [Address not mapped to object] []

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