I believe that the diana is similar to what ADA has. It is way of
describing the language, using the language. I've never seen it come up in
a select statement before, usually a problem in PL/SQL statements.
Thor HW
Mark Gebbie wrote in message <34E91D9B.BCA62AA_at_bhp.com.au>...
>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
Received on Tue Feb 17 1998 - 00:00:00 CST
