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: 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

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
  Symptoms
  Cause
  Solution
  References

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.