Re: ORA-04028: cannot generate diana for object ACCOUNT.TBL

Peter Mroz (junkpmroz_at_junkdomaincorp.com) wrote:
: I'm getting the following error message when I try to create a view with
: an embedded PL/SQL function:
 

: ORA-04028: cannot generate diana for object L1234.XY_BBB

04028, 00000, "cannot generate diana for object %s%s%s%s%s" // *Cause: Cannot generate diana for an object because of lock conflict. // *Action: Please report this error to your support representative.

: Here's the simplified sequence of events:
 

: 1. Data is stored in the account L1234 in three tables that have
: identical columns:
 

: L1234.XY_AAA
: L1234.XY_BBB
: L1234.XY_CCC
 
: 2. I create a new account called L1234_VIEW, whose purpose is to contain
: views onto L1234
 

: 3. I create a view that contains the union of all three tables
 

: create or replace view L1234_VIEW.XY_ALL as
: select a,b,c,d,e, 'A' source from L1234.XY_AAA union
: select a,b,c,d,e, 'B' source from L1234.XY_BBB union
: select a,b,c,d,e, 'C' source from L1234.XY_CCC;
 

: 4. I then create a view onto L1234_VIEW.XY_ALL that filters stuff out
: between AAA, BBB, and CCC, using a PL/SQL function. This is the step
: that fails, giving me the above-mentioned error message.
 

: create or replace view L1234_VIEW.XY_FILTER as
: select * from L1234_VIEW.XY_ALL
: where
: source = L1234_VIEW.filter_source(a, b, c);
 

: ORA-04028: cannot generate diana for object L1234.XY_BBB

: I must have outdated Oracle 7 manuals because error message ORA-04028 is
: not listed.
 

: If you have any ideas email me or post.
 

: Thanks a bunch,
: Peter

: PS (prevent spam): to email me remove the words junk from my address
 

: --
: Peter Mroz Domain Solutions Corporation
: Tel: 610-892-7540 1023 East Baltimore Pike, Suite 205
: Fax: 610-892-7616 Media, PA 19063
Received on Fri Sep 05 1997 - 00:00:00 CDT