What is the Diana_version$ table specifically for?
Hello,
There are times when compiling Oracle Forms that the following error is created - “FRM-30085: Unable to adjust form for output.”.
In searching that error message, we came across the following query:
select 'alter '||do.object_type||' ' || owner || '.'||do.object_name||' compile;'
from dba_objects do, sys.diana_version$ dv
where dv.obj# = do.object_id
and do.timestamp <> to_char(dv.stime, 'YYYY-MM-DD:HH24:MI:SS')
We then ran the ALTER PACKAGE statements that were outputted from the query. NOTE: Before running the ALTER PACKAGE statements, that package statuses were checked and the packages were VALID.