Re: Re-compiling oracle reports

Hi John,

Why don't you use Project Builder? You can use Project->Compile All there.

I hope this will help.

john dear wrote:
>
> 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.

-- 
Valery A. Sorokin
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoft.ru
http://www.dd.ru