Re: Recomplie Oracle Report 3.0

"...
Using packages rather than stand–alone stored procedures results in the following improvements:

• The entire package is loaded into memory when a procedure within the package is called for the first time. This load is completed in one operation, as opposed to the separate loads required for standalone procedures. Therefore, when calls to related packaged procedures occur, no disk I/O is necessary to execute the compiled code already in memory.
• A package body can be replaced and recompiled without affecting the specification. As a result, objects that reference a package’s constructs (always via the specification) never need to be recompiled unless the package specification is also replaced. By using packages, unnecessary recompilations can be minimized, resulting in less impact on overall database performance."

Freddy Vanzeebroeck wrote:
>
> You can have this problem when there is a call to a function or procedure
> in a stored package from your report.
> If this is so, get the function or procedure out of the package, and create
> it as an independant stored function or procedure and call this one from
> your report. The problem should be gone.
>
> Fred.
>
> netz <fenghm_at_singnet.com.sg> wrote in article
> <7cd4cn$3mc$1_at_mawar.singnet.com.sg>...
> > Hi !
> >
> > Some problems we are facing when use Oracle Report Builder 3.0.5.
> >
> > 1) We are using Oracle 8.0.5 on NT platform.
> >
> > 2) We create a report in development environment and it works fine .
> >
> > 3) Once deliver the report file (.rep file) with Form file (.fmx) to
> > production environment, the report file must be recompiled on product
> > machine. Otherwise the report won't work when it is called from Form
> > Program.
> >
> >
> > Is there anybody know about this problem and what is the solution to it.
> >
> > Thanks !
> >
> >
> >

-- 
Valeri Sorokine
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