ORA-4028 ERROR WHILE RECOMPILING PL/SQL PACKAGE (Doc ID 1505092.1)

Last updated on NOVEMBER 27, 2012

Applies to:

PL/SQL - Version 10.2.0.5 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.

Symptoms

Attempting to compile a package fails after the creation of a dependent view with:

ORA-04028: cannot generate diana for object SCOTT.V_TEST


Testcase Scenario:

SQL> CREATE OR REPLACE VIEW V_TEST
(a, b)
AS
select a,b from test
/
  2 3 4 5
View created.

SQL> alter package p_test compile;
alter package p_test compile
*
ERROR at line 1:
ORA-04028: cannot generate diana for object SCOTT.V_TEST

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