Re-compiling oracle reports

From: john dear <johnd_at_abc.def.com.au>
Date: Thu, 28 Jan 1999 11:58:57 +1000
Message-ID: <36AFC461.7B08576E_at_abc.def.com.au>

[Quoted] [Quoted] An issue we have run into with Reports is that each report needs to be re-compiled if database objects on which they depend are re-created. We have identified three situations in which this happens.

1. DML statements such as "delete from table_name ... " If the table is later dropped and re-created the report will not run without recompilation.
2. Cursor declarations such as "declare cursor c1 as select ... from table_name ..." If the table is later dropped and re-created the report will not run without recompilation.
3. Stored procedures called from within the reports. If the stored procedure is re-compiled with "alter procedure procedure_name compile", the report will not run without recompilation.

There could be more we have not encountered yet.

Unfortunately, we have not been able to find a way of batch-compiling the reports. So it looks as if each report needs to be brought into orarep30m, and recompiled manually using point and click.

Is there a way of batch-compiling reports? Alternatively, is there a way of telling runrep30m to compile "on the fly" at run time?

We are using release 2.1 of Developer 2000 on SPARC with Reports 3.0 and Oracle 8.0.4. Received on Thu Jan 28 1999 - 02:58:57 CET