Re: Performance of calling a report from Forms 5.0 problem

Which version of Oracle DB do you use? You have to use 7.3.4 or 8.0.4 or higher for Developer 2.1

I hope this will helps you.

Raymond Siao wrote:
>
> I used Forms 4.5 in the past and now I am trying to update them into
> Forms 5.0. However, When I tried to call out a report in a form using
> "RUN_PRODUCT", it takes much longer time, approx 2min, to show up the
> parameter form.
>
> The called report has some PLSQL in its triggers. When I removed all
> the triggers as well as the formula columns, the performance resume as
> fast as before.
>
> But the question is, why the report can be loaded so quickly in Forms
> 4.5 but now it takes 7-8 times longer in Forms 5.0 to load it? After
> loading the report, the performance is OK when running the report.
>
> Any help would be much appreciate.
>
> Thank in advance.

-- 
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_prosoftmpc.msk.su
http://www.dd.ru