Unable to generate diana - Oracle 7

Hi all,

I have an outer join select in a Forms 3.0 form, querying an Oracle 7 database (on VAX/VMS).

The form of my select (not exact but similar) is this:

select t1.a, (t1.b-t2.c)*t1.d+(t2.e-t1.g) calc_name from table_one t1,

     table_two t2,
where t1.k > t2.j(+)

I get the following error:

ORA-04028 Cannot generate diana for object table_one

Does this sort of error mean anything to anyone? The error number is not in any documentation we have, the numbers jump from ORA-04021 to ORA-04029 and these are System Memory errors. This makes no sense. What is a diana?

Very strange. Thanks for your help.

Mark

-- 
Mark Gebbie  BHP Information Technology
Analyst/Programmer BHP Service Companies
______________________________
Level 7, 120 Collins St, Melbourne Vic Australia 3000
Telephone  +61 (03) 9652 7491
Facsimile  +61 (03) 9652 7580