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

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