My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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