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

I forgot to mention platform and version stuff...

HP 9000/735 running HP-UX 9.01

Oracle 7.1.6.2.0

PL/SQL Release 2.1.6.2.0

>
> 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
>
> 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 Tue Sep 02 1997 - 00:00:00 CDT