My Oracle Support Banner

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: to - Release: 9.2 to 11.2
Information in this document applies to any platform.


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

create or replace function tfunc(arg1 in blob) return clob
is begin
return null;
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)
SELECT tfunc_synonym(ctab)
INTO out_chime
FROM ttable
WHERE id = TO_NUMBER(in_id);
END chime_test;
show errors;

9i/10g Output:

-------- -----------------------------------------------------------------
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
3.trc (incident=27795):
ORA-07445: exception encountered: core dump [phnr_resolve()+2756] [SIGSEGV]
[ADDR:0x0] [PC:0x10816C144] [Address not mapped to object] []


To view full details, 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 a vibrant support community of peers and Oracle experts.